StudentID 111 222 333 444 555 666 StudentName Joe Mike Sue Pat Bob Joe EmployerID A PositionID Axel Alarm Personal Aeronly do not res 2020-08-20 B B B EmployerName C Banex Inc Banex Inc Banex Inc Calypso Corp 2 1 1 PositionDescription 1 Sales Intern IT Help Desk Intern Sales Intern Front Desk Intern Front Desk Intern Marketing Specialist Intern

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.

StudentID
111
222
333
444
555
666
StudentName
Joe
Mike
Sue
Pat
Bob
Joe
EmployerID
A
PositionID
Axel Alarm
Personal Aeronly do not res
2020-08-20
B
B
B
EmployerName
C
Banex Inc
Banex Inc
Banex Inc
Calypso Corp
2
1
1
PositionDescription
1
Sales Intern
IT Help Desk Intern
Sales Intern
Front Desk Intern
Front Desk Intern
Marketing Specialist Intern
Transcribed Image Text:StudentID 111 222 333 444 555 666 StudentName Joe Mike Sue Pat Bob Joe EmployerID A PositionID Axel Alarm Personal Aeronly do not res 2020-08-20 B B B EmployerName C Banex Inc Banex Inc Banex Inc Calypso Corp 2 1 1 PositionDescription 1 Sales Intern IT Help Desk Intern Sales Intern Front Desk Intern Front Desk Intern Marketing Specialist Intern
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution