databases question and need support to help me learn. Instructions: You must submit two separate

databases question and need support to help me learn.

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.
Name: ###
CRN: ###
ID: ###

2 Marks
Learning Outcome(s): CLO1
Instructors: Explain the concepts and architectures involved in the database development.
Question One
Consider a database of King Abdulaziz Airport. For this mini-world example, define four mini-world entities and four mini-world relationships.
2 Marks
Learning Outcome(s): CLO5
Instructors: Compare different database models and implement a database using relational model
Question Two
Discuss the advantage and the drawback of relational and object-oriented models.
2 Marks
Learning Outcome(s): LO3
Instructors: Create Entity-Relationship model, Relational model, and write SQL queries.
Question Three
The French Bakery is a new business project, the owner of the bakery needs a database to keep the essential data and transactions regarding his business. The following requirements of the bakery have been collected:
There are different departments in the bakery business, each department has a name, department number, the number of employees, and manager.
The bakery needs to keep Employee’s name, ID number, Phone number, address, sex, position, and the salary.
To keep contact with customers and provide customer services and marketing, the bakery requires customer’s name, address, Cnumber (which is unique for each customer), email, and the phone number.
The bakery sells many products, each product has a name and a price, and the calories’ amount.
Based on the above requirements, draw each entity with the relative attributes.
2 Marks
Learning Outcome(s): LO3
Instructors: Create Entity-Relationship model, Relational model, and write SQL queries.
Question Four
For the previous question (The French project), complete and build the ER model.
Requirements: 200 | .doc file
Question One
Consider a database of King Abdulaziz Airport. For this mini-world example, define four mini-world entities and four mini-world relationships.
Question Two
Discuss the advantage and the drawback of relational and object-oriented models.
Question Three
The French Bakery is a new business project, the owner of the bakery needs a database to keep the essential data and transactions regarding his business. The following requirements of the bakery have been collected:
There are different departments in the bakery business, each department has a name, department number, the number of employees, and manager.
The database will keep the start date and the end date for each manager.
The bakery needs to keep Employee’s name, ID number, Phone number, address, sex, position, and the salary.
Each employee work for a specific department.
Each employee has a supervisor.
Some employees have more than one position.
To keep contact with customers and provide customer services and marketing, the bakery requires customer’s name, address, Cnumber (which is unique for each customer), email, and the phone number.
The bakery sells many products, each product has a name and a price, and the calories’ amount.
The manager will be responsible of products.
Also, the Quality Department will control the products.
Based on the above requirements, draw each entity with the relative attributes.
Question Four
For the previous question (The French project), complete and build the ER model.