Introduction to Database Systems

    Unit code: VIT1201 | Study level: Undergraduate
    12
    (Generally, 1 credit = 10 hours of classes and independent study.)
    AVENU India
    Footscray Nicholson
    Online Real Time
    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 ER and 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.

    Assessment

    For Melbourne campuses

    Assessment type: Test
    |
    Grade: 25%
    SQL Test
    Assessment type: Test
    |
    Grade: 40%
    Two quizzes (1 hour each)
    Assessment type: Case Study
    |
    Grade: 35%
    Assignment

    Other locations

    For students studying at AVENU India
    Assessment type: Test
    |
    Grade: 20%
    SQL 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%
    SQL 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: Test
    |
    Grade: 25%
    SQL Test
    Assessment type: Test
    |
    Grade: 40%
    Two 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