Advantage-drawback of relational and object-oriented models


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.

Request for Solution File

Ask an Expert for Answer!!
Computer Engineering: Advantage-drawback of relational and object-oriented models
Reference No:- TGS03286575

Expected delivery within 24 Hours