Using the Room and Board case problem complete the following steps:

1) Develop a list of the pieces of data that are discussed in the case problem.

2) Organize the pieces of data that would likely be in a table.

3) Create the top-level ER diagram with relationships.

4) Create a list of additional questions that you would provide further guidance in the database design. Include the stakeholder that you would gather the information from.

3 THE ROOM AND BOARD DATABASE Designing a Relational Database to Create Tables, Forms, CASE Queries, and Reports PREVIEW In this case, you will design a relational database for a senior home that provides free room and board for select local university students who volunteer to work with the senior residents. After your design is completed and correet, you will create database tables and populate them with data. Then you will produce one form with a subform, six queries, and two reports. The queries will show which students work one- on-one with the seniors, the amount of time students have worked with a particular senior, which students play music for the seniors, the amount of time each student has worked with seniors, and which volunteer jobs are the most popular at the home. You will produce two reports: One lists students' room assinments and their home addresses, and the other is based on a query that displays the volunteer job summary PREPARATION Before attempting this case, you should have some experience in database design and in using Microsoft Access. .Complete any part of Tutorial A that your instructor assigns. Complete any part of Tutorial B that your instructor assigns, or refer to the tutorial as necessary Refer to Tutorial F as necessary BACKGROUND It is well known that university tuition and rooming expenses are increasing; these days, students are looking to save money homes offer university students free room and board in exchange for volunteering to work a certain number of hours with the resident seniors each month. Experience in Europe has shown that seniors thrive whern living with young people, and the young people often enjoy the arrangement as well, associating the senior residents with their grandparents. The local senior home in your university town is starting a small program based on the European model, and needs your help in setting up a database to track the students and their volunteer hours. Because you are studying database design and Access, you know that the software is a perfect fit for the small database system the senior home needs. on their educational costs. One solution is a concept first used in Europe: Senior nursing Your first task is to meet with Terrence Brown, the director of the senior home, to figure out how the business works and how to support it with the database. He explains to you how the students live at the home and integrate with the residents. To begin, students move into private rooms on different floors of the home on a trial basis. For example, Terrence explains, students must be quiet at eertain times and not entertain a lot of visitors, so the trial period helps ensure that the students are a good fit. After the trial period, students are considered permanent residents for the academic year You realize that the database you create must record student information, such as their name, home address, phone number, email address, and credit card number in case of damages or extra expenses Currently, Terrence keeps a list of rooms and writes the student's ID number next to the appropriate room number to keep track of where the students are staying. He also uses this list to note the date the student moved in. After the 30-day trial period, Terrence marks the record with a big "P" for "permanent." You realize that you will need a better way to indicate whether room assignments are approved or not. In addition to keeping the student information himself, Terrence relies on the students to manually record details of the volunteer jobs they do at the senior home, including the date and the start and end times of each job