Posted: January 2nd, 2023
Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates
For This or a Similar Paper Click To Order Now
For it 244
Answer Question one
Here are four mini-world entities and four mini-world relationships for a database of King Abdulaziz Airport:
1.Airport: represents the airport itself, with attributes such as its name, location, and number of terminals.
2.Flight: represents a specific flight, with attributes such as its flight number, departure and arrival times, and origin and destination airports.
3.Passenger: represents a passenger traveling on a flight, with attributes such as their name, contact information, and passport number.
4.Airport staff: represents employees of the airport, with attributes such as their name, job title, and employee ID.
1.Departure: represents a flight departing from the airport, with a many-to-one relationship between flights and the airport (multiple flights can depart from the same airport).
2.Arrival: represents a flight arriving at the airport, with a many-to-one relationship between flights and the airport (multiple flights can arrive at the same airport).
3.Check-in: represents a passenger checking in for a flight, with a many-to-one relationship between passengers and flights (multiple passengers can check in for the same flight).
4.Works at: represents an airport staff member working at the airport, with a one-to-one relationship between airport staff and the airport (each staff member works at only one airport).
Answer Question Two
Relational model and object-oriented model are two different approaches to organizing and storing data in a database.
Advantages of the relational model:
The relational model is based on the concept of a table, which makes it easy to understand and use.
It is flexible and allows users to easily add, delete, and modify data.
It supports the use of SQL, which is a standard language for interacting with relational databases.
It allows data to be organized in a logical and meaningful way, making it easy to retrieve and manipulate.
It is efficient in terms of storage, as it avoids redundant data and allows for the use of indexes to speed up queries.
Drawbacks of the relational model:
It can be difficult to represent complex relationships between data in a relational model.
It is not always the most efficient option for handling large volumes of data or real-time data.
Advantages of the object-oriented model:
The object-oriented model is based on the concept of objects, which are self-contained entities that encapsulate data and behavior.
It is more flexible than the relational model, as it allows data to be organized in a more natural way that reflects the real-world relationships between objects.
It is easier to represent complex relationships between data in an object-oriented model.
It is well-suited for handling large volumes of data and real-time data.
Drawbacks of the object-oriented model:
It can be more difficult to understand and use than the relational model, as it requires a more advanced understanding of object-oriented programming concepts.
It may not be as efficient in terms of storage, as it can result in more redundant data.
It may not support the use of standard languages like SQL, requiring the use of proprietary languages or APIs to interact with the database.
Place an order in 3 easy steps. Takes less than 5 mins.