TOPIC: Collect one example for mapping from ER Model to

              Relationship Model

RESTAURANT SYSTEM:The entities are represented by Chef,Meal,Ingredients,Customer and Supplier.

1.A chef is represented by a chef id and chef name and also by his salary

2.Meal prepared by chef is identified by its name and price.

3.Ingredients of meal are identified by its name and description

4.Every customer has a name,id,phone no: and address.

5.Supplier is identified by his name,id and city.

Corresponding ER diagram:

Image

ENTITIES:

CHEF

Chef_id

Chef_name

Chef_salary

     

MEAL

Meal_name

Meal_price

   

INGREDIENTS

Ing_name

description

   

CUSTOMER

Cust_id

Cust_name

Cust_address

Cust_phoneno

       

SUPPLIER

S_id

S_name

S_city

     

RELATIONSHIPS:

Prepares

qty

time

   

Consists of

qty

price

   

Orders

date

time

   

Attends

time

tableno

   
Advertisements