Problem Statement For this assignment, you are to develop a logical database design (relational schema) from a conceptual data model (a simple restaurant data model) that is given on the last page. Your relations should be normalized to the third Normal form.

Submission 1. A cover page with the following information: IDS 410 Business Database Technology Spring 2022 Assignment #2 (database design) Logical Database Design for a Simple Restaurant System Your Name and UIC Email Address 2.

A relational schema for a simple restaurant system. Use arrows to show referential integrity constraints. You do not have to show the functional dependencies among the attributes within a relation (table). Use a computer-based graphic tool to draw your relational schema (i.e., LucidChart.com, Creatly.com. gliffy.com, VISIO, etc.)

A Simple Entity Relationship Diagram for a Restaurant System. SalesOrder OrderLine Menultem Menu PK OrderID Contains So Appears in PK Item ID PK Menuld Has Date Time Quantity UnitPrice Contains Name Description UnitPrice Size Menu Type From Time ToTime Season Table Prepares PK TableNo Bill Has Takes care PK BillNo Size IsReserved Staff PK StaffNo Recipe_Ingredient Recipe PK RecipeID Needs Date Time BillAmount Serving Size Directions Quantity Reservation Submits Needs has PK ReservationNo FirstName LastName Street City State Zip Phone Gender BirthDate Job Title Salary Joined Date Manager Ingredient Date From Time ToTime PartyOf CashReceipt PK ReceiptNo UnitOfMeasure CaloriesPerUnit Date Time PaymentType TotalAmount Performance Position Date CarAllowance Monthly Bonus Customer PK CustomerID NextOfKin Pays Supplyltem PK ItemNo Name Phone Email CreditCard PK CC No Full Name Relationship Street City State Zip Phone Name Description QtyOnhand SupplyType Has FirstName LastName Expiry Date Verification Code