Question: need help with question #2 which field from the students table should the developer create to reference in the events table? You've been volunteering with

need help with question #2 which field from the

need help with question #2 which field from the

need help with question #2 which field from the

need help with question #2 which field from the

need help with question #2 which field from the

need help with question #2 which field from the students table should the developer create to reference in the events table?

You've been volunteering with a small nonprofit organization that serves under-privileged kids in your community. The organization reaches at-risk populations in the local school systems to match students with mentors, organize community service events the kids can participate in, and take groups camping and hiking a few times each year. The organization was built from scratch starting about four years ago and has steadily grown their list of supporters as well as a long list of contact information for students, including notes about each child's background and progress in the program. The Excel spreadsheets and haphazard collection of Word files the organizers have been using is becoming unwieldy and particularly inefficient. There have been some significant breakdowns in communication lately causing confusion, unnecessary stress, and even the loss of one of the nonprofit's sponsors. Knowing your background in information systems and your familiarity with the organization's internal processes, the board of directors has asked you to help them design a database for their sponsor and student data. They're hiring a web developer because they would like the database to be accessible through a web page. However, they believe your familiarity with their organization means you can give the web developer better guidance on how to design the database itself, which will help out with the very tight budget. BE Type here to search a 9:23 PM 2/26/2021 Excel spreadsheets and haphazar ion of Word files the organizers have been us becoming unwieldy and particularly inefficient. There have been som ant breakdowns in communication lately caushonfusion, unnecessary stress, and even the loss of one of the nonpromponsors. Knowing your background in information systems and your familiarity with the organization's internal processes, the board of directors has asked you to help them design a database for their sponsor and student data. They're hiring a web developer because they would like the database to be accessible through a web page. However, they believe your familiarity with their organization means you can give the web developer better guidance on how to design the database itself, which will help out with the very tight budget. You've not had much experience yet in developing databases. But one thing you've learned from your experience with relational databases is that it's important to think about how each of the tables is related to one or more other tables. You don't want a table that has no relationship to any other table, and you don't want a table that duplicates information already included in another table. With this thought in mind, you're ready to start listing all the tables to include in your database. Type here to search i a e ge 9:23 PM 2/26/2021 Which tables should you include? Students table and Sponsors table Students table, Sponsors table, Mentors table, and Events table Students table, Sponsors table, Mentors table, and Students' Parents table Type here to search . You start outlining the proposed structure for the database by creating four tables: Students, Sponsors, Mentors, and Events. As you start figuring out where the data from the spreadsheet and other files will fit, this list of tables is working out very well. The Events table will have a relationship to both the Students and Sponsors tables, and the Mentors table will relate to the Students table, giving each table a relationship with at least one other table without creating redundancy. As you're defining how the tables relate to each other, you realize that you need to reference a field from the Students table in the Events table to create the relationship. Next Type here to search Sluienis, SpoNSOIS, Venlors, cvents Choose Studentrieru Which field from the Students table should the developer create to reference in the Events table? Student SSN Student ID Student First Name

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!