You are in charge of creating a small database for a store that sells goods so that it can keep track of its customers and their orders. 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. 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
You are in charge of creating a small database for a store that sells goods so that it can keep track of its customers and their orders. 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. 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
Chapter12: Subqueries And Merge Statements
Section: Chapter Questions
Problem 19MC
Related questions
Question
You are in charge of creating a small
- 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.
- 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
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 7 steps with 6 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you