Introduction to Database Systems

Unit code:VIT1201Study level:Undergraduate

Credit points

12
(Generally, 1 credit = 10 hours of classes and independent study.)

Location

Footscray Nicholson
VU Brisbane
VU Sydney

Prerequisites

(Or equivalent to be determined by unit coordinator)
Co-requisites
(Corequisite units must be studied concurrently with this unit)

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:

Describe the benefits and functions of databases and their applications;
Design a database using key relational database model concepts;
Develop and apply Entity Relationship and Extended Entity Relationship modelling diagrams;
Implement a relational database with multiple tables using a relational Database Management Systems;
Apply query languages and manage a database using Structured Query Language (SQL), and;
Normalise relations in a relational database system.

Assessment

For Melbourne campuses

Assessment type: Laboratory Work | Grade: 20%

A set of scaffolded practical exercises with reflection on what has been learned.

Assessment type: Test | Grade: 45%

Final written test.

Assessment type: Case Study | Grade: 35%

In class assignment with SCRUM based milestones.

Other locations

Assessment type: Test | Grade: 25%

Structured Query Language Test

Assessment type: Test | Grade: 40%

2 x Quizzes (10% + 30%)

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).