GURE 1 fight contain a sales agents number that is also contained in the AGENT table. Linking relational tables able name: AGENT (first six attributes) AGENT CODE AGENT_LNAME AGENT_FNAME AGENT INITIAL AGENT_AREACODE AGENT_PHONE 501 Alby 502 Hahn Alex Leah B F 503 Okon John T 713 615 615 Link through AGENT_CODE 228-1249 882-1244 123-5589 Database name: Ch02_InsureCo Table name: CUSTOMER CUS_CODE CUS_LNAME CUS_FNAME CUS_INITIAL CUS_AREACODE CUS PHONE CUS INSURE TYPE CUS INSURE AMT CUS RENEW_DATE AGENT_CODE 10010 Ramas 05-Apr-2012 Alfred A 615 844-2573 T1 100.00 502 10011 Dunne Leona K 713 894-1238 T1 250.00 16-Jun-2012 501 10012 Smith Kathy W 615 894-2285 S2 150.00 29-Jan-2013 502 10013 Olowski Paul F 615 894-2180 S1 300.00 14-Oct-2012 502 10014 Orlando Myron 615 222-1672 T1 100.00 28-Dec-2013 501 10015 O'Brian 10016 Brown 10017 Williams 10018 Farriss 10019 Smith Amy B 713 442-3381 T2 850.00 22-Sep-2012 503 James G 615 297-1228 S1 120.00 25-Mar-2013 502 George 615 290-2556 S1 250.00 17-Jul-2012 503 Anne Olette OK G 713 382-7185 T2 100.00 03-Dec-2012 501 615 297-3809 S2 500.00 14-Mar-2013 503 SOURCE: Course Technology/Cengage Learning CONLINE CONTENT This chapter's databases are available at www.cengagebrain.com. For example, the contents of the AGENT in the database named Ch02 InsureCo