Question: Stage 1 . Find and critique a dataset 1 . Choose a source of open data. This can be one that you've used earlier in

Stage 1. Find and critique a dataset 1. Choose a source of open data. This can be one that you've used earlier in this module, or it can be a new source. You may also combine two simpler datasets, provided there is benefit in linking them. The data must be open and real (not generated artificially for learning or research), and a normalised, relational model for the data can't have been published already. 2. Assess the dataset in your report. You should use the criteria used in discussion 1.104(Quality, level of detail, documentation, interrelation, use, discoverability) and assess the terms of use (as in discussion 1.206)3. Explain your interest in your report. Why is this an interesting dataset? Give some questions you would like to ask of the dataset that a database application could help with.Stage 2. Model your data 1. Draw a complete E/R model of the data. If you are only implementing a subset of the data structure, justify your decision in the report. All diagrams must be in the report pdf.2. Add cardinality to your E/R diagram. If there are any structures that are not compatible with the Relational model, draw a second diagram showing the modified structure. 3. List database tables and fields. Evaluate the tables against the normal forms and adjust to ensure that your database will be at least in 3NF. Include an evaluation of which normal forms your database is in. If it isn't in higher forms, such as BCNF or 4NF, justify your decision not to normalise further. Stage 3. Create the database 1. Build the database structure in MySQL in the lab environment. Record all CREATE commands used in your report. 2. Enter instance data. This can be a usable sample of the dataset or all the dataset. Detail how you added the data in your report. 3. Reflect on how well the database reflects the data. In your report note one or two points of elements that do or don't work well. 4. List SQL commands that answer questions identified in Stage 1/Step 3. If any can't be answered, explain why.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!