Reference no: EM133367765

Exercise #1: (5 points)

• A health care organization keeps track of its doctors and outpatient locations
• For each doctor it keeps track of the DoctorID (unique), DoctorName, and DoctorYearOfMDGraduation (year of graduating from medical school)
• For each outpatient location it keeps track of the OLID (unique) and OLName
• Each doctor works at either one outpatient location or at none (strictly working in the main hospital) and each outpatient location can have between none (rehab and minor health issues only) and one doctor working at it.

Exercise #2

• A health care organization keeps track of its doctors and outpatient locations
• For each doctor it keeps track of the DoctorID (unique), DoctorName, and DoctorYearOfMDGraduation (year of graduating from medical school)
• For each outpatient location it keeps track of the OLID (unique) and OLName
• Each doctor works at either between one and many outpatient locations and each outpatient location must have at least one but can have many doctors working at it
• For each occurrence of a doctor working at an outpatient location we keep track of the NoOfHoursPerWeek (number of hours per week that a doctor works at an outpatient location

Exercise#3: 

• A health care organization keeps track of its doctors and outpatient locations
• For each doctor it keeps track of the DoctorID (unique), DoctorName, and DoctorYearOfMDGraduation (year of graduating from medical school)
• For each outpatient location it keeps track of the OLID (unique) and OLName
• Each doctor works at between 2 and 4 outpatient locations and each outpatient location has between 3 and 10 doctors working at it.

Exercise#4: 

• A health care organization keeps track of its doctors
• For each doctor it keeps track of the DoctorID (unique), DoctorName, and DoctorYearOfMDGraduation (year of graduating from medical school)
• A doctor can be a resident for either one or none of the faculty doctors.  A doctor can have many resident doctors, but does not have to have any.

Exercise#5: 

• A health care organization keeps track of its doctors and outpatient locations
• For each doctor it keeps track of the DoctorID (unique), DoctorName, and DoctorYearOfMDGraduation (year of graduating from medical school)
• For each outpatient location it keeps track of the OLID (unique) and OLName
• Each doctor works at between one and many outpatient locations and each outpatient location must have at least one but can have many doctors working at it
• Each doctor manages between zero and one outpatient locations and each outpatient location has exactly one doctor managing it

Exercise #6: 

• A health care organization keeps track of outpatient locations and examination rooms within the outpatient locations
• For each outpatient location it keeps track of the OLID (unique) and OLName
• For each examination rooms it keeps track of the ERoomNumber (unique within its outpatient center, but examination rooms in different outpatient locations can have the same ERoomNumber) and ERoomSize
• Each outpatient location must have at least one but can have many examination rooms and each examination room is located in one outpatient location

Exercise #7:

• The database shall keep track of multiple products
• The database shall keep track of multiple suppliers
• The database shall keep track of multiple components
• Keep track of which suppliers provide which components for which product.
• Every product contains one or more components, each of which is provided by one or more suppliers
• Every supplier can provide many components for many products, but they also do not have to provide any components for any products.
• Every component is provided for one or many products by one or many suppliers.