Assg 1 - (c) This ERD allows patients to be treated...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Kristen Jack 1/18/2012 INFS 428 Chp 2 Assignment Exercise 15 b , 15 d , 15 h , 25 , 26, 27 (a) Only one relationship was drawn directly between Physician and Patient because there is a midway entity, Treatment Detail, to handle the many-to-many situation. (b) Hospital was not included, but rather, Treat Detail was added.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: (c) This ERD allows patients to be treated multiple times by different physicians by including a specific treatment_id identifier. (d) Every time a patient is admitted a date can be entered in a new entity (perhaps called admittance) which would include admittance_id and date....
View Full Document

Ask a homework question - tutors are online