Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Draw an EER diagram according to the notations discussed in class to accurately represent the design specification below. You can use any tools (e.g., draw.io)
Draw an EER diagram according to the notations discussed in class to accurately represent the design specification below. You can use any tools (e.g., draw.io) to draw the EER diagram or simply draw it by hand. In your diagram, indicate all the super classes, subclasses, constraints of specialization/generalization, entity sets, relationship sets, cardinality ratios, participations, attributes, and primary keys. Clearly specify any reasonable assumptions if they are not specified in the design specification. Submit your EER diagram and assumptions in a PDF file. Design Specification: The following is the description of a hospital information database. As a large service organization, Valley Creek Community Hospital depends on a large number of persons for its continued success. There are four groups of people on whom the hospital is most dependent: Employees, Physicians, Patients, and Volunteers. (Physicians are not classified as Employees for the purpose of this project). There are several common attributes that are shared by all of these persons: Person_ID (unique identifier), Name, Birth_date, Phone, and Address. Each address can be accessed as Street_address, City, State, and Zip_code individually and the entire address can also be retrieved as a unit. Each of the four groups has at least one specific attribute of its own. Employees have a Date_hired, Volunteers have a Skill, Physicians have a Specialty and Pager\#, and Patients have a Contact_date. There might be additional personnel in the hospital community who do not belong to one of these four groups. A particular person may belong to more than one groups (for example, Patient and Volunteer). Each patient has one and only one physician responsible for them. A given physician may not be responsible for any patient or may be responsible for one or more patients. Patients are divided into two groups: inpatient and outpatient. Each patient classified as an inpatient has a Date_admitted attribute. Each patient classified as an outpatient is scheduled for one or more visits. Each visit has a Date (partial identifier) and Comments. Notice that a visit cannot exist without an outpatient entity. Employees are subdivided into three disjoint groups: Nurses, Staff, and Technicians. Nurses have a Certificate attribute that indicates the qualification. Staff has an attribute Job_class. Technicians have one or more Skills. Each technician is assigned to one or more laboratories. Attributes of laboratories include Name (unique identifier) and Location. A laboratory has one or more technicians assigned
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started