Bring this document to 3^RD Normal Form. Create the Entity Relationship Diagram

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

Explanation / Answer

7. Data Definition Language (DDL) statements are used to define the database structure or schema.

Data Definition Language commands are :

1. Create : This command is used to create database and its objects like table, views, triggers, index, procedures.

2. Alter : This command is used to change the structure of the existing table.

3. Drop : Delete command is used to delete the objects from the database.

4. Truncate : This DDL command is used to remove all records from a table, including all spaces allocated for the records are removed.

5. Comment : This is used to add comments to the data dictionary.

6. Rename : It is used to rename the object.

8. Data Manipulation Language (DML) statements are used for managing data in database. DML commands are not auto-committed.

DML commands are :

1. Select : Select command is used to get the data from the database.

2. Insert : This command is used to insert the data into the table.

3. Update : Update command is used to update the existing data in the table using WHERE clause.

4. Delete : It will delete the all records in the table.

9. Database Life Cycle :

Database life cycle has the six phases. Discription for those six phases :

1. Database initial Study :

2. Database Design :

3. Implementation and Loading :

4. Testing and Evaluation :

5. Operation :

6. Maintenance and Evolution :

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.