165k views
0 votes
A restaurant chain has several store locations in a city (with a name and zip code stored for each), and each is managed by one manager. Managers manage only one store. Each restaurant location has its own unique set of menus. Most have more than one menu (e.g., lunch and dinner menus). Each menu has many menu items, and items can appear on multiple menus, and with different prices on different menus. Represent this situation of restaurants with an E-R diagram.

User Jonathanb
by
4.6k points

2 Answers

2 votes

Answer:

c d b a c

Step-by-step explanation:

edge 2022

User Nesa Mouzehkesh
by
4.5k points
2 votes

Answer:

The restaurant chain system consist of restaurant id, name, zipcode, manager id, menu list.

Manager; manager id, name, phone no, and store.

Menu; menu id, type, items and description.

Items; item id, price and description.

Step-by-step explanation:

Please look at the attachment for the E. R diagram.

A restaurant chain has several store locations in a city (with a name and zip code-example-1
User PfunnyGuy
by
4.5k points