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
    Online Real Time
    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

    This unit introduces fundamental concepts and principles of database and explains its role and purpose in information system design and 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, 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 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. Normalise relations in a relational database system.

    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: Presentation
    |
    Grade: 10%
    Presentation - group of three (3) (15 minutes)
    Assessment type: Assignment
    |
    Grade: 30%
    Assignment - group of three (3)
    Assessment type: Test
    |
    Grade: 20%
    Closed Book concept evaluation (1 hour)
    Assessment type: Test
    |
    Grade: 20%
    Closed book problem solving test (1 hour)
    Assessment type: Laboratory Work
    |
    Grade: 20%
    Practical Lab Test (2 hours)

    Required reading

    Database Systems: Design, Implementation & Management
    Coronel, C. & Morris, S. (2019)| Boston, MA: Cengage Learning. ISBN 978-1-337-62790-0

    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