Multiple Choice Questions. Mark the best answer.

Suppose that we have a not-null constraint imposed on every field in the database. We are creating a new department, and, therefore, we would like to add tuples for this new department to the following relations: course, department, instructor, student, and prereq. All of the following would be valid orders in which we add tuples to relations EXCEPT: a) department, course, instructor, student, prereq b) department, prereq, instructor, student, course c) department, instructor, course, prereq, student

Suppose that there are n tuples in the takes table and m tuples in the course table. How many tuples are in the result of the query: takes course?

a) 0 b) n c) m d) n + m e) n m f) Cannot be determined from the information given g) None of the above

student takes ID course_id sec_id semester year name dept_name tot_cred grade section advisor course id sec_id course course_id title dept_name credits semester department dept_name building budget Slid i id year building room_no time_slot_id time_slot time slot_id day start_time end_time instructor classroom building room_no capacity prereq course_id prereg_id ID name dept_name salary teaches course_id sec_id semester year