P Pre Langsql Cssfilehk1style Class Course Id Title Dept Name #555

</p> <pre><code class="language-sql"> Class (course id, title, dept name, credits, sec id, semester, year, building, room number, capacity, time slot id) The set of functional dependencies that we require to hold on class are: course id->title, dept name, credits building, room number->capacity course id, sec id, semester, year->building, room number, time slot id A candidate key for this schema is {course id, sec id, semester, year}</code></pre> <p>Consider the above conditions. Which of the following relation holds?

This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 Normalization in Database Management System - Algorithms for Decomposition - Quiz No.1.

 Class (course id, title, dept name, credits, sec id, semester, year, building, room number, capacity, time slot id) The set of functional dependencies that we require to hold on class are: course id->title, dept name, credits building, room number->capacity course id, sec id, semester, year->building, room number, time slot id A candidate key for this schema is {course id, sec id, semester, year}