Based on the information provided in Figure P3.10, please create a list of business rules that describe the relationships between entities for the BeneCo database. Please see Module 2.4 Business Rules for reference.

 

2a.) Based on the information provided in Figure P3.10, please create an ERD (Entity Relational Diagram) for the database using Crow's Foot notation. The ERD should include all the entities, relationships, and connectivity where applicable. 

 

2b.) Please specify the business rules underlying your ERD.

 

FIGURE P3.10 THE CHO3_BENECO DATABASE TABLES Table name: EMPLOYEE EMP_CODE EMP_LNAME JOB_CODE 14 Rudell 15 McDade 16 Ruellardo 17 Smith 20 Smith Table name: JOB JOB_CODE JOB DESCRIPTION 1 Clerical 2 Technical 3 Managerial 2 1 1 3 2 Table name: BENEFIT EMP_CODE PLAN_CODE 15 15 16 17 17 17 20 Database name: Ch03_BeneCo 2 3 1 1 3 4 3 Table name: PLAN PLAN_CODE PLAN_DESCRIPTION 1 Term life 2 Stock purchase 3 Long-term disability 4 Dental