Exercise 2

1. Think of different users for the database of Figure 1.2. What type of applications would each user need? To which user category would each belong and what type of interface would they need?

2. if you were designing a Web-based system to make airline reservations and to sell airline tickets, which DBMS Architecture would you choose from Section 2.5? Why? Why would the other architectures not be a good choice?

3. Consider Figure 2.1.  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 forces that a column or a group of columns must be unique across all rows in the table.  For example, in the STUDENT table, the StudentNumber column must be unique (to prevent two different students from having the same StudentNumber).  Identify the column or the group of columns in the other tables that must be unique across all rows in the table?