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 patients 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.