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

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

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!