Database good work hospital | Computer Science homework help

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.