Hi,

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

Problem 21.a

Using MySQL, create a table named INV_MYSQL with the same fields as in Problem 17, except, use the AUTO_INCREMENT feature for the INV_NUM field.

Do not create a FOREIGN KEY constraint.

Problem 17 reference:

Problem 21.b

Using MySQL, alter the table to populate the INV_NUM field, beginning the increment with 9000

Problem 21.c

Populate the CUST_NUM, INV_DATE, and INV_AMOUNT fields with the following customers:

CUST_NUM	INV_DATE	INV_AMOUNT
1000	2016-03-23	235.89
1001	2016-03-23	312.82
1001	2016-03-30	528.10
1000	2016-04-12	194.78
1000	2016-04-23	619.44

Problem 22

Insert the following customer into the CUST_MYSQL table, allowing the AUTO_INCREMENT attribute set up in Problem 20.a and Problem 20.b to generate the customer number automatically:

CUST_LNAME	CUST_FNAME	CUST_BALANCE
Powers	Ruth	500