This essay focuses on small number of users. which appear in a tweet’s full_text start index and end index: stored the values found in the JSON
id: primary key tweet_id: foreign key, which links to the id field of the tweets table type: possible values found in Question 1(a) value: contains entity text values, which appear in a tweet’s full_text start index and end index: stored the values found in the JSON key indices (2 marks) ICT233 Copyright © 2021 Singapore University of Social Sciences (SUSS) Page 3 of 8 TMA
– July Semester 2021 (ii) Extract entities from every tweet to store into the entities table in the SQLite database. Note that the entities of a tweet can be extracted from the JSON key entities of each tweet. (8 marks) (d) Use SQL statement(s) to identify all unique values in hashtags. (3 marks) (e) Use SQL statement(s) to find all tweets which have a value of hashtags appearing more than 1 time. (5 marks) (f) Use SQL statement(s) to calculate how many t
Databases and spreadsheets (such as Microsoft Excel) are both convenient ways to store information. The primary differences between the two are;
Spreadsheets were originally designed for one user, and their characteristics reflect that. They’re great for a single user or small number of users who. It is don’t need to do a lot of incredibly complicated data manipulation. Databases, on the other hand, are designed to hold much larger collections of organized information—massive amounts, sometimes. Databases allow multiple users at the same time. This is to quickly and securely access and query the data using highly complex logic and language