- In this file, you will find two database project ideas. You must choose one of them to design and implement.
- You can work on this project as a group (minimum 3 and maximum 4 students). Each group member must submit the project individually with all group member names mentioned in the cover page.
- This project worth 10 marks and will be distributed as in the following:
- Design the database, following an ER model.(3 marks)
- Tables before Normalization. (1.5 marks)
- Tables after Normalization(1.5 marks)
- Use MySQL or any other database to create the normalized tables and
- Execute the requested sample queries. (2 marks)
- Each student must submit one report about his/her chosen Project via the Blackboard (Email submission will not be accepted which will be awarded ZERO marks) containing the following:
- ER Diagram.
- All schemas before normalization.
- All schemas after normalization.
- All SQL statements of:
- Creating tables.
- Inserting data in tables.
- All requested queries/results.
- Screenshots from MySQL (or any other software you use) of all the tables after population and queries results.
populate your tables with at least 5 rows.(2 marks)
0 comments