Using the same tweets from:…

Question Answered step-by-step Using the same tweets from:… Using the same tweets from: http://dbgroup.cdm.depaul.edu/DSC450/Module7.txt a third table, now incorporating the Geo table (in addition to tweet and user tables that you already have) and extend your schema accordingly. You do not need to use ALTER TABLE, it is sufficient to just re-create (drop and create) your schema.You will need to generate an ID for the Geo table primary key (you may use any value or reasonable combination of values as long as it is unique) for that table and link it to the Tweet table (foreign key should be in the Tweet). However, that value should be related to the location (i.e., same value for same location) – do not use a simple incremental key or a random key. In addition to the primary key column, the geo table should have the “type”, “longitude” and “latitude” columns. NOTE: that there are no longitude/latitude dictionary keys. Instead, the geo dictionary has a 2-value tuple which are the lon/lat coordinates.Load the tweet data into your new tables. Write and execute a SQL query to do the following. Time and report the runtime of your query. Find tweets where tweet id_str contains “889” or “777” anywhere in the column Write the equivalent of the previous query in python (without using SQL) by reading it from the file. Time and report the runtime of your query. Write and execute a SQL query to do the following. Time and report the runtime of your query. Find how many unique values are there in the “friends_count” column Write the equivalent of the previous query in python (without using SQL) by reading it from the file. Time and report the runtime of your query. Use python to plot the lengths of first 50 tweets (only 50, not all of the tweets) versus the length of the username for the user on a graph. Create a scatterplot. Submit both your python code and the resulting graph file.  Computer Science Engineering & Technology Python Programming DSC 450 Share QuestionEmailCopy link Comments (0)