Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started