E4.s Consider the following relation with sample data. LANGUAGE SCHOOL TABLE CourselD 10 80% C111 Mr. Smith 10096 Germarn German Intermediate C222 Ms. Jones 90 Advanced IC333 |Mr. Vance | 9596 Basic Intermediate C555 Ms. Wong90% Advanced | C666 | Ms. Hess 9596 Basic 90% 100% 10096 95% 98% C444 | Ms. Clark 10096 German German German 10 12 20 C1 1 1 | Mr. Smith | 100% 100% 100% Intermediate | C222 | Ms. Jones | 95% Each course can be completed by multiple dlients .Each client can complete multiple courses. . When a client completes a course, his or her attenda The LANGuAGE SCHOOL Table keeps track of clients completing language classes . Each course has a unique Course ID and a Course Lan- final score in the class are recorded. guage and Course Level .Each client has a unique Client ID and a Client Name. Question a: Depict full key funcational dependencies, partial functional dependencies (if any), and transative functional dependencies (if any) in the above Language School Table. Question b: Show the result of normalizing the above Language School Table to 2NF. Question c: Show the result of normalizing the above Language School Table to 3NF