IT403 SEU King Abdulaziz Airport Questions
Description
Q1- Consider a database of King Abdulaziz Airport. For this mini-world example, define four mini-world entities and four mini-world relationships.
Q2-Discuss the advantage and the drawback of relational and object-oriented models.
Q3-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à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à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!mount.
Based on the above requirements, draw each entity with the relative attributes.
Q4- For the previous question (The French project), complete and build the ER model.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."