coit12167-Practice-Exam-v1.1 - PRACTICE EXAMINATION#1...

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

View Full Document Right Arrow Icon
PRACTICE EXAMINATION #1 DATABASE USE AND DESIGN – COIT12167 Page 1 of 8 Practice Exam prepared by Mike Gregory and Mike O’Malley of Central Queensland University PRACTICE EXAMINATION #1 Instructions to the Student Please write all of your answers on paper so that you get practice doing this before the real exam. Ensure that all of your answers are clearly labelled to indicate which question they belong to. Please Note: head2right This Practice Exam is slightly harder AND longer than a real exam. This is intentional because it eliminates the possibility of any "the practice exam was easier than the real exam" arguments. head2right The format of this exam is similar to but not precisely the same as the upcoming exam. Refer to the examination memo for precise details on the upcoming exam. head2right Treat this Practice Exam like a real exam – print it out, put a " do not disturb " sign on your door, turn off your phone , and give yourself a block of 3 hours to work through the exam. head2right Solutions to Practice Exams will NOT be made available to students. head2right Check your answers by comparing and discussing your answers with other students, for example, on the Course Mailing List, and/or (for SQL Queries) by actually building the required database and running your queries against this.
Image of page 1

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

View Full Document Right Arrow Icon
PRACTICE EXAMINATION #1 DATABASE USE AND DESIGN – COIT12167 Page 2 of 8 SECTION A 20 MARKS Practical Application Question 1 – Structured Query Language (16 Marks) Formulate SQL queries to answer the following request. Use the relational tables tblClinic , tblDoctor , tblPatient , and tblTreatment provided below. You are asked to provide a general solution to each request. If the database contents change, each of your queries should continue to answer the information requested correctly. Your queries must generate the same result as shown for each request. If, for some reason, you think that the sample result is incorrect or query is not possible with given instructions then you should document this. If necessary, you may state any assumptions that may help the marker to clarify your understanding of the questions. tblClinic ClinicId ClinicName Address Telephone C001 HeartWest Clinic 111 Derrimut Road, Melbourne 03 96395555 C002 Surgery Point Clinic 121 Williamstown Road, Melbourne 03 96394422 C003 Westgate Medical Centre 150 Alma Avenue, Melbourne 03 98785151 C004 Collins St Medical Centre 352 Collins Street, Melbourne 03 86651253 C005
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern