Please read the Lambs$-$Are$-$Us Restaurant case study $($see pages $2-6$ below. In particular,

please carefully read the $$Data Requirements for Revenue and Production Cycles$$ section on

pages $3-6).$ For this first assignment, your task is to draw an E$-$R diagram for the Lambs$-$Are$-$Us

Restaurant database.

Assume that you are one of the managers in this restaurant; and you would like to propose a

project to develop an application $($a computerized information system$)$ that would not only

perform the restaurant$$s basic operations but also help the restaurant keep records of its

customers, orders, inventories, and so on$.$ This application would help the restaurant to identify

its regular customers and design sales promotion schemes as well as to keep track of its

inventories and sales. Moreover, you would like to have an Internet presence for the restaurant

from which customers can create an account, browse the menu items, and submit orders.

Use the Supertype and Subtype concepts $($see Chapter $4[8$th or $9$th edition$]$ or Chapter $3[10$th

edition$])$ if needed. State any assumption you have when developing the diagram.