Question: Which field is the Primary Key and which field is the Forgien Key? FIGURE 2.3 Linking relational tables Database name: Ch02_InsureCo Table name: AGENT (first

Which field is the Primary Key and which field is the Forgien Key?
FIGURE 2.3 Linking relational tables Database name: Ch02_InsureCo Table name: AGENT (first six attributes) AGENT_CODE AGENT_LNAME AGENT_FNAME AGENT_INITIAL AGENT_AREACODE AGENT_PHONE 501 Alby Alex B 713 228-1249 502 Hahn Leah F 615 882-1244 503 Okon John T 615 123-5589 Link through AGENT_CODE Table name: CUSTOMER CUS_CODE CUS_LNAME CUS_FNAME CUS_INITIAL CUS_AREACODE CUS_PHONE CUS_RENEW_DATE AGENT_CODE 10010 Ramas Alfred A 615 844-2573 05-Apr-2006 502 10011 Dunne Leona 713 894-1238 16-Jun-2006 501 10012 Smith Kathy w 615 894-2285 29-Jan-2007 502 10013 Olowski Paul F 615 894-2180 14-Oct-2006 502 10014 Orlando Myron 615 222-1672 28-Dec-2006 501 10015 O'Brian Amy 713 442-3381 22-Sep-2006 503 10016 Brown James 615 297-1228 25-Mar-2006 502 10017 Williams George 615 290-2556 17-Jul-2006 503 10018 Farriss Anne G 713 382-7185 03-Dec-2006 501 10019 Smith Olette K 615 297-3809 14-Mar-2006 503 B G
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
