Exams are designed to test theoretical concepts and modelling techniques introduced in lectures and tutorials. Exams will address all material from lectures and tutorials that occurred prior to the exam date.
All exams will be closed book.
You will be required to answer all questions and write in the space provided on the exam paper. Programmable calculators and other computing or communication devices are NOT permitted. Students may request the use of dictionaries, including bilingual dictionaries, supplied by Examinations Section.
You must present your Student ID to enter the exam room. You will require a HB or 2B pencil and an eraser to complete the exam. Assessment variation is possible for students with a disability (see HUPP 3.30.3 Special Arrangements for Examinations for Students with a Disability). Special Exam can be arranged by referring to the Course Profile and following the rules in http://www.uq.edu.au/hupp/index.html?page=25109 .
Middle Semester Exam (MSE), S2 2009 - 20%
(Click here for the ANSWERS)
Date: Monday 21 September 2009, Time:
10.00 - 11.40am
Venue: 08-139
Marks: 20/100
Duration: 1 Hour 30 Minutes Working Time; 10 Minutes Perusal Time
Material: Modules 1-6
Please
report to the room to at lease 10 minutes before the start of exam.
Do not forget your student card !
Preparation
-
Study the content of modules 1-6 and corresponding tutorials along with the required reading for each lecture from the text books
-
Some exercises of the chapters covered are being done in the tutorials. Attempting other relevant exercises and review questions at the end of the chapters will help you develop a through understanding of the concepts.
-
Click here for a Sample MSE (Solutions).
Format of Questions
MSE questions are similar to tutorial questions and class exercises.
FINAL EXAM S2 2009 - 50%
Date:
5:45pm 12 Nov 2009 (Draft to be confirmed)
Venue: 27A - ExHall
(See SI-Net for the finalized timetable & location)
Marks: 50/100 (Total 100 marks and they will be scaled down to 50%)
Duration: 2 Hours Working Time; 10 Minutes Perusal Time
Material: The final exam will address (theoretical) material from the entire
semester
Format: Closed book
Centrally
Controlled
Answer all
questions
Write in the space
provided on the exam paper
Questions carry
the number of marks indicated
Total number of
questions: 7
Mark Distribution of Exam Paper for S2 2009:
-
DFD – 12 Marks : Module 2
-
ER – 10 Marks: Module 3
-
Mapping – 14 Marks: Module 5
-
Relational Model – 10 Marks: Module 4
-
SQL – 24 Marks : Module 7
-
FD and Normalization – 16 Marks: Module 6
-
General Understanding – 14 Marks : Modules 1-8
SQL Question Schema to be used for the Final Exam of Semester 2, 2009 :
This database is to record information about sales of products and their manufacturers and customers who make orders to buy the products.
A primary key is underlined. A foreign key is indicated by an arrow from the foreign key to the referenced primary key.
Final Exam Preparation:
Lecture notes
Textbook
Tutorial Questions
Class Exercises/Additional Material
Revision Sheet
Past Exam Paper (S1, 2009
Others available from
library)
SWOTVAC week Consultations (2 – 6 Oct. and 11 Nov 2009)
Assessment
The exam is intended to assess the students' ability to
-
Extract specifications to create conceptual models
-
Map simple conceptual data models to relational database schema
-
Reason with logical foundation of relational data model
-
Understand the fundamental principles of correct relational database design
-
Express simple natural language queries using the SQL language (SELECT ONLY)
NOTE - NO MS Access questions in exam