(Review Chapters 7-9)
#1. Write an SQL CREATE TABLE statement to create the CUSTOMER_02 table.
CUSTOMER_02 table structure: CustomerID is a primary key.
CUSTOMER_02(CustomerID, EmailAddress, LastName, FirstName)
#2. Describe why database redesign is necessary.
#3. What is a dependency graph? What purpose does it serve?
#4. Show an SQL statement to drop the column C1 from table T2.
#5. Define an atomic transaction and explain why atomicity is important.
#6. What is deadlock? How can it be avoided? How can it be resolved once it occurs?
#7. Describe the advantages and disadvantages of DBMS-provided and application-provided security.