shallal is a restaurant in khobar and its owners want to keep the sales records in e 5189193


SHALLAL is a restaurant in Khobar and its owners want to keep the sales records in excel. The Database System Requirements 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: o Food items sold in each transaction o The count of each food item in each transaction o The date and time of each transaction The database keeps history records of all items. Deliverables 1. 2. 3. The above database schema in excel Insert few records in each table. Conceptual and logical diagram of the above database. 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.

"Get 15% discount on your first 3 orders with us"
Use the following coupon
FIRST15

Order Now