Create a entity-relationship diagrams, Database Management System

This project requires you to create a database design.  Your design will be documented in a set of Entity-Relationship diagrams.  Draw a set of Entity-Relationship diagrams to model the following scenario.
 
OHIP wants to track its' doctors, patients and hospitals.
 
For the doctors, your design must be able to store:

  • the doctor's unique license number
  • the doctor's first name
  • the doctor's last name
  • the doctor's specialty
  • the date the doctor became licensed

For the patients, your design must be able to store:

  • the patient's unique OHIP number
  • the patient's first name
  • the patient's last name
  • the patient's address
  • the patient's date of birth

For the hospital, your design must be able to store:

  • the hospital's name
  • the city where the hospital is located
  • the province where the hospital is located
  • the number of beds in the hospital
  • a unique hospital code number (an H followed by 3 digits, for example H001).

Finally, you need to store the following relationships:

  • Depending on their specialty, a doctor will be given privileges in the any number of hospitals in their area.  Not all of the area doctors will be given hospital privileges.  A hospital will always have any number of doctors assigned privileges. 
  • When a patient is admitted to the hospital, they will always be assigned to a doctor. A patient

can be seen by more than one doctor and a doctor can have more than one patient that they are attending to. Since the assignments relate to the doctor's area of specialty, a doctor may not always have patients assigned to them. One doctor will be given the position of the Chief Doctor at the Hospital. A doctor will only be the Chief Doctor for one hospital at a time.  Every hospital must have a Chief Doctor. Not all doctors in the area will be a Chief Doctor for a Hospital in the area. When a serious medical condition arises, a patient will be admitted to the closest hospital. A hospital may have many patients, but a patient will only be admitted to one hospital. All hospitals will have patients that have been admitted and are waiting to be treated. An individual is not considered a patient of the hospital unless they have been admitted to the hospital and are waiting to be treated.

Posted Date: 2/21/2013 4:08:47 AM | Location : United States







Related Discussions:- Create a entity-relationship diagrams, Assignment Help, Ask Question on Create a entity-relationship diagrams, Get Answer, Expert's Help, Create a entity-relationship diagrams Discussions

Write discussion on Create a entity-relationship diagrams
Your posts are moderated
Related Questions
Explain in detail about Collaboration Diagrams Collaboration diagrams are interaction diagrams which emphasize structural organisation of an object that transmit and receive m

Question 1 Discuss about second normal form and third normal form Question 2 Write short note on                        1) Data Manipulation Language 2) Data Definition La

How are tables stored on Disk? We realise that every record of a table can have different amounts of data. This is due to in some records; some attribute values may be "zero".

Report writing help on database mgmt Project Description: Use of Harvard referencing, critical analysis is required. Skills required: Academic Writing, Technical Writin

Information about films holds information about movies, stars and studios. Movies have a title, year of production, length and the film type. Stars have a name and address. Studi

coventions for displaying an ER schema as ER diagram

CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., cruise control) that were sold at a de


Q.   Explain  data aggregatio n and discuss different design constraints. Sol. Aggregation   One limitation of the E-R model is that it cannot express relationships amon

online eductional management system ke diagram