SAUDER SCHOOL OF BUSINESSUNIVERSITY OF BRITISH COLUMBIA COMM 437 – Introduction to Database Design and Application Fall 2006 Term 1 Mid Term Examination One sheet (2 pages) notes allowed. NO lecture notes, text book, assignment solutions, and other electronic devices allowed. Time allowed: 1.5 hours Instructions: - There are a total of six (6) pages including this page.- Use the booklets provided to answer the following THREE (3) questions. - Please make any assumptions that you make explicit in your answer. - If you have any questions, please ask the invigilator. - Please remember to write your name and student number on your answer booklets. - Please hand in the questions sheets together with your answer booklets. - If you finish the exam early, you can hand in your answer booklets and leave the classroom. No one is allowed to leave the classroom during the last 10 minutes of the exam. Question 1. SQL (Structured Query Language) (Total 20 marks) Please use the ER Diagram on the following page to answer this question. (Continue on next page)
has intentionally blurred sections.
Sign up to view the full version.