Course Title: Database Concepts

Part A: Course Overview

Course Title: Database Concepts

Credit Points: 12.00


Course Code




Learning Mode

Teaching Period(s)


City Campus


155T Vocational Health and Sciences


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


City Campus


174T School of VE Engineering, Health & Science


Sem 1 2017,
Sem 2 2017,
Sem 1 2018,
Sem 2 2018

Course Coordinator: Dr Natalya Stepanova

Course Coordinator Phone: +61 3 9925 4931

Course Coordinator Email:

Course Coordinator Location: RMIT Building 51, Level 6, Room 3

Pre-requisite Courses and Assumed Knowledge and Capabilities

There is an assumed knowledge of basic computer literacy.
Please be aware that this course forms part of AD006 (Associate Degree in Information Technology) and is not part of the BP162 (Bachelor of Information Technology) study plan. Also, it will follow the Vocational Education calendar dates and not the Higher Ed semester dates which means that classes will start 3 weeks earlier. The timetable is published under the Vocational Education timetable link and is not available on STS. If you enrol in this course as an elective please check with your program coordinator before commencement as this is not a bachelor course.

Course Description

Databases and database technology are having a major impact on the growing use of computers. This course is an introduction to principles, use and applications of database systems.
On completion of the course you will be able to understand the purposes for which databases are used, design and create databases, query/extract information from databases and understand in broad terms how database systems work.

Objectives/Learning Outcomes/Capability Development

This course contributes to the following Program Learning Outcomes for AD006 Associate Degree in Information Technology:
• Enabling Knowledge
• Problem solving

On successful completion of this course you will be able to:
1.Use the principles underlying database systems and explain the purposes for which they are used.
2.Describe the relational model and model data as relations.
3.Create description of a relational database using Entity Relationship Model.
4.Formulate queries in relational algebra and use SQL to manipulate data in relational database..
5.Define views and their purposes and formulate and interpret queries on views.
6.Create procedures to manipulate data in database

Overview of Learning Activities

The course will combine lectures and tutorials with hands-on practical exercises in computer labs. The laboratory sessions will introduce you to the tools necessary to undertake the assessment work.

Overview of Learning Resources

You will make use of computer laboratories and relevant software provided by the School. All materials will be provided online through myRMIT.
Lists of relevant textbooks, reference texts, resources in the Library and relevant internet sites will be provided.
The computer science subject guide is located at

Overview of Assessment

☒ This course has no hurdle requirements.

Assessment tasks

To pass this course you must achieve a total score of at least 50%. 

Assessment Task 1: Assignments
Note: This assessment task consists of two assignments. The Assignment 1 is an early assessment task.
Weighting towards final grade (%): 30% (5% + 25%)
This assessment task supports CLOs 1-6

Assessment Task 2: Practical Tests
Note: This assessment task consists of three practical tests.
Weighting towards final grade (%): 30% (10% + 10% + 10%)
This assessment task supports CLOs 4-6

Assessment Task 3: Final Written Exam
Weighting towards final grade (%): 40%
This assessment task supports CLOs 1-6

Feedback on your performance in the assessments will be given on a regular basis during the semester. Written comments will be posted on the Canvas Grade Center.