sit-20802-20database-20systems
File Details
-
UPLOADED BY Unknown
-
DATE 08 Dec 2025
-
SIZE 0.61 MB
-
DOWNLOADS 0
-
TAGS
notes
About This Document
Document Type: This is a Exam Paper, designed for Testing knowledge and exam technique.
Context: Standard material from the 2024 academic period.
Key Content: Likely covers essential definitions, scientific principles, and structured questions to test your proficiency.
Study Strategy: Attempt these questions under timed conditions to simulate a real exam environment, then check against your notes.
Recommendation: comprehensive resource for students aiming to achieve top grades in their final assessments.
Detailed Content Overview
Introduction
This notes resource titled "sit-20802-20database-20systems" provides comprehensive exam preparation materials designed to test and enhance your understanding. This resource is structured to facilitate effective learning and retention of important information.
Key Topics Covered
Learning Objectives
- Master key concepts required for examination success
- Practice answering exam-style questions effectively
- Develop time management skills for timed assessments
- Identify and address knowledge gaps in understanding
Detailed Summary
MURANG’A UNIVERSITY OF TECHNOLOGY SCHOOL OF COMPUTING AND INFORMATION TECHNOLOGY DEPARTMENT OF INFORMATION TECHNOLOGY UNIVERSITY POSTGRADUATE EXAMINATION 2024/2025 ACADEMIC YEAR FIRST YEAR FIRST SEMESTER EXAMINATION FOR MASTER OF SCIENCE IN INFORMATION TECHNOLOGY AND COMPUTER SCIENCE SIT802 - DATABASE SYSTEMS DURATION:3 HOURS INSTRUCTIONS TO CANDIDATES: 1. Mobile phones are not allowed in the examination room. You are not allowed to write on this examination question paper. Page 1 of 3 QUESTION ONE (25 MARKS) a) Write an SQL query to retrieve the names of all students who have an end of semester score that is greater than 70%. (5 marks) b) Describe the ACID properties of transactions in databases. (5 marks) c) Discuss the advantages and disadvantages of using object-oriented databases compared to relational databases. (6 marks) d) Evaluate the trade-offs between data consistency and availability in distributed database systems. (4 marks) e) Describe the role of OLAP cubes in data warehousing and how they are used for analysis (5 marks) QUESTION TWO (25 MARKS) Consider the following case study: Syracuse University is planning to implement a new database system to manage student records, course enrolments, and faculty information.
Study Tips & Recommendations
Time Management
Practice under timed conditions to improve speed and accuracy. Allocate specific time limits to each section.
Active Practice
Attempt all questions before checking answers. Review mistakes to understand where improvements are needed.
Mark Scheme Review
Study marking schemes carefully to understand how examiners award points and structure your answers accordingly.
Regular Review
Schedule periodic reviews to reinforce learning and combat forgetting. Use spaced repetition for optimal retention.
Content Preview
MURANG’A UNIVERSITY OF TECHNOLOGY SCHOOL OF COMPUTING AND INFORMATION TECHNOLOGY DEPARTMENT OF INFORMATION TECHNOLOGY UNIVERSITY POSTGRADUATE EXAMINATION 2024/2025 ACADEMIC YEAR FIRST YEAR FIRST SEMESTER EXAMINATION FOR MASTER OF SCIENCE IN INFORMATION TECHNOLOGY AND COMPUTER SCIENCE SIT802 - DATABASE SYSTEMS DURATION:3 HOURS INSTRUCTIONS TO CANDIDATES: 1. Answer any FOUR questions. 2. Mobile phones are not allowed in the examination room. 3. You are not allowed to write on this examination ques...
No comments yet. Be the first to start the conversation!