Question: i need correct working code with screenshot it is important to take screenshot a- Write an SQL statement to create a customer table containing the

i need correct working code with screenshot it is important to take screenshot

a- Write an SQL statement to create a customer table containing the following information:

Every customer has a unique ID, that should not be empty and set as the primary key

The customer's first and last name that shouldn't be empty

The phone number that shouldn't be empty

The email, which could be empty.

The address, which could be empty.

b-Write a SQL statement to create the table Orders, which will keep track of customer orders, using the following information:

Each order has a unique ID, which shouldn't be empty and should be set as the primary key.

The customer's ID and should not be empty and assign it as the foreign key of the customer ID in table customer.

The Items purchased by the customer and shouldn't be left empty.

The amount of each item, and should not be empty

The price of the items, and should not be empty

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!