Question: Bring this document to 3^RD Normal Form. Create the Entity Relationship Diagram (ERD) for this application. Create the Data Dictionary for this application. Write the

Bring this document to 3^RD Normal Form. Create the Entity Relationship Diagram (ERD) for this application. Create the Data Dictionary for this application. Write the SQL statement to create a table named "Customer" based on the Data Dictionary from item 3. Create a VIEW to allow an employee to generate a list of the Customers and their selection of Artists, Titles and Dates. Create a TRIGGER to track updates on the Customer table. Track changes made "ONLY ON" the following fields: Cust_ID, Cust_Name, Cust_Phone, Date_Of_Update, User_ID Define the Data Definition commands and their function. Define the Data Manipulation commands and their function. Describe the Database Life Cycle. Discuss the problems that may occur by not performing regular backups
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
