Instructions

Consider the following relation with sample data:

StudentID	StudentName	ClassID	ClassName	InstructorID	InstructorName	CompletionDate
SID55	Sarah Smith	C-101	Intro to Math	IN1	Ed Seifert	12/19/2018
SID55	Sarah Smith	C-103	Algebra	IN2	Sam Alcatraz	05/10/2019
SID33	Mohammed Issa	C-102	Biology	IN3	Elizabeth Hamilton	05/05/2022
SID33	Mohammed Issa	C-103	Algebra	IN1	Ed Seifert	12/22/2022
SID77	Alejandro Martinez	C-101	Intro to Math	IN2	Sam Alcatraz	05/04/2020
SID11	Lisa Jones	C-104	Intro to Programming	IN1	Ed Seifert	12/21/2019

The Student Class Completion Table captures the data about students classes, instructors, and completion data.

Each student has a unique StudentID and StudentName.

A class has a unique ClassID and ClassName.

An instructor has a unique InstructorID and InstructorName.

A student can take and complete multiple classes.

When a student completes a class, the date the class was completed and the instructor who taught the class are recorded.

Answer the following questions:

Question 1: Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the Student Class Completion Table.

Question 2: Show the result of normalizing the Student Class Completion Table to second normal form (2NF).

Question 3: Show the result of normalizing the Student Class Completion Table to third normal form (3NF).

Explain each answer.