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 P 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.
M:N many to many relationship between EMPLOYEE and PLAN has been broken down into two :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 keys 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?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
