Course Title: Database Applications

Part A: Course Overview

Course Title: Database Applications

Credit Points: 12.00

Terms

Course Code

Campus

Career

School

Learning Mode

Teaching Period(s)

ISYS1101

City Campus

Postgraduate

140H Computer Science & Information Technology

Face-to-Face

Sem 2 2006,
Sem 2 2010,
Sem 2 2011,
Sem 2 2012

ISYS1102

City Campus

Undergraduate

140H Computer Science & Information Technology

Face-to-Face

Sem 2 2006,
Sem 2 2010,
Sem 2 2011,
Sem 2 2012

ISYS2034

Bundoora Campus

Undergraduate

140H Computer Science & Information Technology

Face-to-Face

Sem 1 2006

ISYS2105

Bundoora Campus

Postgraduate

140H Computer Science & Information Technology

Face-to-Face

Sem 1 2006

Course Coordinator: Dr. Santha Sumanasekara

Course Coordinator Phone: +61 3 9925 9673

Course Coordinator Email: santha.sumanasekara@rmit.edu.au

Course Coordinator Location: 14.9.9

Course Coordinator Availability: By appointment, by email


Pre-requisite Courses and Assumed Knowledge and Capabilities

Fundamental knowledge in relational database concepts, including relational modelling & design,  SQL, conceptual modelling, and database normalisation, equivalent to ISYS1055/1057 Database Concepts.

AND


Intermediate programming skills, equivalent to COSC1073 Programming 1 OR COSC1284 Programming Techniques OR COSC2531 Programming Fundamentals.


Course Description

Databases and the database technology are having a major impact on the growing use of computers. They play a critical role in almost all areas where computers are used.

This course introduces you to advanced database design and implementation concepts, database design techniques, and efficient data management. It will extend the database concepts and design skills developed in database concepts course and introduces you to database indexing, database security, query optimisation, concurrency control and transaction management, stored procedures and triggers, database backup strategies, and non-relational databases.


Objectives/Learning Outcomes/Capability Development

This course contributes to the development of the following capabilities: 

  • Enabling Knowledge: You will gain skills as you apply knowledge with creativity and initiative to new situations. In doing so, you will: Demonstrate mastery of a body of knowledge that includes recent developments in computer science and information technology; Recognise and use research principles and methods applicable to computer science and information technology.
  • Critical Analysis: You will learn to accurately and objectively examine and consider computer science and information technology (IT) topics, evidence, or situations, in particular to: (i) Analyse and model requirements and constraints for the purpose of designing and implementing software artefacts and IT systems; (ii) Evaluate and compare designs of software artefacts and IT systems on the basis of organisational and user requirements.
  • Problem Solving: Your capability to analyse problems and synthesise suitable solutions will be extended as you learn to: Design and implement software solutions that accommodate specified requirements and constraints, based on analysis or modelling or requirements specification. 


Upon successful completion of this course you should be able to:

  • CLO 1: apply advanced data analysis and modeling concepts, physical design, integrity, security and transaction management.
  • CLO 2: create triggers, stored procedures and functions to enhance the usability of a database;
  • CLO 3: apply techniques for efficient storing, accessing, securing, and recovering of data;
  • CLO 4: build an efficient database application with an emphasis on storage management, indexing and query optimisation;
  • CLO 5: use MongoDB for store and retrieve non-relational data;
  • CLO 6: develop a simple web-based interface for a database.


Overview of Learning Activities

The learning activities included in this course are:

  • Lectures: In general, lectures will be based upon the prescribed text and lecture notes. Where other material is used, explicit references will be given, with preference going to material that is widely available (e.g. freely available on the internet or in the library). Because this course has an emphasis on database application development in practice, students will be exposed to demonstrations of database application development using a laptop computer, a projector and mobile devices where possible.
  • TuteLabs: In general tutelab exercises are practical in nature and mostly relate to the assignment work so that students incrementally gain the skills required to develop a database application rather than having to apply a broad range of knowledge and combine a number of different skills and capabilities in a single large effort.
  • Canvas: All learning materials will be available on Canvas including lecture notes, tute/lab exercises, example source code and recorded lectures. Students will also participate in discussion with staff and other students via the online discussion board.

 

Total study hours:

A total of 120 hours of study is expected during this course, comprising:

Teacher-directed hours (48 hours): lectures and tutorials/laboratory sessions. Each week there will be 2 hours of lecture plus 2 hours of combined tutorial and practical (tutelab) work in the computer laboratory. You are encouraged to participate during lectures through asking questions, commenting on the lecture material based on your own experiences and by formulating solutions to small informal exercises. The tutorial/laboratory sessions will introduce you to the tools necessary to undertake the assignment work.

Student-directed hours (72 hours): You are expected to be self-directed, studying independently outside class


Overview of Learning Resources

Students will make extensive use of computer laboratories and relevant software provided by the School. 

Lists of relevant textbooks, reference texts, resources in the Library and relevant internet sites will be provided, on Canvas. 

This course requires the student to have their own laptop.


Overview of Assessment

The assessment for this course comprises of two assignments, mid-semester test and a formal end-of-semester written examination.

This course has no hurdle requirements.

 

Assessment tasks

Assessment Task 1: Assignments

Weighting 40%

This assessment task supports CLOs 1, 2, 3, 4, 5 & 6

 

Assessment Task 2: Mid-semester Test

Weighting 10%

This assessment task supports CLO 1, 2, 3 & 4

  

Assessment Task 3: End-of-semester Examination

Weighting 50% 

This assessment supports CLOs 1, 2, 3, 4 & 5

 

Please note that postgraduate students are expected to demonstrate deeper knowledge and a higher-level application of knowledge and skills than undergraduate students. There may be a postgraduate and an undergraduate version for both the mid-semester test and the end-of-semester examination.