AIU Online Management and Design of Database Worksheet
Description
Answer the following problems and exercises.
An EMPLOYEE has only one JOB_CODE, but a JOB_CODE can be held by many EMPLOYEEs.
An EMPLOYEE can participate in many PLANs, and any PLAN can be assigned to many EMPLOYEEs.
Note also that the M:N relationship has been broken down into two 1:M relationships for which the BENEFIT table serves as the composite or bridge entity.
Problem 1: For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the assigned space provided. Use the following format to show your answers.
TABLE
PRIMARY KEY
FOREIGN KEY(S)
.
.
.
.
.
.
.
.
.
.
.
.
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.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."
