PROBLEM 1 a. Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the Student Internship Table b. Show the result of normalizing the Student Internship Table to 2NF.

icon
Related questions
Question

PROBLEM 1

a. Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the Student Internship Table

b. Show the result of normalizing the Student Internship Table to 2NF.

STUDENT INTERNSHIP TABLE
StudentID StudentName EmployerID EmployerName PositionID
Axel Alarm
Axel Alarm
Banex Inc
Banex Inc
Banex Inc
Calypso Corp
111
222
333
444
555
666
Joe
Mike
Sue
Pat
Bob
Joe
A
A
B
B
B
с
1
2
2
1
1
1
Position Description
Sales Intern
IT Help Desk Intern
Sales Intern
Front Desk Intern
Front Desk Intern
Marketing Specialist Intern
Transcribed Image Text:STUDENT INTERNSHIP TABLE StudentID StudentName EmployerID EmployerName PositionID Axel Alarm Axel Alarm Banex Inc Banex Inc Banex Inc Calypso Corp 111 222 333 444 555 666 Joe Mike Sue Pat Bob Joe A A B B B с 1 2 2 1 1 1 Position Description Sales Intern IT Help Desk Intern Sales Intern Front Desk Intern Front Desk Intern Marketing Specialist Intern
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer