Hospital Database: Determining Keys

Need your ASSIGNMENT done? Use our essay writing service to score better and meet your deadline.

Order a Similar Paper Order a Different Paper

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.