If you have not already done so, create a free educational use account at Vertabelo.com. When you go to the Vertabelo “Create an account” page, make sure to follow the link that says Student or lecturer? Register here »
In order to make submitting your work easier, you may answer both questions in one model. If you do so, use the subject areas feature to visually group the tables:
These questions are constructed so they do not require any many-to-many relationships (and therefore do not require link tables) to answer.
- A hospital has a large number of registered physicians. Attributes of
physicians include physician ID and specialty. Patients are admitted to the
hospital by physicians. Attributes of patients include patient ID,
name, and DOB (date of birth). Any patient who is admitted must have exactly one admitting
physician. A physician may say and 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 seen by a physician, the hospital
wishes to record the details of the visit, which include date, time,
observed symptoms, and prescribed treatment.
- Consider a real estate firm that lists property for sale. The firm has
a number of sales offices in several states. Attributes of sales offices
include office number (identifier) and address. Each sales office is
assigned one or more employees. Attributes of employees include employee
ID (identifier) and employee name. An employee must be assigned to only
one sales office. For each sales office, there is always one employee
assigned to manage that office. An employee may manage only the sales
office to which they are assigned. The firm lists properties for sale.
Attributes of property include property ID (identifier), list price, street address, city,
state, zip code. Each unit of property must be listed with one (and
only one) of the sales offices. A sales office may have any number of
properties lists or may have no properties listed. Each unit of property
has one owner. Attributes of owners include owner ID (identifier)
and owner name. An owner may own one or more units of property.
To submit the assignment, please use Vertabelo to PDF the diagram. Upload it to Canvas and bring it to class.