Choose a database application with which you are familiar. Design a schema and show a sample database for that application, using the notation of Fig- ures 1.2 and 2.1. 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 Fig- ures 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?

In addition to constraints relating the values of columns in one table to columns in another table, there are also constraints that impose restrictions on values in a column or a combination of columns within a table. One such constraint dictates that a column or a group of columns must be unique across all rows in the table. For example, in the STUDENT table, the Student_number column must be unique .

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