1. Provide a revised ER diagram. Use the notation of the lecture to draw the ER model and describe the changes to the model briefly in continuous text (changes may or may not arise from the feedback on report A and the experience in the implementation process.
6|Page
- Provide a revised relational model/relational database schema normalized to 3NF(some tables might be in 2NF if a clear rationale is provided – do not “over normalize” the database; keep the design as efficient and simple as possible). Use the notation of the lecture to draw the final model and document the normalization process in a suitable way. Describe the model in continuous text.
- Create a relational database in Oracle based on your relational database schema. Populate the tables of the database with at least ten sample records in each table. Use data from the above scenario or add data from your own knowledge and understanding. Ensure that you have adequate data to run and test queries and showcase the database.
- Develop the above SQL queries for the database. Provide printouts of the results of the queries (e.g., screenshots) in the report.
- Provide a discussion of any noteworthy features (beyond standard features, max. 500 words, around 1 page), a description of possible improvements (useful future extensions, max. 500 words, around 1 page) and a discussion of issues and ethical considerations (potential impacts on stakeholders, potential risks and misuses, max. 500 words, around 1 page).
- Provide a critical reflection on the group work itself (see next section).
- Final presentation: This is the report final presentation. Your team will be presenting your database system to hospitals similar to IBC. (i.e. you need to convince your audience to purchase your product.
0 comments