Display the content of customers table

Assignment Help Computer Engineering

Reference no: EM132171789

Using MySQL

D1. Create a new table named Customers. The new table should have at least 5 columns including a primary key. (Cust-id, First_name, Last_name, State, Zip-code. Use cust_id as PK.

D2. Insert 2 rows into the Customers table.

D3. Create a history table for Customers table, (create table customers_history). The table should have same structure as Customers table Cust-id + First_name + Last_name+ State + Zip_code. Don't forget the history_id as pk . Do NOT insert any data (values) into this table.

D4. Create a trigger for auditing-create trigger audit_customers on the Custoners table

D5. Insert 3 records into the Customers table.

D4. Retrieve all rows from customers and customers-history table to verify that rows were added to the Customers table and that the trigger is populating the customers-history table.

D5. Now update the zip code of one customer and check if rows were added to the customers table and that the trigger did populate the customers-history table with the new zip code.

D6. Update the first record of Customers, and then delete this record.

D7. Display the content of Customers table and the history table.

Reference no: EM132171789

Questions Cloud

Display a table of expansion length for a steel bridge : Write a C++ program that displays a table of expansion length for a steel bridge that's 7365 meters long at 0 degrees Celsius.

What is the expected area : If the area of the tiles is the square of the side length, what is the expected area?

Provide a query that lists all employees : Provide a query that lists all employees along with any dependents. Include employees without dependents in the result set.

Electricity and sustainable alternative to gas flaring : Your paper will be evaluated on its appraisal of the issue, its quality of argument, and the topic's relevance to the subject matter covered in the course

Display the content of customers table : Create a new table named Customers. The new table should have at least 5 columns including a primary key.

Current production method : State the appropriate null and alternative hypotheses if the mean cost for the current production method is $230 per hour

Create a personal development plan : Personal Development Plan MGMT 1021 -

Find the expected winnings for a person buying : If 10000 tickets are sold at 25 cents each, find the expected winnings for a person buying 1 ticket.

What is the average number of cars waiting in line : a. What is the average number of cars waiting in line? b. What is the average time a car spends in the waiting line?

User Account

All Pages