1. Yes, the entity VISIT (scheduled for outpatients) is clearly a weak entity.

2. A hospital has many business rules. Two examples are the following:

a. A patient cannot be admitted to the hospital without a referral from a responsible physician.

b. A nurse can be reassigned to a different care center only by permission of the nurse in charge of the care center where the nurse is presently assigned.

3.

4. Following are some sample definitions:

a. Entity types:

Physician- a person who is licensed to practice medicine in this state.

Patient- a person who has been admitted to MountainView Community Hospital or who is currently being treated as an outpatient by the hospital.

Employee- a person who has an employment agreement with the hospital and who is on the hospital payroll.

Care center- an organizational unit that performs a related set of services directed toward patient care.

b. Attributes:

Person_ID- a person’s social security number

Birth_Date- month, day, and year a person was born

Specialty- a physician’s area of practice

Location- the floor number and hospital wing for a care center or laboratory.

c. Relationships:

Assigned- associates a resident patient with a hospital bed

Scheduled- associates an outpatient with an instance of a visit to the hospital