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

small number of users

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;

• firstly, How the data is stored and manipulated
• secondly, Who can access the data
• thirdly, How much data can be stored

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