Question: Part 01 In this part you will learn how to create and use triggers: 1. Create a table called Customer_Archives that has the same columns

 Part 01 In this part you will learn how to create

Part 01 In this part you will learn how to create and use triggers: 1. Create a table called Customer_Archives that has the same columns as customers table and it also has a column that is called "Deletion_Date" 2. Create a Trigger on table Customers so that every time a record is deleted from table customers this same record is inserted in table Customer_Archives with the current date as Deletion_Date 3. Now insert a new customer into table Customers and then delete it. Is the record inserted correctly into table Customers Archive? Part 02 In this part we will learn how to use functions: 1. Create a functions that has the Customer_id as input and returns a number that represents the total cost of orders for this customer. Notice that you will need to multiply the Order Qty from table order_details and the Unit Price from table items to get the total cost of each order. 2. Now use the function: Write a select statement that selects all the customers and the total cost of the orders they have ever made

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!