Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

/* 6. For each order list the following:. (Sort the list by customer, order description, order date) a. Customer name b. Order id c. Order

image text in transcribed

/* 6. For each order list the following:. (Sort the list by customer, order description, order date) a. Customer name b. Order id c. Order Description (pickup or delivery) d. Order date */

/*7. How many delivery orders did we make? */

--8. Create a list of ingredients and the number of times that each ingredient -- was used on a pizza. Put the ingredient used most at the top of the list.

--9. Create a list of customers that have placed more than 20 orders. --Sort the list so the customer with the most orders appears at the top.

--10. What is the date of the first and last order taken?

/* 11. Add the following new customer. a. Cust_ID: 9999 b. Name: Ben Forta c. Phone: 555-9999 */

/*12. Customer 9999 has decided to have his pizza delivered and gave us the following address a. Street: 456 Main Street b. City: Anoka c. State: MN d. ZipCode: 55303 */

CUSTOMER Orderingredients Orders Pizzalngredients CustID Orderid + PK EK Orderid ... > PK IngrediD FirstName FK Ingredienti Order Date IngredDesc Last Name Order Time Street Order Type DeliveryTime PK City PK Order Type OrderType CustID State OrderType Order Desc Phone Number SizeID PizzaCrust ZipCode Crustid >0 # PK CrustID CrustType Delivery Area PizzaSize LPK Zip Code HPK SizelD CityName SizeDesc attribute name CUSTOMER Orderingredients Orders Pizzalngredients CustID Orderid + PK EK Orderid ... > PK IngrediD FirstName FK Ingredienti Order Date IngredDesc Last Name Order Time Street Order Type DeliveryTime PK City PK Order Type OrderType CustID State OrderType Order Desc Phone Number SizeID PizzaCrust ZipCode Crustid >0 # PK CrustID CrustType Delivery Area PizzaSize LPK Zip Code HPK SizelD CityName SizeDesc attribute name

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions