Directions: Answer Problems 1-5. Refer to Module 1 in the course for directions on submitting the completed file. Point values are listed after each problem. Assignment total points = 70. Use the contents of Figure 2.1 to work problems 1-3. FIGURE 2.1 LINKING RELATIONAL TABLES Database name: Ch02_InsureCo Table name: AGENT (first six attributes) AGENT_CODE AGENTLNAME AGENT_FNAME AGENT_NTIAL AGENT_AREACODE AGENT PHONE 501 Alby Alex 228-1249 502 Hahn 882-1244 503 Olon 123-5589 713 615 Link through AGENT CODE Table name: CUSTOMER CUS CODECUS NAME CUS FNAME CUS NTIAL CUS AREACODE QUS PHONE CUS INSURE TYPE CUS NSURE AMT CUS RENEW DATE AGENT CODE 10010 Ramas 100 00 05-Apr-2018 10011 Dunne Leona 894-1229 25000 16-An-2018 10012 Smith 515 190 00 29-Jan-2019 10013 Olow Paul 300.00 14. Oct.2018 10014 Orlando Myron 515 222-1672 100.00 20-Dec-2019 10015 O Brian 442-3001 090 00 22-Sep-2010 10016 Brown James G 297.120 12000 25-Mar-2019 10017 Was 290-2956 St 25000 17..2018 10018 Ferriss Anne 382-7105 T2 10000 03-Dec-2018 10019 Smith 615 500.00 14-Mar-2019 0944-2180 61$ George 615 713 1. Write the business rule(s) that governs the relationship between AGENT and CUSTOMER (Spts) 2. Given the business rule(s) you wrote in Problem 1, create the basic Crow's Foot ERD. (Please copy and paste your diagram into this Word document). (10pts) 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.) (Please copy and paste your diagram into this Word document). (12pts) FIGURE 2.4 A COMPARISON OF THE OO, UML, AND ER MODELS UML Class Diagram ER Model INVOICE CUSTOMER generates belongs to CUSTOMER generales INVOICE 0. INV DATE INY NUMBER INY SHIP DATE INV TOTAL INVOICE INV NUMBER Integer -INV DATE Date -INV_SHIP DATE: Date -INV TOTAL : Double IN DATE N SHIP DATE NV TOTAL CUSTOMER Using Figure P2.4 as your guide, work Problems 45. The DealCo relational diagram shows the initial entities and attributes for the DealCo stores, located in two regions of the country. REGION Y REGION_CODE REGION_DESCRIPT STORE Y STORE CODE STORE_NAME STORE_YTD_SALES REGION_CODE JOB Y JOB CODE JOB DESCRIPTION JOB_BASE_PAY EMPLOYEE Y EMP CODE EMP TITLE EMP_LNAME EMP_FNAME EMP INITIAL EMP_DOB JOB_CODE STORE_CODE 00 Figure P2.4 The DealCo relational diagram 4. Identify each relationship type and write all of the business rules. (20pts) 5. Create the basic Crow's Foot ERD for DealCo. (Please copy and paste your diagram into this Word document). (20pts)