Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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,
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 only restrictions are: the data must be open; 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 the 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 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 only restrictions are: the data must be open; 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 the 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started