Question

Using the relational Schema given below construct an ER diagram for the database

worker (persNr, name, stationNr)

station(stationNr, name)

doctor (persNr, namke, sttionNr, expertise, degree)

nurse (persNr, na,me, stationNr, skills)

patient (patientNr, name, illness, roomNr, from, to)

room (stationNr, roomNr, numbeds)

treats (patientNr, persNr)

Answer 1

Answer :

Please upvote if you find this answer helpful, Thanks in advance!

For relational database Entity Relationship diagram is nothing but representation of information with various entities and their attributes and how the connects to each other.

1. In the following diagram, doctor has below attributes :

• persNr
• namke
• sttionNr
• expertise
• degree

2.Patient has following attributes :

• patientNr
• name
• illness
• roomNr
• from
• to

3.Nurse is connected with doctor with ISA relationship.Nurse has following attributes :

• persNr
• name
• stationNr
• skills

4.Nurse governs rooms and obviously patient, rooms has following attributes :

• stationNr
• roomNr
• numbeds

5.Nurse and other workers lives near station , workers has following attributes:

• persNr
• name
• stationNr

6.Station has following attributes :

• stationNr
• name

E-R Diagram :