Project in Fundamentals in Database “IT403”

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.
You are advised to make your work clear and well presented; marks may be reduced for poor presentation. This includes filling your information on the cover page.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
Use Times New Roman font
populate your tables with at least 5 rows.(2 marks)
Late submission will result in ZERO marks being awarded.
The work should be your own, copying from students or other resources will result in ZERO marks.
Everything else is described in the file

Place this order or similar order and get an amazing discount. USE Discount code “GWEXDDSRGCF10” for 10% discount


Order your custom answer