Course Title: Database Concepts

Part A: Course Overview

Course Title: Database Concepts

Credit Points: 12.00


Terms

Course Code

Campus

Career

School

Learning Mode

Teaching Period(s)

ISYS2390

City Campus

Undergraduate

155T Vocational Health and Sciences

Face-to-Face

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

ISYS2390

City Campus

Undergraduate

174T School of VE Engineering, Health & Science

Face-to-Face

Sem 1 2017,
Sem 2 2017

Course Coordinator: Dr Natalya Stepanova

Course Coordinator Phone: +61 3 9925 4931

Course Coordinator Email: natalya.stepanova@ems.rmit.edu.au

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 practice in computer labs. Each week, there will be a total of 2 hours lectures, 1 hour tutorial, and 2 hours of supervised laboratory work. The laboratory sessions will introduce you to the tools necessary to undertake the assignment 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, also known as Blackboard.
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 http://rmit.libguides.com/compsci


Overview of Assessment

☒ This course has no hurdle requirements.

Assessment tasks

Early Assessment Task: Online quizzes
Weighting towards final grade (%): 10% (2% + 4% + 4%)
This assessment task supports CLOs 1,2, and 3

Assessment Task 2: Practical Tests
Weighting towards final grade (%): 20%
This assessment task supports CLOs 3 and 4

Assessment Task 3: Assignments 
Weighting towards final grade (%): 30% 
This assessment supports CLOs 2,3,4,5 and 6

Assessment Task 4:
Final Exam
Weighting towards final grade (%): 40%
This assessment supports CLOs 1,2,3,4,5 and 6

Feedback is provided within two weeks after submission