Question: Database question. Draw an EER DIAGRAM from the problem below. A person in reference to a hospital is an employee, physician, and/or a nurse. An

Database question. Draw an EER DIAGRAM from the problem below.  Database question. Draw an EER DIAGRAM from the problem below. A

A person in reference to a hospital is an employee, physician, and/or a nurse. An employee can be a technician, staff, or manger. A Physician visits patients and work in only one clinic. For every person the following attributes are collected: social security, name, sex, address, and birth date. Address includes number, street, city, state, and zip. In addition each physician has an expertise, each nurse has a rank and may have several degrees, and each employee has years of experience and a title. Each manager manages only one clinic. Each technician has certificate, each staff has an hourly rate, and each manager has a manger ID and phone. address and building code. Each technician maintains a building. Each building has building number, building For each patient the following information are collected: PatientID, Patient name (First, Middle Last), date of birth, age, and several symptoms. Each symptom has a name and duration. Each clinic has a name, number of visiting rooms, number of beds

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!