Question: Using the database shown in Figure P 3 . 1 , the database is composed of four tables that reflect these relationships: - A JOB

Using the database shown in Figure P3.1, 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 JOB55.
- An EMPLOYEE can participate in many PLANs, and a PLAN can be assigned to many EMPLOYEEs.
- 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.
For each table in the database above, I identified the primary key and the foreign key(s) in the purple table provided. When the table does not have a foreign key, I wrote None in the assigned space provided. Now, all that has to be done is create a crow's foot to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN.
Please let me know: what I am lacking in my creation of crow's foot?
Using the database shown in Figure P 3 . 1 , the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!