ERD PRACTICE PROBLEMS

ERD PRACTICE PROBLEMS - ERD PRACTICE PROBLEMS 1 A hospital...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
ERD PRACTICE PROBLEMS 1. A hospital has a large number of registered physicians. Attributes of PHYSICIAN include Phusician_ID (the identifier) and Specialty. Patients are admitted to the hospital by physicians. Attributes of PATIENT include Patient_ID (the identifier) and Patient_Name. Any patient who is admitted must have exactly one admitting physician. A physician may optionally admit any number of patients. Once admitted, a given patient must be treated by at least one physician. A particular physician may treat any number of patients, or may not treat any patients. Whenever a patient is treated by a physician, the hospital wishes to record the details of the treatment (Treatment_Detail). Components of Treatment_Detail include Date, Time and Results. 2. The entity type STUDENT has the following attributes: Student_ID, Student_Name, Address, Phone, Age, Activity and No_of_Years_participating. ACTIVITY
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 2

ERD PRACTICE PROBLEMS - ERD PRACTICE PROBLEMS 1 A hospital...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online