Chapter 12, Problem 2QY

Explain the difference between truncating a table and deleting a table.

Define second normal form. What types of problems might you encounter using tables that are not in second normal form?

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.

When must you define constraints at the table level rather than the column level?

Insert the data into the tables you created in Problem 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.

What is the maximum number of PRIMARY KEY constraints allowed for a table? a. 1 b. 2 c. 30 d. 255