Hi,

I am using MindTap on Cengage for Dat/380. I need help with the following problems:

Problem 23

Modify the CUSTOMER table to include the customers date of birth (CUST_DOB), which should store date data

Problem 24

Modify customer 1000 to indicate the date of birth on March 15, 1989.

Use YYYY-MM-DD format for inserting dates.

Problem 25

Modify customer 1001 to indicate the date of birth on December 22, 1988.

Use YYYY-MM-DD format for inserting dates.

Create a MySQL trigger named trg_updatecustbalance to update the CUST_BALANCE in the CUST_MYSQL table when a new invoice record is entered. (Assume that the sale is a credit sale.) Whatever value appears in the INV_AMOUNT column of the new invoice should be added to the customers balance. Test the trigger using the following new INV_MYSQL record, which would add 225.40 to the balance of customer 2001:

INV_NUM	CUST_NUM	INV_DATE	INV_AMOUNT
9005	2001	2018-04-27	225.40