Assignment 2
1. What is a relation?
2. What is a relational database?
3. What is an unnormalized relation? Is it a relation according to the definition of the word relation?
4. How is the term attribute used in the relational model? What is a more common name for attribute?
5. Describe the shorthand representation of the structure of a relational database. Illustrate this technique by representing the database for Colonial Adventure Tours shown in Figures 1-15 through 1-19 in Chapter 1.-In the short-hand representation, each table is listed, and after each table, all the columns of the table are listed in parentheses. Primary keys are underlined.
6. What does it mean to qualify a field name? How would you qualify the Street field in the Customer table?
7. What is a primary key? What is the primary key for each table in the Colonial Adventure Tours
database shown in Figures 1-15 through 1-19 in Chapter 1?
