Description
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
View attached explanation and answer. Let me know if you have any questions.Hello There!The Project is complete😀I am attaching word file here.Kindly check and let me know in case of any slightest of doubt.If you need more explanation or revision, feel free to ask.I am always here to help😇
College of Computing and Informatics
Project
Deadline: Sunday 12/12/2021@ 23:59
[Total Mark for this Project is 10]
Student Details:
Name: ###
ID: ###
CRN: ###
Instructions:
•
•
•
•
•
•
•
•
•
You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on
Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero mark will be given if you try to bypass the SafeAssign (e.g., misspell words, remove spaces between words,
hide characters, use different character sets, convert text into image or languages other than English or any kind of
manipulation).
Email submission will not be accepted.
You are advised to make your work clear and well-presented. This includes filling your information on the cover page.
You must use this template, failing which will result in zero mark.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the
question.
Late submission will result in ZERO mark.
The work should be your own, copying from students or other resources will result in ZERO mark.
Use Times New Roman font for all your answers.
Project Instructions
Pg. 01
Project Instructions
•
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:
a)
b)
c)
d)
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
populate your tables with at least 5 rows.
(2 marks)
e) 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:
a)
b)
c)
d)
ER Diagram.
All schemas before normalization.
All schemas after normalization.
All SQL statements of:
▪ Creating tables.
▪ Inserting data in tables.
e) All requested queries/results.
•
Screenshots from MySQL (or any other software you use) of all the tables after
population and queries results.
Project Instructions
Pg. 02
•
You are advised to make y...