E4.s Consider the following relation with sample data. LANGUAGE SCHOOL TABLE Cou
ID: 3602868 • Letter: E
Question
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 3NFExplanation / Answer
A->B
a)COURSE ->course ID CLIENT->clientID cleint->client name
course->course language
course->course level
COURSE->COURSE ID,COURSE LANGUAGE,COURSE LEVEL,CLIENT ID,CLIENT NAME,ATTENDANCE,FINAL SCORECLIENT->COURSES,ATTENDANCE,FINAL SCORE
COURSE
ID
c)
COURSE
ID
course langu course level client ID client name ATTENDANCE 10 german basic c111 mr smith 100% 11 german intermediate c555 mr wong 90%Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.