Write the specifications for your database (Structured English). Follow the format in the ER book. You need to write out the specifications for only all entities. Write out ALL the cardinalities and participation ratios (for all relationships). And, explain all the disjoints, overlaps and unions - do the write up as per the "Generalizations and Specializations" handout.  See Handout in Module.

 

Transcribed Image Text:

Hospital Id Doctor Id Visiting Hospital name Hospital 1 N has Doctor ISA Trainee Address 1 Treat Admit Name M Qualification Address Patient Id N Patient has 1 Diagnosis Date of Check 1 N Name assigned Medical Record Record Id 1 Room Id RN Room Type Room governs Nurse d FNP Hospital Id Doctor Id Visiting Hospital name Hospital 1 N has Doctor ISA Trainee Address 1 Treat Admit Name M Qualification Address Patient Id N Patient has 1 Diagnosis Date of Check 1 N Name assigned Medical Record Record Id 1 Room Id RN Room Type Room governs Nurse d FNP Hospital Id Doctor Id Visiting Hospital name Hospital 1 N has Doctor ISA Trainee Address 1 Treat Admit Name M Qualification Address Patient Id N Patient has 1 Diagnosis Date of Check 1 N Name assigned Medical Record Record Id 1 Room Id RN Room Type Room governs Nurse d FNP Hospital Id Doctor Id Visiting Hospital name Hospital 1 N has Doctor ISA Trainee Address 1 Treat Admit Name M Qualification Address Patient Id N Patient has 1 Diagnosis Date of Check 1 N Name assigned Medical Record Record Id 1 Room Id RN Room Type Room governs Nurse d FNP Hospital Id Doctor Id Visiting Hospital name Hospital 1 N has Doctor ISA Trainee Address 1 Treat Admit Name M Qualification Address Patient Id N Patient has 1 Diagnosis Date of Check 1 N Name assigned Medical Record Record Id 1 Room Id RN Room Type Room governs Nurse d FNP Hospital Id Doctor Id Visiting Hospital name Hospital 1 N has Doctor ISA Trainee Address 1 Treat Admit Name M Qualification Address Patient Id N Patient has 1 Diagnosis Date of Check 1 N Name assigned Medical Record Record Id 1 Room Id RN Room Type Room governs Nurse d FNP