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.