Course Title: Database Systems

Part A: Course Overview

Course Title: Database Systems

Credit Points: 12.00


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

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

COSC2449

Taylors College KL

Undergraduate

140H Computer Science & Information Technology

Face-to-Face

Offsh 1 11

Course Coordinator: Associate Professor James Thom

Course Coordinator Phone: +61 3 9925 2992

Course Coordinator Email: james.thom@rmit.edu.au

Course Coordinator Location: Building: 14 Level: 9 Room: 16

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 online assessment tests assignments, and a formal written examination.

Assessment for postgraduates will require demonstrating deeper mastery of more complex concepts to solve more complex problems.

 

 This course has no hurdle requirements.

 

Assessment tasks

 

Early Assessment Task: Weekly online tests

Weighting 10%

This assessment task supports CLOs 1, 2 & 3

Assessment Task 2: Assignment 1 

Weighting 10%

This assessment task supports CLOs 1, 2 & 4

Assessment Task 3: Assignment 2

Weighting 30%

This assessment task supports CLOs 1, 2 & 4

Assessment 4: Exam

Weighting 50% 

This assessment supports CLOs 1, 2 & 3

 

Assignments will be submitted electronically

 

Assessment for postgraduates will require demonstrating deeper mastery of more complex concepts to solve more complex problems.