You will now make some observations based on the following questions:

1. What happens when you try to enter a record into the Service table for which there is no corresponding record in the Customer table?
2. What happens when you try to delete a record from the Customer table for which there is at least one corresponding record in the Service table?
3. What happens when you try to change the value of "Customer #" in the Customer table for which there is a corresponding record in the Service table and the new value is not an existing customer number?

Customer Table ID - Customer 11 22 > 20 4.4 Last Name - First Name Wagoner Sam Calahan Eliza Smith Alto Lake James Meadows Sara Monarch Gua Amy Rivera Juan Williams Max Villas Jimi Xiong Sierra 6 64 Shaile Street - City State Zip Code 5480 Alpine Street Boulder CO 80300 2140 Edgewood Avenue Boulder CO 80200 114 Lexington Street Boulder CO SOBOU 701 Eastman Road Boulder CO 80200 Pond Hill Drive Boulder Co 80208 431 Phillips Lane Roulder CO 80208 1995 Snow Avenue Roulder CO 20301 182 Weston Avenue Boulder CO 230 Southpark Circle Boulder CO 123 Mountain Lane Boulder CO 8909 Spring Lake Drive Boulder CD Boulder CO 80108 Phone - First Pickup (309) 161-5545 05/25/2004 (202) 896-6003 05/25/2004 (202) 338-7111 00/02/2004 (303) 562 4499 08/25/2005 (303) 792-3646 02/28/2004 (303) 352-4847 07/17/2005 (302) 555-6731 05/19/2005 (303) B15-2456 12/28/2001 (303) 333-0000 07/19/2003 (203) 525-1111 11/19/2003 (303) 222-3434 01/10/2004 B0108 880 9 85 10 90 11 99 [New! ii Service ID Customer # - Service Date - Weight Pape - Weight Othe Ba 21 11/22/2007 8 15 31 10/15/2007 32 85 41 11/7/2007 12 43 25 1 01/15/2007 44 25 26 1 01/22/2007 8 63 27 1 02/28/2007 37 91 52 11/07/2007 19 0 62 11/22/2007 28 174 10 20 10/15/2007 18 40 11 20 11/22/2007 35 60 28 20 01/03/2007 99 104 73 10/15/2007 5 8 8 3 11/22/2007 16 32 93 12/04/2007 7 12 29 3 01/22/2007 7 18 12 80 10/15/2007 10 10 13 80 11/07/2007 9 13 14 80 11/22/2007 16 18 15 80 12/04/2007 18 21 22 85 01/05/2007 26 39 23 85 01/12/2007 73 19 24 85 02/19/2007 11 19 16 90 01/07/2007 15 15 17 90 02/14/2007 28 56 18 90 02/21/2007 5 125 19 99 01/07/2007 89 73 20 99 02/14/2007 42 51 21 99 02/21/2007 5 10 Relationships Customer Table ID Customer Last Name First Name Street City State Zip Code Phone 81 Service ID Customer # Service Date Weight Paper Weight Other