Introduction to Database Systems

Unit code: NIT1201 | Study level: Undergraduate
Credit points
12
(Generally, 1 credit = 10 hours of classes and independent study.)
Location
Footscray Park
VU Brisbane
VU Sydney
Prerequisites
BCO1102 - Information Systems for Business
BCO1102 only applies to students for BMAISM and BMIISM.
(Or equivalent to be determined by unit coordinator)
Overview
Enquire

Overview

In this unit, you will learn the fundamental concepts of database systems, including relational database models, ER/EER diagrams, and SQL. You will develop the skills to design databases, normalise relations, and implement SQL queries. Through practical lab sessions and assessments, you will apply these concepts to real-world scenarios, including WordPress SQL queries. This unit lays the foundation for future work with databases and data management systems, preparing you for challenges in database administration and data-driven decision-making. By the end of the unit, you will be equipped to design, query, and manage databases using industry-standard tools and techniques.

Learning Outcomes

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

  1. Demonstrate an understanding of the functions and real-world applications of databases;
  2. Design a database using key relational database model concepts;
  3. Develop and apply entity relationships (ER) and extended entity relationships (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. Apply database normalisation techniques to optimise relational database structure individually and as part of a team.

Study as a single unit

This unit can be studied on its own, without enrolling in a full degree.

Learn more about single units of study at VU

Assessment

For Melbourne campuses

Assessment type: Laboratory Work
|
Grade: 20%
In-class practical lab test with verified live interaction.
Assessment type: Test
|
Grade: 40%
In-class written test (problem solving and theory) with further Q&A verification.
Assessment type: Project
|
Grade: 40%
Concept evaluation and real-world problem-solving project and demonstration (Group)

Laboratory Work: Conducted under supervision, students complete real-time data analysis, coding, or modelling tasks. Execution is observed, and outcomes are verified through live checks or oral Q&A to ensure individual performance.

Test: Conducted under supervision, students complete real-time data analysis, coding, or modelling tasks. Execution is observed, and outcomes are verified through live checks or oral Q&A to ensure individual performance.

Required reading

Selected readings are available on VU Collaborate.

As part of a course

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

Bachelor of Cyber Security
NBCS | Bachelor degree | Duration: 3 years
Bachelor of Data Science
NBDS | Bachelor degree | Duration: 3 years
Bachelor of Information Technology
NBIT | Bachelor degree | Duration: 3 years
Bachelor of Information Technology (Professional)
NBIP | Bachelor degree | Duration: 3.5 years

Refer to the course page for information on how to apply for the course. VU takes care to ensure the accuracy of this unit information, but reserves the right to change or withdraw courses offered at any time. Please check that unit information is current with the Student Contact Centre.

Search for units, majors & minors