Frank and Sue Gamey finally realized their dream when they purchased a family re

Question

Frank and Sue Gamey finally realized their dream when they purchased a family restaurant, naming it Taco Success. They sell Mexican cuisine and have drive thru, and walking customers. As well as a catering service. The Games want a real time method of inventory. Not 9nly for Sales for the day/week, but a way of keeping track of who did the sales and totals that they brought in. They also would like the system to tell the salesperson/order takee-immediately if a product can't be made due to lack of ingredients. Design a database that is normalized that will supply them with this information.

Format example
TABLES.           COLUMNS
ITEm.        (ItemNum,Description, Price....)
ORDER HEADER (OrderNum,Salesperson,Date)
ORDER DETAILS
(OrderNum,ItemNum,Quantity,....)
a product

Explanation / Answer

Query for creating database restaurant

CREATE DATABASE `restaurant`

Query for Item Table

Query for Order_Header

Query for Order_Details

CREATE TABLE `item` (
`ItemNum` int(11) NOT NULL AUTO_INCREMENT,
`Description` text NOT NULL,
`Price` float NOT NULL,
PRIMARY KEY (`ItemNum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.