Chapter 2, Problem 7RQ

Explanation of Solution

Shorthand representation of the relational database structure:

• The shorthand representation is used to represent the database table in an easier and an understandable way by using primary keys.
• The step wise process for representing a shorthand representation of a database structure is as follows:
  • First, the Table Name is written down...

Explanation of Solution

Shorthand representation for Colonial Adventure Tours database:

For each table, the table name is written down and within the paranthesis, all the columns in the table are lsited out. Here, the primary keys are underlined.

The shorthand representation to represent the table CUSTOMER is given below.

 CUSTOMER (CUSTOMER_NUM, LAST_NAME, FIRST_NAME, ADDRESS, CITY, STATE, POSTAL_CODE, PHONE)

The shorthand representation to represent the table GUIDE is given below...