{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

437Midterm_Fall2006_T1_solution

437Midterm_Fall2006_T1_solution - SAUDER SCHOOL OF BUSINESS...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
SAUDER SCHOOL OF BUSINESS UNIVERSITY 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)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon