Assignment 2 - COP4703.pdf - Michael Pena COP4703 Assignment 2 1 What is a relation A relation is a two-dimensional table in which the entries are

Assignment 2 - COP4703.pdf - Michael Pena COP4703...

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

Michael Pena 9/2/2018 COP4703 Assignment 2 1. What is a relation? A relation is a two-dimensional table in which the entries are single-valued, each field has a distinct name, all the values in a field are values of the same attribute (the one identified by the field name), the order of fields is immaterial, each row is distinct, and the order of rows is immaterial. 2. What is a relational database? A relational database is a collection of relations. 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 shorthand representation, each table is listed, and after each table, all the columns of the table are listed in parentheses. Primary keys are underlined. The shorthand representation for Colonial Adventure Tours database is as follows:Guide (GuideNum, LastName, FirstName, Address, City, State, PostalCode, PhoneNum, HireDate
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read all 4 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture