Question: Draw an Entry relationship Draw an enuty-reiaionsnip (ER) moaei basea on ine price ist irom LB Bakery snown below. (14 marks) Price List Small Medium

Draw an enuty-reiaionsnip (ER) moaei basea on ine price ist irom LB

Draw an Entry relationship 

Draw an enuty-reiaionsnip (ER) moaei basea on ine price ist irom LB Bakery snown below. (14 marks) Price List Small Medium Large (RM) Unit Price (RM) (RM) Regular coffees ppuccino Caf latte 2.25 3.30 4.00 2.90 3.89 5.00 3.99 4.88 6.00 Special coffees Espresso Coffee of the day 2.90 3.40 4.90 2.00 3.00 4.00 3.00 4.00 5.00 decaffeinated . 25 . 50 . 75 extra charge Black tea 2.25 3.00 4.50 Green tea 2.99 4.00 5.90 Herbal teas 3.44 4.70 5.90 Teas of the day 2.20 3.00 4.00 decaffeinated .25 .50 . 75 extra charge Milk 1.25 2.90 4.90 Soft drink 1.34 3.00 3.90 Soda water 2.55 4.10 5.50 Mineral water Apple pie Strawberry cheesecake Whole wheat oats muffin Fruit cake 1.00 2.00 3.00 3.40 5.00 3.90 4.80 Page 2 I 2 + Cake of the day Additional whipped cream 3.90 2.00

Step by Step Solution

3.39 Rating (152 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To draw an EntityRelationship ER model based on the price list provided you need to identify the ent... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!