Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Employeeld SSN HireDate Service Years UserID Building Num OfficeNum 349841 2 35892346 07-30-2018 1 bsmith 2 101 937841 567655892 07-30-2018 1 tgupta 4. 112 372876

image text in transcribed

Employeeld SSN HireDate Service Years UserID Building Num OfficeNum 349841 2 35892346 07-30-2018 1 bsmith 2 101 937841 567655892 07-30-2018 1 tgupta 4. 112 372876 575892346 08-22-2018 1 jnwankpa 2 113 783498 245492345 12-31-2018 0 jwang 212 231412 895892786 02-21-2018 1 rjones 4 264 653522 245892322 04-11-2016 3 esanchez 1 210 566643 3 15896746 08-22-2018 1 qjohns 4 101 112398 524589156 10-19-2018 0 stadisina 3 101 Note: Service Years increases by one for every full year the employee has been employed. a. Use the relation above (it is in at least 1NF) to determine ALL functional dependencies that the data suggests MAY be present. Use A B notation. To be very clear, identify all minimal functional dependencies that have data that suggest this functional dependency may exist even if you think the functional dependency would fail a logical test. You have more blank spaces below than you need. Use 'ALL' on the right side when the determinant determines every attribute in the relation other than itself. Fill in how ever many you find. Note any assumptions. 7 b. Would any of these functional dependencies cause you to be the surprised if it was not removed as a functional dependency when it is eventually tested logically? If you have more than one then choose the one that would surprise you the most. Briefly explain your reasoning

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_2

Step: 3

blur-text-image_3

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

Databases Illuminated

Authors: Catherine M. Ricardo

1st Edition

0763733148, 978-0763733148

More Books

Students also viewed these Databases questions

Question

a. What is the purpose of the team?

Answered: 1 week ago

Question

a. How are members selected to join the team?

Answered: 1 week ago