7.1 What does DDL stand for? List the SQL DDL statements.
7.2 What do es DML stand for? List the SQL DML statements.
7.4 Write a CREATE TABLE statement for the DEPARTMENT table.
7.6 Write a CREATE TABLE statement for PROJECT table. The default value for MaxHours is 100. Cascade updates but not deletions from DEPARTMENT to EMPLOYEE.

7.9 Write an alternate SQL statement that modifies your answer to Review Question 7.7 to make the relationship between EMPLOYEE and ASSIGNMENT a 1:1 relationship.
7.10 Write an ALTER statement to add the column AreaCode to EMPLOYEE. Assume that
AreaCode is not required.
7.13 Write an ALTER statement to drop the constraint that Phone is an alternate key in EMPLOYEE.
If you are using a DBMS, then at this point you should create a database named
WPC and run the SQL statements from Review Questions 7.4, 7.5, 7.6, and 7.8 only.
(Hint: Write and test an SQL script, and then run the script. Save the script as
DPB-e12-WPC-Create-Tables.sql for future use.) Do not run your answers to Review
Questions 7.7 or 7.9! After the tables are created, run your answers to Review
Questions 7.10 through 7.13. Note that after these four statements have been run the table structure is exactly the same as it was before you ran them.

7.17 Write INSERT statements to add the data shown in Figure 2-32 to the ASSIGNMENT table. Run these statements to populate the ASSIGNMENT table. (Hint: Write and test an
SQL script, and then run the script. Save the script as DBP-e12-WPC-Insert-ASSIGNMENTData. sql for future use.)
7.26 Write one DELETE statement that will delete all data for project ‘2011 Q3 Product Plan’ and all of its rows in ASSIGNMENT. Do not run this statement.
7.30 What is an SQL view? What purposes do views serve?
Why is this useful?
7.39 Explain how views can be used to improve data security.

Chapter 7 SQL for Database