Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SHALLAL is a restaurant in Khobar and its owners want to keep the sales records in excel. The restaurant serves three food categories, namely, Pastries

image text in transcribed
SHALLAL is a restaurant in Khobar and its owners want to keep the sales records in excel. The restaurant serves three food categories, namely, Pastries Drinks Sandwiches The database must keep the records of each: Food category: name, start date, end date, status, etc. Food item: name, category, price, start date, end date, status, etc. Sales transactions: Food items sold in each transaction The count of each food item in each transaction The date and time of each transaction The database keeps history records of all items. 1. The above database schema in excel 2. Insert few records in each table. 3. Conceptual and logical diagram of the above database

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Advanced Database Systems

Authors: Carlo Zaniolo, Stefano Ceri, Christos Faloutsos, Richard T. Snodgrass, V.S. Subrahmanian, Roberto Zicari

1st Edition

155860443X, 978-1558604438

More Books

Students also viewed these Databases questions

Question

12-7. What is a touchpoint?

Answered: 1 week ago