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 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.