50 likes | 132 Views
ERD Narrative (p158 Lab Manual). Oakfield Orthopaedic Hospital.
E N D
Oakfield Orthopaedic Hospital Oakfield is a private orthopaedic hospital located in the Galway region. It has three operating theatres and five clinics. When operations are being performed, there will always be two or more doctors present. A patient has at least two appointments prior to an operation.
Cannot have Many to Many • Will create duplicate entries to a database and as such this significantly compromises the database design • Need to remove Many to Many relationship using an associative entity