City Guilds Model Questions Vol1 2017 Information Technology Question 23
Practice objective / multiple choice question 23 from the 2017 City Guilds Model Questions Vol1 Information Technology examination.
Consider the relation STUDENT(CourseID, StudentID, Name, Score, Instructor) where the primary key is \((CourseID, StudentID)\). The functional dependencies are:\n\(CourseID \rightarrow Instructor\)\n\(StudentID \rightarrow Name\)\n\((CourseID, StudentID) \rightarrow Score\)\n\n(a) Decompose the relation into a set of tables that are in Boyce‑Codd Normal Form (BCNF). How many tables result from the decomposition?\n\n(b) Write an SQL query that returns the names of instructors whose courses have an average student score greater than 85.
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2017 Information Technology Question 23. It is one of the objective questions from the 2017 City Guilds Model Questions Vol1 Information Technology examination.
Difficulty level: Medium .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.