Database Systems

Description

AIMS Contemporary online services such as social networking and multimedia-sharing sites, massive multiplayer online games and commerce services have database management systems at their back-end. In this subject, students will obtain a deep understanding of the concepts behind database management systems. In particular, the students will become familiar with the database system architecture, and will exercise the concepts such as query processing and optimisation, database tuning and transactions, which are the foundation of any modern data processing application. This subject is core within the Bachelor of Science for the Major of Computing and Software Systems and the Major of Informatics. Students completing the Diploma of Informatics are also required to undertake this subject. INDICATIVE CONTENT This subject serves as an introduction to data modelling and databases from a technical and data management perspective. The subject will include Entity Relationship modelling (from conceptual design to physical modelling), normalisation, de-normalisation, relational model and relational algebra, SQL, query processing and query optimisation, transactions, storage organisation, database administration, data warehousing and big data analytics. Other topics in data management and DBMS technology with an overview of modern NoSQL systems may also be included. Teaching Period: 2 March 2026 to 31 May 2026 Assessment Information: Description Timing Percentage Three small, practical, database-related assignments worth 10% each (total 30%), completed individually. Intended Learning Outcomes (ILO's) 1, 2 and 3 are addressed in the assignments. 30-35 hours (of work required) Hurdle requirement: To pass the subject, students must obtain at least 50% (15/30) in the assignments. Throughout the teaching period 30% One written, 3 hour open-book examination, completed individually. ILO's 1 to 5 are addressed in the final examination. 3 hours During the examination period 60% Ten short timed weekly quizzes worth 1% each (total 10%), completed individually. 10 Hurdle requirement: To pass the subject, students must obtain at least 50% (35/70) cumulatively from the end of semester written examination and weekly quizzes. Throughout the teaching period 10%