Answer to Question #174837 in Databases | SQL | Oracle | MS Access for Prisy

Question

1. If you were designing a Web-based system to make airline reservations and sell airline tickets,

a. Which DBMS architecture would you choose from and why?

b. Why would the other architectures not be a good choice?

2. Design a database for an airline. The database must keep track of customers and their reservations, flights and their status, seat assignments on individual flights, and the schedule and routing of future flights. Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.

Answer 1

1

a. The best architecture

The best architecture for a web design will be a Three-tier client/server architecture because:

1. The web user interface is placed in the client system.
2. The database server contains the DBMS
3. Web/application server will handle the application logic of the system
4. Web server can handle those transactions validate the data and manipulate database accordingly.
5. The web user interface is vital as different types of users e.g. naive users interact with the system

b. Architectures That are not suitable

1. In a centralized DBMS architecture, DBMS functionality and user interface are both performed on the same system hence not appropriate for web based system.
2. In a Tier-Tier client/Server architecture can be a burden if business logic is placed in database server.

2 Airline Database Design

Relation shema :

Primary Keys of the Schema:

ForeignKeys of the schema: