Hospital Database: Determining Keys

Develop a Microsoft Access database based upon the following business scenario. Be sure to include tables, fields, keys, relationships, and test data in your database. Your final submission will be a Microsoft Access database.

A hospital stores data on patients and hospital rooms. At minimum, the patient's name and date of birth should be stored.

Some patients are outpatients and not assigned to a hospital room. Some patients are resident patients and assigned to a room.

Rooms are identified by a room number. At minimum, the room type of private or semi-private should be stored.