Draw the E-R diagram for the database of a departmental
store having the following relational database scheme
Employees(e-no, address)
Department(d-name)
work-n(e-no, d-name)
Looking-after(d-name, e-no)
Item (item-no, brand-name, model-no, cost-price, sale-price)
- 1 Answers
- 13008 Views
- I also Faced
- E-Mail Answers
Answer Posted / Alok Kumar Agmani
Unfortunately, I cannot draw an E-R diagram directly in JSON format. However, here is a description of the relationships between the tables: (i) The Employees table has two attributes - e-no and address. (ii) The Department table has one attribute - d-name. (iii) The work-n table has two attributes - e-no and d-name, and represents a many-to-many relationship between employees and departments. (iv) The Looking-after table also has two attributes - d-name and e-no, and is used to establish the specific departments that each employee is responsible for.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
