Database Analysis and Design

    Unit code: NIT5130 | Study level: Postgraduate
    Credit points
    12
    (Generally, 1 credit = 10 hours of classes and independent study.)
    Location
    City Campus
    Footscray Park
    Online Real Time
    VU Brisbane
    VU Sydney
    Prerequisites
    N/A
    Overview
    Enquire

    Overview

    This unit discusses the specialised skills for designing and using relational databases. It is a core unit in this advanced and applied IT course. The unit provides students with an in-depth knowledge of SQL relational data modelling, database design, and daily administration and deployment of the relational database.

    Learning Outcomes

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

    1. Abstract data requirements into data models using entity-relationship diagram and relational data model and design relational databases;
    2. Formulate efficient SQL queries to store, manipulate and transform data into useful information to users;
    3. Assess and rationalise database design with functional dependencies and normal forms;
    4. Propose and devise query optimisation, transaction and security management for relational database management systems; and
    5. Exhibit mastery of theoretical knowledge and practical skills relating to the Relational Data Model and Relational Database Management Systems.

    Assessment

    For Melbourne campuses

    Assessment type: Laboratory Work
    |
    Grade: 10%
    Laboratory submissions (10)
    Assessment type: Test
    |
    Grade: 50%
    Tests (2)
    Assessment type: Assignment
    |
    Grade: 40%
    Group Database Project

    Required reading

    Required readings will be made available on VU Collaborate.

    As part of a course

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

    Graduate Certificate in Information Technology Project Management
    NTIP | Graduate certificate | Duration: 0.5 years
    Master of Applied Information Technology
    NMIT | Masters (coursework) degree | Duration: 2 years
    Master of Engineering
    NMEN | Masters (coursework) degree | Duration: 2 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