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 keyThe customer's first and last name that shouldn't be emptyThe phone number that shouldn't be emptyThe 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 emptyThe price of the items, and should not be empty

The SQL queries for creating and inserting data are given in the below step

Answered: You are in charge of creating a small…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

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

Expert Solution

Step by step

Solved in 7 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions