Problem 1: Consider a database of King Abdulaziz Airport. For this mini-world example, define four mini-world entities and four mini-world relationships.
Problem 2: Discuss the advantage and the drawback of relational and object-oriented models.
Problem 3: 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.