Entity relationship diagram
Hi,
I need assistance to the enclosed problem please.
Regards,
1. Draw the entity relationship diagram for the relationship between EMPLOYEE and JOB.
Employee
EMP_CODE | EMP_LNAME | JOB_CODE
14 Rudell 2
15 McDade 1
16 Ruellardo 1
17 Smith 3
20 Smith 2
Benefit
EMP_CODE | PLAN_CODE
15 2
15 3
16 1
17 1
17 3
17 4
20 3
Job
JOB_CODE | JOB_DESCRIPTION
1 Clerical
2 Technical
3 Managerial
Benefit
Plan
PLAN_CODE | PLAN_DESCRIPTION
1 Term Life
2 Stock Purchase
3 Long-life disability
4 Dental
- Plain text response
- Attached file(s):
- Solution17.doc
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Database-entity integrity - Hi, I require assistance to the enclosed problem please. I need to draw the entity relationship diagram to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN. Regards,
- Difference between extend and include relationships - I require assistance in describing in my own terms the difference between the extend and include relationships with an example.
- Give examples of the following Database relationships: one-to-one one-to-many many-to-many - Look for an example of a one-to-one relationship, an example of a one-to-many relationship, and an example of a many-to-many relationship in a newspaper, magazine, book, or everyday situation you enco ...
- Databases-ERD diagram requirement - Hi, I need assistance to the enclosed problem. Regards, Problem: Draw the entity relationship diagram for this database. Reference Figures: TABLE PRIMARY KEY FOREIGN KEY(S) TRUCK BA ...
- Relationships - Look for an example of a one-to-one relationship, an example of a one-to-many relationship, and an example of a many-to-many relationship in a newspaper, magazine, book, or everyday situation you enco ...
