Assignment #5 (Review Chapters 7-9) #1. Write an SQL CREATE TABLE statement

Assignment #5

(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.