Assignment Task
Overview – In this final piece of coursework, you will be working with a chunk of real-world data, namely a collection of approximately 100,000 tweets harvested from Twitter (provided on Moodie in a database-ready format). The data is provided as a collection of files used to create a “single giant table” representation of the data. i.e., the scripts will create a single table with approximately 100,000 rows and a large number of attributes. These attributes will contain all the data about the tweets, but the table will be very poorly normalised and will be an inappropriate design for data storage and usage.
Your task in this coursework is to develop a more appropriate design for the database, write SQL scripts to copy the data from the single table to the tables in your design, and construct queries to answer some questions about the data set using your new tables. In overview, the task can be broken down into the following steps.
1. Download the file -thetables.zip” from Moodie. and use it to create and populate the “giant table” representation of the data.
2. Investigate the data, and consult the Twitter documentation, to understand its structure and the meaning of its fields.
3. Document the flaws in the design, including but not limited to its poor normalization. Where appropriate, this should ideally be done using the language of the theory of database design, i.e., stating FDs (functional dependencies) considered to be present in the data and showing that the giant table is not well-normalised (not in 3NF).
4. Decide on an improved and normalized design for the data, and document this design. Your new design should be in 3NF and should addresses the design issues from the giant table that you identified above.
5. Write SQL scripts to create your new tables and to appropriately copy data from the giant table into your new tables. 6. Explore the data using SQL queries, and write an SQL script that answers the questions outlined at the end of this document. Your submission should include all the SQL scripts created above, as well as a PDF file describing the design issues, your new design, query results, and any other conclusions you may have.
This IT Assignment has been solved by our IT experts at Schooling Best. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.
