What types of additional information and constraints would you like to represent in the schema?

Think of different users for the database . What types of applications would each user need? To which user category would each belong, and what type of interface would each need?

Database System Concepts and Architecture

Choose a database application with which you are familiar. Design a schema and show a sample database for that application, using the notation of Figures 1.2 and 2.1.

What types of additional information and constraints would you like to represent in the schema? Think of several users of your database, and design a view for each.

If you were designing a Web-based system to make airline reservations and sell airline tickets, which DBMS architecture would you choose from Section 2.5?

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

Identify the column or the group of columns in the other tables that must be unique across all rows in the tab