Question: Please list the one-to-many relationships between the database tables as follows: between the primary Student table, and the related Contract table, and between the primary

Please list the one-to-many relationships between the database tables as follows: between the primary Student table, and the related Contract table, and between the primary TUT0R table and the related contract table.

Please list the one-to-many relationships between the database tables as follows: betweenthe primary Student table, and the related Contract table, and between theprimary TUT0R table and the related contract table. BE X Clear LayoutHHH Edit Relationships Relationship Report Close Hide Table 20 Direct Relationships Add

BE X Clear Layout HHH Edit Relationships Relationship Report Close Hide Table 20 Direct Relationships Add Tables 98 All Relationships Relationships Relationships X Tools All Access Obje... Student Search... Tables E Contract Tutor PEF Student Tutor Queries StartDate Forms TutorInfo Reports TutorList Studenti FirstName LastName Address City State Zip Home Phone CellPhone BirthDate Gender Contract 1 ContractID StudentID TutorID ContractDate SessionType Length NumSessions Cost Assessment TutorID FirstName LastName Major Yearln School School HireDate Groups All Access Obje... Tutor ID Search... BB Contract X Contract ID - 6215 6220 Length (Hrs) - Number of Sessions 2 Tables FEE Contract 5 5 1 2 6 Student 6225 6230 1 5 6235 3 2 6240 2 3 6245 2 5 Tutor Queries StartDate Forms 53 Tutorinfo Reports TutorList 1 5 2 6 2 5 2 4 2 5 6250 6255 6260 6265 6270 6275 6280 6285 6290 6295 Student ID PER4055 GAL4050 VAS4040 JOH4075 PAS4020 MAL4115 NIV4110 TOL4035 DOR4030 LON4105 AND4010 RAM4025 BAR4018 COW4100 EIG4042 FRA4045 HIC4055 KIL4085 WIL4050 NIV4110 FRA4045 VAS4040 JOH4075 LON4105 LOP4015 1018 1025 1051 1005 1001 1031 1039 1008 1013 1033 1028 1023 1003 1015 1036 1020 1042 1045 1048 1060 1018 1025 1042 1015 1010 Contract Date - Session Type 7/6/2017 Group 7/10/2017 Private 7/18/2017 Group 7/21/2017 Private 7/25/2017 Semi-private 8/2/2017 Private 8/4/2017 Group 8/11/2017 Private 8/15/2017 Semi-private 8/17/2017 Private 8/23/2017 Private 8/25/2017 Group 8/30/2017 Group 9/5/2017 Private 9/6/2017 Group 9/12/2017 Semi-private 9/18/2017 Private 9/26/2017 Private 9/28/2017 Private 10/2/2017 Semi-private 10/3/2017 Group 10/6/2017 Private 10/9/2017 Private 10/11/2017 Private 10/12/2017 Private Cost - Assessment, Click to Add $400 $300 $480 M $300 $360 $300 M $400 $300 M $720 $600 M $480 $400 $400 $720 M $400 $300 M $720 $600 M $1,200 M $960 M $400 $600 M $1,200 $480 $720 2 5 3 4 2 5 1 5 6 2 6300 1 10 2 10 DIDDODO 2 6305 6315 6325 6330 8 1 10 2 5 6335 2 10 4 2 6340 6350 3 4 All Access Obje... Search... Tables Contract Student ES Tutor A Queries StartDate Forms ES Tutorinfo Reports A Student X Student ID - First Name - Last Name Address City State AND4010 Joshua Anderson 55 Boone Ct Raleigh NC BAR4018 Andrew Bartles 47 King St Cary NC COW4100 Darcy Cowler 88 Earth Way Raleigh NC DOR4030 Barbara Dorman 65 Kirby Ct Raleigh NC EIG4042 Fredrik Eigenmeyer 16 Emporium C Raleigh NC FRA4045 Salvador Francisco 11 Bobcat Dr Cary NC GAL4050 Elizabeth Gallagher 44 Winner Cir Raleigh NC HIC4055 Hildago Hickman 22 Pinwheel Ln Cary NC JOH4075 Amber Johnson 2 14th Ave Raleigh NC KIL4085 David Killian 123 Berry Dr Apex NC LON4105 Wilbur Long 55 Pond Rd Holly Spr NC LOP4015 Henry Lopez 19 8th St Raleigh NC MAL4115 Dystra Malik 14 Gaston St Raleigh NC NIV4110 Christy Niver 617 Echo In Apex NC PAS4020 Victor Pasquez 42 Nightingale Cary NC PER4055 Rosalyn Perez 421 Pine Ln Cary NC RAM4025 Ellen Ramsey 45 7th St Holly Spr NC TOL4035 Jack Tolliver 12 19th St Apex NC VAS4040 Anton Vasquez 32 Wolf Dr Raleigh NC WIL4050 Sue Williams 99 Skyblue Rd Apex NC NC Zip - Home Phone - Cell Phone 27601 919-263-4938 919-665-0119 27511 919-663-9110 919-678-1612 27601 919-264-5981 919-664-4454 27602 919-265-6549 919-664-0971 27603 919-264-2598 919-665-5540 27512 919-664-9810 919-678-4719 27602 919-265-1410 919-664-9988 27511 919-664-0129 919-678-4960 27602 919-263-4432 919-664-1992 27503 919-234-1413 919-698-9381 27540 919-355-8450 919-712-2139 27601 919-264-9981 919-665-8110 27602 919-264-6450 919-664-9125 27503 919-234-6693 919-699-0158 27511 919-662-1002 919-678-8240 27511 984-662-4761 919-678-0012 27540 919-355-5340 919-713-1654 27503 919-235-1109 919-698-1585 27602 919-263-9531 919-665-5329 27503 919-235-5343 919-699-5339 Birth Date Gender Click to Add 4/27/1998 M 11/2/1997 M 12/2/1998 F 9/16/1997 F 3/2/1995 M 5/25/1998 M 4/12/1997 F 11/12/1998 M 4/1/1997 F 11/14/1997 M 1/5/1997 M 2/19/1998 M. M 6/22/1998 M 4/12/1996 F 8/2/1998 M 4/12/1996 F 12/29/1997 F 6/2/1997 M 10/22/1998 M 2/6/1996 F TutorList All Access Obje... O Tutor X . Search... Tables Tom Contract E Student 3 Tutor Queries StartDate Forms F TutorInfo Reports TutorList Tutor ID 11001 1003 1005 1008 1010 1013 1015 1018 1020 1023 1025 1028 1031 1033 1036 1039 1042 1045 1048 1051 1060 First Name - Last Name Johnson Carey Billings Bob Smith Sally Gilbert Cathy Cowler Aaron Black Douglas Arrendale Fredrik Karlsson lan Rodriguez Jake Ballard Larry Smith Mike Johnson Nichole Schneider Barbara Alzo Ellen Desoto Gail Fordham Henry Justice Kelly Rudd Angie Hinson Donald Gallager Justin Copeland Last Name - Year In Scho Computer Science Senior Information Systems Junior Computer Science Graduate Information Systems Senior Computer Engineering Graduate Computer Science Junior Computer Engineering Senior Mechatronics Junior Computer Science Senior Mechatronics Senior Computer Science Graduate Mechatronics Senior Computer Science Junior Information Systems Senior Computer Science Graduate Information Systems Junior Computer Science Graduate Computer Science Graduate Computer Engineering Senior Computer Science Graduate Computer Science Senior School Hogan University Eikenville College Hogan University Ellings College Eikenville College Smith Technical College Ellings College Smith Technical College Potswan College Smith Technical College Hogan University Smith Technical College Switzer University Hogan University Hogan University Switzer University Smith Technical College Potswan College Franklin University Hogan University Ellings College Hire Date Groups Only - Click to Add 2/5/2017 3/1/2017 4/18/2017 n 1/15/2017 2/1/2017 5/14/2017 3/27/2017 2/6/2017 2/27/2017 4/2/2017 5/21/2017 n 1/8/2017 2/28/2017 3/12/2017 4/16/2017 2/22/2017 4/20/2017 2/27/2017 5/10/2017 1/18/2017 2/14/2017

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 Databases Questions!