Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is a Database related question T0Bday. Odober 23 Figure T1 EMPLOYEE BENEFIT EMP Code PLAN Code EMP Code EMP Lname OB Code 14 Rudel

This is a Database related question
image text in transcribed
image text in transcribed
T0Bday. Odober 23 Figure T1 EMPLOYEE BENEFIT EMP Code PLAN Code EMP Code EMP Lname OB Code 14 Rudel 15 McDade 16 Ruellardo 17 Smith 20 Smith 15 15 16 17 17 17 PLAN PLAN_Code PLAN_Description JOB 0B Code JOB Description 1 Term Life 2 Stock Purchase 3 Long-term Disability 4 Dental 1 Clerica Use the figure (T1) above to draw an entity relationship diagram (EFD) in the space provided below to complete the followingfour problems Problem #1 (1 point): Identifyalprmary keysin yor R by folowing the rarneofeach primary ay with the letters PKC in parentheses Problem#2(1 point):ioontify all forogn keysn your by ollowingthe name of eatbragniny with the letters. Rin prethos Problem #3 ( 1 point): Daw lines between entities in your Bo, as nodod, to graphically ilustrate strong versus weak relationships Problem #4 (2 points. Gaphically illustrate minmn and madrunardrality for the relationships between entities in your ED

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Database Technology Management For The Year 2000

Authors: Alan Simon

1st Edition

155860264X, 978-1558602649

More Books

Students also viewed these Databases questions

Question

Question How are IRAs treated for state tax law purposes?

Answered: 1 week ago