Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________

Related MCQs

• Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________ .
• Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.
• Department (dept name, building, budget) and Employee (employee_id , name, deptname,salary) Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.
• Given the following relation it is not 3 NF because Student (roll no, name, course no, course max. marks, year of study, address)
• Given the following relation Student (roll no, name, course no, course max. marks, year of study, address) The corresponding 3 NF relations are
• Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
• Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
• Thus a                of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.
• Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.
• The predicate in a where clause can involve Boolean operations such as and. The result of true and unknown is               false and unknown is            while unknown and unknown is