Question: Enable auto increment to generate values for customer numbers. The values should start with 2 0 0 0 . Enable auto increment to generate values

Enable auto increment to generate values for customer numbers. The values should start with 2000.
Enable auto increment to generate values for invoice numbers. The values should start with the value 9000.
Insert the following customer into the CUSTOMER table, using the auto increment from Problem 20 to generate the customer number automatically:
'Powers', 'Ruth', 500
Modify the CUSTOMER table to include the customer's date of birth (CUST_DOB), which should store date data.
Modify customer 1000 to indicate the date of birth as March 15,1989.
 Enable auto increment to generate values for customer numbers. The values

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!