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 Find and critique a dataset 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. Assess the dataset in your report. You should use the criteria used in discussion Quality level of detail, documentation, interrelation, use, discoverability and assess the terms of use as in discussion 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 Model your data Draw a complete ER 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 Add cardinality to your ER diagram. If there are any structures that are not compatible with the Relational model, draw a second diagram showing the modified structure. List database tables and fields. Evaluate the tables against the normal forms and adjust to ensure that your database will be at least in NF Include an evaluation of which normal forms your database is in If it isn't in higher forms, such as BCNF or NF justify your decision not to normalise further. Stage Create the database Build the database structure in MySQL in the lab environment. Record all CREATE commands used in your report. 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. 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. List SQL commands that answer questions identified in Stage Step 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
