Problem 20.a Using MySQL, create a table named CUST_MYSQL with the same fields as in Problem 16 , except, use the AUTO_INCREMENT feature for the CUST_NUM field. Problem 20.b Using MySQL, alter the...

Problem 20.a

Using MySQL, create a table named CUST_MYSQL with the same fields as inProblem 16, except, use the AUTO_INCREMENT feature for the CUST_NUM field.

Problem 20.b

Using MySQL, alter the table to populate the CUST_NUM field, beginning the increment with2000.

Problem 20.c

Using MySQL, populate the CUST_LNAME, CUST_FNAME, and CUST_BALANCE fields with the following customers:

Problem 21.a

Using MySQL, create a table named INV_MYSQL with the same fields as inProblem 17, except, use the AUTO_INCREMENT feature for the INV_NUM field. Do not create a FOREIGN KEY constraint.

Problem 21.b

Using MySQL, alter the table to populate the INV_NUM field, beginning the increment with9000.

Problem 21.c

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

Problem 22

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