(Solved): Use the database shown in Figure P3.1. Note that the database is composed of four tables that refle ...

Use the database shown in Figure P3.1. Note that the database is composed of four tables that reflect these relationships: - A JOB can be assigned to many EMPLOYEEs but one EMPLOYEE can be assigned to only one JOB. - An EMPLOYEE can participate in many PLANs, and a PLAN can be assigned to many EMPLOYEEs. Note that the M:N (many to many) relationship between EMPLOYEE and PLAN has been broken down into two 1:M (one to many) relationships for which the BENEFIT table serves as the composite or bridge entity. Hint: Helpful Homework Video Two demonstrates how to model a many to many relationship. FIGURE P3.1 The Ch03_BeneCo DatabaseT ables $\mathbf{P}$ ?e in th Problem 2: Create Crow's foot to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN. Put the answer for both problems into a single Word document or text file when you are ready to submit your assignment.