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

Customers colum has this atribute

(Customer_id Number(10), Customer_FirstName Varchar(50), Customer_LastName Varchar(50), Customer_Address Varchar(255), Customer_City Varchar(50), Customer_State Varchar (2), Customer_Zip Varchar (20), Customer_Phone Varchar (30), Customer_Fax Varchar (30)

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

Now insert a new customer into table Customers and then delete it. Is the record inserted correctly into table Customers_Archive?