Assignment 2.docx - Assignment 2 1 What is a relation A two-dimensional table 2 What is a relational database Collection of relations 3 What is an

Assignment 2.docx - Assignment 2 1 What is a relation A...

This preview shows page 1 - 2 out of 4 pages.

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?
Background image
Image of page 2

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture