54.11 Consider the following relation with sample data. STUDENT INTERNSHIP TABLE StudentID StudentName EmployerlD EmploverName PositionID PositionDescription Joe Mike Sue Pat Bob Joe Axel Alarm Axel Alarm Banex Inc Banex Inoc Banex Inc Calypso Corp1 Sales Intern IT Help Desk Intern Sales Intern Front Desk Intern Front Desk Intern Marketing Specialist Intern 2 2 The STUDENT INTERNSHIP Table captures the data about student internships Each student has a unique Student ID and a Student Name Each employer has a unique Employer ID and an Employer Name Within each employer, there are positions available Each position has a unique Position ID within an employer (iwo positions from two different employers can have the same Position ID) and a Position Description Each student can work for only one employer and can hold only one position within that employer More than one student can work in the same position at the same employer 4.11a Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the STUDENT INTERNSHIP Table E4.11b Show the result of normalizing the STUDENT INTERNSHIP Table to 2NF E4.11 c Show the result of normalizing the STUDENT INTERNSHIP Table to 3NF 54,12 Consider the following relation with sample data