Transform the following ERD into a set of relations in 3NF; list all foreign key constraints 1.

Transform the following ERD into a set of relations in 3NF; list all foreign key constraints
 

Transcribed Image Text:

1. Transform the following ERD into a set of relations in 3NF: list all foreign key constraints. (40 points) Specialty PK Specio Description Physician PK Physio PhysName() Pacient PK Patientib FirstName LastName Phone Hospital OH PK HosplD Name Address () PK Treatment Treat Code Description Price UrgentCare TimeOpen TimeClose ER NoOfBeds 1. Transform the following ERD into a set of relations in 3NF: list all foreign key constraints. (40 points) Specialty PK Specio Description Physician PK Physio PhysName() Pacient PK Patientib FirstName LastName Phone Hospital OH PK HosplD Name Address () PK Treatment Treat Code Description Price UrgentCare TimeOpen TimeClose ER NoOfBeds

Answer rating: 100% (QA)

Relations in 3NF Speciality SpecIDDescription Physician P... View the full answer