This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: NetID: CS411 Midterm Exam CS411 Database Systems Fall 2009 University of Illinois at Urbana-Champaign Midterm Examination October 13, 2009 Time Limit: 75 minutes Print your name and NetID below. In addition, print your NetID in the upper left corner of every page. Name: NetID: Closed notes; closed book; no sheet of formulas permitted. Please write your answers directly on the exam sheet. The space we left for your answers is often more than what you actually need. Please use the back side of the exam as scratch paper. In case you find a question ambiguous, please write down your assumption and answer the question accordingly. You may use temporary relations, if you like, for any of the queries below. If you use the same temporary relation for a second exam question, you must redefine the relation in your answer to the second question. In other words, your answer to each question should be self-contained. Problem 1 2 3 4 5 6 Total Points 10 16 15 15 20 14 90 Score Grader Turn over the page when instructed to do so. Good Luck! 1 of 11 NetID: CS411 Midterm Exam Problem 1 Basic Concepts (10 points) For each of the following statements, indicate whether it is TRUE or FALSE by circling your choice. You will get 1 point for each correct answer,- 1 point for each incorrect answer, and point for each answer left blank. 1) TRUE FALSE A weak entity set does not have any attribute that belongs to its key. 2) TRUE FALSE Every isa relation in the ER model is one-one. 3) TRUE FALSE If a functional dependency A B holds in relation R(A, B, C), then AC B also holds....
View Full Document
- Fall '07