Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Where is the WEAK ENTITY in this ERD? and please explain what isthe weak entity? I don't see the weak entity. If it's not in

Where is the WEAK ENTITY in this ERD? and please explain what isthe weak entity? I don't see the weak entity.

If it's not in here then how to add a Weak entity and based onwhat?

Also how to determine the TOTAL Participation?

Could you please answer I need to understand these two parts

__________________________________________________________________________

Key points:

  • Each patient?s personal details (name, address, and telephonenumber), and they are given an admission number.
  • Patiets are then assigned to a particular ward.
  • In each ward there are a number of doctors and nurses. (So,Ward: Doctor - 1: N)
  • A patient will be treated by one doctor and several nurses.Which means (Doctor:Patient - 1:N) and (Nurse: Patient - N:N)
  • Each doctor and nurse may be involved with severalpatients.(1:N)

So the ER diagram as required:

image

ER diagram:ER model is to represent the strucre of data by using entities andattributes and their reklations. ER diagram considers entities inreal world and relating with them. It is a graphical view.

Relational diagram:In Relational database model,the entities and relations arerepresented by using tables. Each table contains records andattribues.

ERD-Relational Schema

  • If we have multi-valued attribute, make that attribute as newentity.
  • In 1:1 Relationships, we are not considering relation asseperate entity. We add less priority table primary key as foreignkeyb of priority table.
  • In 1:M relationships, we are not considering relation asseperate entity. We simply use primary key of one table as forignkey of another table.
  • In M:M relationship, We need to create a relationship asseperate entity.

Now let us convert ER diagram to Relationaltables:

1) Relationship between Ward and Patient: As it contains 1:Nrelationship,we are adding primary key of Ward as foreign keyb ofPatient table.

Ward(Ward_Number,Ward_Name)Patient(Admission_Number,Name,Number,Address,Ward_Number)

2) Relationship between Doctor and Patient: As it contains 1:Nrelationship,we are adding primary key of Doctor as foreign keyb ofPatient table.

Doctor(Doctor_Id,Doctor_Name,Speciality)Patient(Admission_Number,Name,Number,Address,Ward_Number,Doctor_Id)

3) Relationship between Nurse and Patient: As it contains N:Nrelationship,we are adding relationship as another table.

Nurse(Nurse_ID,Nurse_Name)Assists(Admission_Number,Nurse_ID)Patient(Admission_Number,Name,Number,Address,Ward_Number,Doctor_Id)

4)Relationship between Ward and Doctor :As it contains 1:Nrelationship,we are adding primary key of Ward as foreign key ofDoctor table.

Ward(Ward_Number,Ward_Name)Doctor(Doctor_Id,Doctor_Name,Speciality,Ward_Number)

5) Relationship between Ward and Nurse: As it contains 1:Nrelationship,we are adding primary key of Ward as foreign key ofNurse table.

Ward(Ward_Number,Ward_Name)Nurse(Nurse_ID,Nurse_Name,Ward_Number)

So the final tables are:

Patient(Admission_Number,Name,Number,Address,Ward_Number,Doctor_Id)Ward(Ward_Number,Ward_Name)Nurse(Nurse_ID,Nurse_Name,Ward_Number)Assists(Admission_Number,Nurse_ID)Doctor(Doctor_Id,Doctor_Name,Speciality,Ward_Number)

Admission Number Name Address Number DoctorID Speciality Doctor Name Patient Treates Doctor Admits Ward Ward_Name Works_In Nurse Ward Number NurselD Nurse_Name

Step by Step Solution

3.44 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

Weak Entity A weak entity represents that entity in a schema whose existence depends u... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Electrical Engineering questions

Question

public static String lowestRainfallMonth ( )

Answered: 1 week ago

Question

discuss the use of exercise as an adjunct to therapy.

Answered: 1 week ago