It is well known that university tuition and rooming expenses are increasing; these days, students are looking to save money on their educational costs. One solution is a concept first used in Europe: Senior nursing 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 when 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. 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 certain 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. Each job has a code to help students record the hours. The volunteer jobs are categorized as music, exercise, art, bingo, reading one on one, coffee cha.t one on one, dance, and flower arranging. Students choose jobs based on their own preference. For example, one student might be a music major and play some of his new music for the residents, while another student might be an exercise science major and work with the seniors on their physical fitness. Jobs such as reading to the seniors and chatting over coffee help them pass the time and keep alert. After you set up the database, you would like to include several useful features that help Terrence keep track of important information. First, you think that a form and subform would be an efficient way of recording students' activities in various jobs. Terrence explains how important it is for students to make contact with the senior residents. He would like to see a listing of which students work with the residents one on one. He would also like to know how much time each resident spends with students in one-on-one visits. Depending on the results, he might need to encourage more residents to meet students over coffee or be read to by students. You tell Terrence that the tasks he describes can be accomplished by queries. Terrence also requests the ability to update the database records and approve students as permanent residents when they have lived at the home for at least 30 days. Again, an update query can handle this request. Next, Terrence tells you that the residents love to listen to music. He would like a listing of students who volunteer to play music so he can post it on the bulletin board for residents to see. To be eligible to live at the home for free, students must volunteer for at least 12 hours per month. Terrence would like a way to calculate hours worked and quicldy identify any students who need to increase their volunteer hours. In addition, he's curious to know which volunteer jobs are the most popular among students. Both of these requests fit nicely into Access queries. Finally, Terrence would like you to create two reports for the office staff. The first one should be a listing of each student's home address and room assignment. This report is important in case an emergency occurs and a parent needs to be contacted. The second report should display each student's name, the dates and . times they volunteered during a month, and the jobs for which they volunteered.

Using the case problem complete the following steps:

Develop a list of the pieces of data that are discussed in the case problem. (5 points)

Organize the pieces of data that would likely be in a table. (5 points)

Create the top-level ER diagram with relationships. (5 points)

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. (5 points)

Answers don't have to be very long and please answer all the questions, thanks in advance