Course Title: Database Systems

Part A: Course Overview

Course Title: Database Systems

Credit Points: 12.00

Terms

Course Code

Campus

Career

School

Learning Mode

Teaching Period(s)

COSC2406

City Campus

Undergraduate

140H Computer Science & Information Technology

Face-to-Face

Sem 1 2007,
Sem 1 2008,
Sem 1 2009,
Sem 1 2010,
Sem 1 2011,
Sem 1 2012,
Sem 1 2013,
Sem 1 2014,
Sem 1 2015,
Sem 1 2016

COSC2406

City Campus

Undergraduate

171H School of Science

Face-to-Face

Sem 1 2017,
Sem 1 2018,
Sem 1 2019,
Sem 1 2020,
Sem 1 2021

COSC2407

City Campus

Postgraduate

140H Computer Science & Information Technology

Face-to-Face

Sem 1 2007,
Sem 1 2008,
Sem 1 2009,
Sem 1 2010,
Sem 1 2011,
Sem 1 2012,
Sem 1 2013,
Sem 1 2014,
Sem 1 2015,
Sem 1 2016

COSC2407

City Campus

Postgraduate

171H School of Science

Face-to-Face

Sem 1 2017,
Sem 1 2018,
Sem 1 2019,
Sem 1 2020,
Sem 1 2021

COSC2449

Taylors College KL

Undergraduate

140H Computer Science & Information Technology

Face-to-Face

Offsh 1 11

Course Coordinator: Dr Emily (Xiangmin) Zhou

Course Coordinator Phone: +61 3 9925 2118

Course Coordinator Email: xiangmin.zhou@rmit.edu.au

Course Coordinator Location: Building: 14 Level: 10 Room: 03

Course Coordinator Availability: By appointment.


Pre-requisite Courses and Assumed Knowledge and Capabilities

Undergraduate
ISYS1057 Database Concepts AND
COSC2123 or COSC2469 Algorithms and Analysis

Postgraduate
ISYS1055 Database Concepts
COSC1285 Algorithms and Analysis


Course Description

The course aims to deepen your knowledge of database systems. You will cover the design and implementation of file structures, indexing and analytical details that will enable you to understand efficiency in query evaluation. The concept of the transaction is introduced along with the necessity of concurrency control and serialisability. Issues of backup and recovery for databases are also introduced.


Objectives/Learning Outcomes/Capability Development

-

 


Course Learning Outcomes

Undergraduate:

Upon successful completion of this course you should have gained a thorough understanding of the file structures and advanced concepts in database systems. In particular, you should be able to:

  • CLO 1: Explain data structures and algorithms used to efficiently store and retrieve information in database systems
  • CLO 2: Evaluate and compare alternative designs for implementation of database systems, including data models, file structures, index schemes, and query evaluation
  • CLO 3: Analyse techniques for transaction processing, concurrency control, backup and recovery that maintain data integrity in database systems
  • CLO 4: Design and implement significant software components of a database system (such as file structures and index schemes) according to specified requirements and constraints

Postgraduate:

Upon successful of this course you should have gained a thorough understanding of the file structures and advanced concepts in database systems. In particular, you should be able to:

  • CLO 1: Explain and critique data structures and algorithms used to efficiently store and retrieve information in database systems
  • CLO 2: Evaluate, critically analyse and compare alternative designs for implementation of database systems, including data models, file structures, index schemes, and query evaluation
  • CLO 3: Analyse techniques for transaction processing, concurrency control, backup and recovery that maintain data integrity in database systems
  • CLO 4: Design, implement and report on significant software components of a database system (such as file structures and index schemes) according to analysis of requirements and specified constraints


Overview of Learning Activities

This course includes lectures, tutorials and laboratory classes. Lectures will cover the various concepts, techniques and algorithms used in database systems. Your understanding of the lecture material is complemented by online assessment tests and deepened through problem solving and critical analysis exercises during tutorial classes and the assignments. The laboratory classes will develop programming skills that you can apply when implementing components of a database system in the assignments.

Private study is expected, including working through learning materials both before and after classes, gaining practice at solving conceptual and technical problems, participating in online discussion forums, and undertaking assessment activities outside of class time.

Attendance:

While a minimum attendance standard is not compulsory, non-attendance may seriously jeopardise the chances of success in this course. Clearly, non-attendance at an assessment may result in failure of that assessment. Where visa conditions apply, attendance is compulsory.

Teacher Guided Hours: 48 per semester

Learner Directed Hours: 72 per semester


Overview of Learning Resources

You will make extensive use of computer laboratories and relevant software provided by the School. You will be able to access course information and learning materials through the myRMIT and may be provided with copies of additional materials in class or via email. Lists of relevant reference texts, resources in the library and freely accessible Internet sites will be provided.


Overview of Assessment

The assessment for this course comprises formative weekly online exercises, assignments, and a take-home 24 hour exercise.
Assessments for postgraduates will require demonstrating deeper mastery of more complex concepts to solve more complex problems.

This course has no hurdle requirements.

Assessment tasks

Assessment Task 1: Formative weekly online exercises -- Weighting 15%
This will involve 5-10 multiple-choice questions for each set of exercises, students will complete each exercise set in any 2 hours of a week from week 3 to week 10.

This assessment task supports CLOs 1, 2 & 3

Assessment Task 2: Assignment 1 -- Weighting 20%
Given an application scenario, the aim of the first assignment is to investigate and test the performance of different data storage methods. Students will compare and contrast the efficiency of storing real-world data using three different data storage and management approaches.

This assessment task supports CLOs 1, 2 & 4

Assessment Task 3: Assignment 2 -- Weighting 45%
This assignment will compare and contrast the effect of indexes on query performance. A range of different indexing approaches will be examined, including B+ trees, Derby and MongoDB.

This assessment task supports CLOs 1, 2 & 4


Assessment 4: Assignment 3 (take-home 24 hour exercise in Week 14) -- Weighting 20%
Questions will include practical scenarios and require the application of analytical and problem-solving skills developed throughout the course to real-world situations.

This assessment supports CLOs 1, 2 & 3