1. Table name: AGENT (first six attributes) AGENT CODE AGENT LNAME AGENT NAME AGENT TIAL AGENT AREACODE AGENT PHONE 501 Alby 602 Han 503 Alex Leah John 713 615 015 220-1249 002-1244 123-5509 Database name: Ch02 InsureCo Table name: CUSTOMER Link through AGENT_CODE cus coce cus HAME CUS FNAME CUS INITIAL CUS AREACODE CUS PHONE CUS INSURE TYPE CUS NEURE AMT CUS RENEW DATE AGENT Coce 10010 344-2573 " 094-1230 " Alfred A 10011 Dunne Leona K 615 713 100.00 25000 05-Apr-2018 500 16-Jun-2010 501 10012 Smith Kathy in 615 894-2205 52 150.00 29-Jan-2019 500 10013 Olow P eis 04-2180 $1 300 00 14-04-2018 502 10014 Orlando Myron 615 222-1672 " 100.00 20-Dec-201 501 10015 Oian 10016 Brown Any 713 442-3381 12 50.00 22-Sep-2018 500 10 615 297-1220 $1 120.00 25-Mar-2019 502 10017 Vans 10018 Friss 10019 Sn George 615 290-2556 St 250.00 17--2018 503 Anne 10 713 382-7185 12 100.00 3-Dec-2018 501 Olethe K 615 297-3009 52 500.00 14-Mar-2013 500 Write the business rule(s) that govern the relationship between AGENT and CUSTOMER. 2. Given the business rule(s) you wrote in Problem 1, create the basic Crow's Foot ERD. 3. Using the ERD you drew in Problem 2, create the equivalent object representation and UML class diagram. (Use Figure 2.4 as your guide.) FIGURE P2.4 THE DEALCO RELATIONAL DIAGRAM REGION REGION CODE REGION DESCRIPT STORE STORE CODE STORE NAME STORE YTD SALES REGION CODE EMPLOYEE EMP CODE JOB JOB CODE JOB DESCRIPTION JOB_BASE_PAI EMP TITLE EMP LNAME EMP FNAME EMP INITIAL EMP DOB JOB CODE STORE CODE .4. Using Figure P2.4 as your guide, work Problems 4 and 5. The DealCo relational diagram shows the initial entities and attributes for the DealCo stores, which are located in two regions of the country. Identify each relationship type and write all of the business rules. 5. Create the basic Crow's Foot ERD for DealCo.