What is the purpose of target tables? What information are they giving?

What is a primary key? What is the primary key for each of the tables in the Colonial Adventure Tours database shown in Chapter 1?

An EMPLOYEES table was added to the JustLee Books database to track employee information. Display a list of each employee’s name, job title, and manager’s name. Use column aliases to clearly identify employee and manager name values. Include all employees in the list and sort by manager name.

One way to secure a database is to allow only administrators to have access to create and delete tables. (513)

Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. FIGURE P3.17 THE CH03_TRANSCO DATABASE TABLES

A table can have a maximum of how many PRIMARY KEY constraints?

Problem 1 and 2 are based on the following query: SELECT EMP_LNAME, EMP_FNAME, EMP_AREACODE, EMP_SEX FROM EMPLOYEE WHERE EMP_SEX = 'F' AND EMP_AREACODE = '615' ORDER BY EMP_LNAME, EMP_FNAME; What indexes should you create? Write the required SQL commands.

How do you create an index? How do you create a unique index? What is the difference between an index and a unique index?

The CUSTOMER table contains a foreign key, REP_NUM, that must match the primary key of the REP table. What type of update(s) to the CUSTOMER table would violate the foreign key constraint?

Write the SQL code that will restore the data to its original status: that is, the table should contain the data that existed before you made the changes in Problems 5 and 6.