Introduction to Database Systems

Unit code: VIT1201 | Study level: Undergraduate
12
(Generally, 1 credit = 10 hours of classes and independent study.)
Footscray Nicholson
Online Real Time
VU Brisbane
VU Sydney
N/A
Overview
Enquire

Overview

This unit introduces fundamental concepts underpinning the analysis and design of information systems and explains the role and purpose of systems analysis. Students gain mastery of standard techniques to identify system requirements and design a simple database system. Content includes: systems concepts; role of the analyst; Systems Development Life Cycle (SDLC), process modelling, Entity-Relationship (ER) modelling; relational database design using ER and Extended ER modelling, relational algebra, SQL (Structured Query Language), normalisation; and database management systems (DBMS).

Learning Outcomes

On successful completion of this unit, students will be able to:

  1. Describe the benefits and functions of databases and their applications;
  2. Design a database using key relational database model concepts;
  3. Develop and apply ER and EER diagrams;
  4. Implement a relational database with multiple tables using a relational DBMS;
  5. Apply query languages and manage a database using SQL; and
  6. Normalise relations in a relational database system.

Assessment

For Melbourne campuses

Assessment type: Test
|
Grade: 25%
SQL Test
Assessment type: Test
|
Grade: 40%
Two quizzes (1 hour each)
Assessment type: Case Study
|
Grade: 35%
Assignment

Other locations

For students studying at VU Sydney
Assessment type: Test
|
Grade: 25%
SQL Test
Assessment type: Test
|
Grade: 40%
Two quizzes (1 hour each)
Assessment type: Case Study
|
Grade: 35%
Assignment

Required reading

There are no required textbooks for this unit. A comprehensive set of Unit Notes in electronic format will be available via the Learning Management System (VU Collaborate).

As part of a course

This unit is studied as part of the following course(s):

Search for units, majors & minors