This course will have two exams: Mid Semester and a Final. 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.
More information on exams will be provided on the exam page on the course web site at the appropriate time.
Final Exam
Date: 19 June 2008
Time 8.00 AM
Venue: Union Complex - Heath
Marks: 60/100
Material: All content covered in the course (lecture notes, problem solving
questions, readings, class exercises)
Format: Similar to problem solving sessions and mid semester exam
Mark distribution (all questions 6 marks)
Q1.Fundamentals
Q2. Distributed DB Design
Q3. Distributed Query
Q4. Distributed Transactions
Q5. Database Systems Integration
Q6. Data Warehousing
Q7. Spatial DB (Quadtrees)
Q8. Data Cleansing
Q9. Intensively Distributed Data
Q10. Data Models (XML)
Self assess your understanding against the Learning Objectives (Assessment Criteria)
1 Have consolidated understanding of main issues in centralised databases (Q1)
2 Understand how these principles must be adapted in a distributed database environment (Q2-Q4)
3 Understand the effect of multiple organisations on distributed information systems (Q5)
4 Understand key principles of data warehousing (Q6)
5 Understand key principles of spatial databases (Q5)
6 Understand key principles of data quality and cleansing (Q8)
7 Understand database aspects of intensively distributed data (Q9)
8
Understand key issues in data models in a historical context (Q10)
Final Exam Marks
| 33552954 | 54 |
| 33689524 | 0 |
| 40121134 | 45 |
| 40521378 | 19 |
| 40566016 | 0 |
| 40695895 | 52 |
| 40707891 | 32 |
| 40755285 | 36 |
| 40756901 | 32 |
| 40758174 | 54 |
| 40761679 | 54 |
| 40762724 | 46 |
| 40763477 | 45 |
| 40859240 | 0 |
| 40871260 | 43 |
| 40898502 | 45 |
| 40958563 | 49 |
| 40970220 | 36 |
| 40979661 | 37 |
| 40983266 | 33 |
| 40986173 | 38 |
| 41069925 | 38 |
| 41111646 | 39 |
| 41113341 | 34 |
| 41137244 | 45 |
| 41152416 | 45 |
| 41255830 | 34 |
| 41264113 | 0 |
| 41282809 | 17 |
| 41295199 | 42 |
| 41324138 | 55 |
| 41331949 | 42 |
| 41336935 | 41 |
| 41368392 | 48 |
| 41455836 | 61 |
| 41457438 | 49 |
| 41816183 | 34 |
Mid Semester Exam
Date: 21 April 2007
Time 12.00 - 2.00
Venue: Lecture Room 78-420
Marks: 20/100
Material:
| Module 0: | Introduction to the course | |
| Module 1: | Fundamentals of DBMS | 4 Marks |
| Module 2: | Distributed Database Design | 4 Marks |
| Module 3: | Distributed Query Processing | 4 Marks |
| Module 4: | Distributed Transactions | 4 Marks |
| Module 5: | Database Systems Integration | 4 Marks |
Format: Similar to problem solving sessions
Consultation: There are two one-hour consultation sessions at 1:00 pm of 16 & 17 April 2008 at room 78-525.
Quiz Results
| Student ID | Quiz |
| 33552954 | 18 |
| 33689524 | |
| 40121134 | 17 |
| 40521378 | 15.5 |
| 40566016 | 18 |
| 40695895 | 12 |
| 40707891 | 8.5 |
| 40755285 | 12.5 |
| 40756901 | 13 |
| 40758174 | |
| 40761679 | 17.5 |
| 40762724 | 19 |
| 40763477 | 12.5 |
| 40859240 | |
| 40871260 | 17.5 |
| 40898502 | 16.5 |
| 40958563 | 18 |
| 40970220 | 11 |
| 40979661 | 16.5 |
| 40983266 | 15 |
| 40986173 | 11.5 |
| 41069925 | 10 |
| 41111646 | 14 |
| 41113341 | 18 |
| 41137244 | 16.5 |
| 41152416 | 17.5 |
| 41255830 | 17.5 |
| 41264113 | |
| 41282809 | |
| 41295199 | 17 |
| 41324138 | 14.5 |
| 41331949 | 16 |
| 41336935 | 15.5 |
| 41368392 | 10 |
| 41455836 | 10 |
| 41457438 | 17 |
| 41816183 | 14.5 |
