PLEASE READ THE TWO PAGES CAREFULLY BEFORE ANSWERING

AN ENTITY RELATION DIAGRAM DESIGN QUESTION.

HOME WORK DESIGNING A DATABASE FOR A RESTAURANT i M AN AGEMENT-SYSTEM-IpHERE.. cusTomERS . CAN ORDER FOOD ONLINE | DESIGN- AN ENTITY RELATION DAGRAM (ER)DATER FOR THE SYSTEM HERE ARE SoME FEATURES AND FuNCTIONALITIE S OF THE SYSTEM (A) CusToMERS ORDER FOOD ONUNE (B) CusToMERS CAN MAKE PAYMENT IN CASH OR THROU Stt. DEBIT. DR CREDITCARDS-ult EN CHECKING OUT C) CuSTDMERS CAN SEE CURRENT DISCOUNT ITEMS Ca CuTOMERS CAN SEE THE CALORIE CHART AND-PROF IT S-SAYED-IN THE-SYSTEM (F) EMPLOYEE'S INFORMATION S ALSO SAVED IN THE SSTEM AND CAN BE ONLY ACCESSED BY THE SYSTE M ADMIN L4) CusTOMERS CAN ACLESS THE SYSTEM THROuSH INTERNET CONNECTION AND ORDER FOOD CuSTOMERS CAN ALSO REGSTER TD THE SYSTEM-IN-ORDER-TO PAYINY THE OADER ONLINE OR REQUESTING Forb DELIVERY, CH) CHEFS CAN SEE THE ORDER AND WILL TELL TE SYSTEM TItE FoDD i READY AFTER PREPARATI C) WATER-WAITERS CAN GET THE CONFIRMATI HA-ND IT TO THE DELIVERY DRIVER (J) CASHIER-THE CnStHER CAN ACCESS THE SYSTEm AND RECE IVE THE PAYMENT FrOm CusTomERS CK ADMIN-THE ADMIN CAN EDIT-THE PRICE) CoUNT TOTAL EARNINS AND EXPENDITURE (L) AuDIT SYSTEM- THE SYSTEm MuST KEEP TRACK of THE RECORDS THE ARE BEING SELETED THE FuNCTIONALITY of THe AuDI SYSTEM MUST-STORE-THEORIGINAL RECORD DETAILS AND THE NATE OF OPER ATON WItE A RECORD (S DELETED BEFORE THE DELETE (M) THE DATABASE SYSTEm CAN GEN ERATE MAKE APRROPRIATE BUSINESS NECISDNS FOR THE RESTAU RANT, ExAMPLE THE DEMAND of WAITERs, ctefs AND DELIVERY DRIVERS HOME WORK DESIGNING A DATABASE FOR A RESTAURANT i M AN AGEMENT-SYSTEM-IpHERE.. cusTomERS . CAN ORDER FOOD ONLINE | DESIGN- AN ENTITY RELATION DAGRAM (ER)DATER FOR THE SYSTEM HERE ARE SoME FEATURES AND FuNCTIONALITIE S OF THE SYSTEM (A) CusToMERS ORDER FOOD ONUNE (B) CusToMERS CAN MAKE PAYMENT IN CASH OR THROU Stt. DEBIT. DR CREDITCARDS-ult EN CHECKING OUT C) CuSTDMERS CAN SEE CURRENT DISCOUNT ITEMS Ca CuTOMERS CAN SEE THE CALORIE CHART AND-PROF IT S-SAYED-IN THE-SYSTEM (F) EMPLOYEE'S INFORMATION S ALSO SAVED IN THE SSTEM AND CAN BE ONLY ACCESSED BY THE SYSTE M ADMIN L4) CusTOMERS CAN ACLESS THE SYSTEM THROuSH INTERNET CONNECTION AND ORDER FOOD CuSTOMERS CAN ALSO REGSTER TD THE SYSTEM-IN-ORDER-TO PAYINY THE OADER ONLINE OR REQUESTING Forb DELIVERY, CH) CHEFS CAN SEE THE ORDER AND WILL TELL TE SYSTEM TItE FoDD i READY AFTER PREPARATI C) WATER-WAITERS CAN GET THE CONFIRMATI HA-ND IT TO THE DELIVERY DRIVER (J) CASHIER-THE CnStHER CAN ACCESS THE SYSTEm AND RECE IVE THE PAYMENT FrOm CusTomERS CK ADMIN-THE ADMIN CAN EDIT-THE PRICE) CoUNT TOTAL EARNINS AND EXPENDITURE (L) AuDIT SYSTEM- THE SYSTEm MuST KEEP TRACK of THE RECORDS THE ARE BEING SELETED THE FuNCTIONALITY of THe AuDI SYSTEM MUST-STORE-THEORIGINAL RECORD DETAILS AND THE NATE OF OPER ATON WItE A RECORD (S DELETED BEFORE THE DELETE (M) THE DATABASE SYSTEm CAN GEN ERATE MAKE APRROPRIATE BUSINESS NECISDNS FOR THE RESTAU RANT, ExAMPLE THE DEMAND of WAITERs, ctefs AND DELIVERY DRIVERS