Introduction to Database Systems

Unit code: VIT1201 | Study level: Undergraduate
12
(Generally, 1 credit = 10 hours of classes and independent study.)
Footscray Nicholson
India Online
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 Entity Relationship and Extended Entity Relationship modelling diagrams;
  4. Implement a relational database with multiple tables using a relational Database Management Systems;
  5. Apply query languages and manage a database using Structured Query Language (SQL), and;
  6. Normalise relations in a relational database system.

Assessment

For Melbourne campuses

Assessment type: Laboratory Work
|
Grade: 10%
5 x SQL Lab Tasks
Assessment type: Test
|
Grade: 25%
SQL Test
Assessment type: Test
|
Grade: 30%
2 x Quizzes (1 hour each)
Assessment type: Case Study
|
Grade: 35%
Assignment

Other locations

For students studying at India Online
Assessment type: Test
|
Grade: 20%
Structured Query Language Test
Assessment type: Assignment
|
Grade: 30%
Conceptual modelling and the relational model
Assessment type: Assignment
|
Grade: 50%
SQL and normalisation
For students studying at Henan University
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
For students studying at VU Sydney
Assessment type: Laboratory Work
|
Grade: 10%
5 x SQL Lab Tasks
Assessment type: Test
|
Grade: 25%
SQL Test
Assessment type: Test
|
Grade: 30%
2 x 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