Question: Below is a partially complete CREATE TABLE statement for the Customers table in the Clothing Store database. Fill in the two blanks below to make

 Below is a partially complete CREATE TABLE statement for the Customers

Below is a partially complete CREATE TABLE statement for the Customers table in the Clothing Store database. Fill in the two blanks below to make ID an auto incrementing attribute and ensure the lastName attribute of all tuples is not null. Your answer will be marked incorrect if there is a spelling mistake, missing spaces, or unnecessary spaces. CREATE TABLE Customers( D int lastName varchar(255) firstName varchar(255), streetAddress varchar(255), city varchar(255), DOB DATE, favoriteStore int(3), PRIMARY KEY (ID) FOREIGN KEY (favoriteStore) REFERENCES Stores (ID)

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!