1. Handbook
  2. Subjects
  3. Database Systems

Database Systems (INFO20003)

Undergraduate level 2Points: 12.5On Campus (Parkville)

You’re viewing the 2017 Handbook. View archived Handbooks

Overview

Year of offer2017
Subject levelUndergraduate Level 2
Subject codeINFO20003
Campus
Parkville
Availability
Semester 2
FeesSubject EFTSL, Level, Discipline & Census Date

AIMS

Contemporary online services such as social networking and multimedia-sharing sites, massive multiplayer online games and commerce services are built on content management and database systems.In this subject, students will learn how to build their own database and will obtain a deep understanding of the concepts behind database management systems (DBMS). In particular, the students will get familiar with the database system architecture, and will exercise the concepts such as query processing and optimisation, database tuning and transactions, which are the foundation of any modern data processing applications. This subject is core within the Bachelor of Science for the Major of Computing and Software Systems and the Major of Informatics. Students completing the Diploma of Informatics are also required to undertake this subject.

INDICATIVE CONTENT

This subject serves as an introduction to data modelling and databases from a technical and data management perspective. Database design from conceptual design through to physical implementation will be covered. This will include Entity Relationship modelling, normalisation, de-normalisation, relational model and relational algebra, SQL, query processing and query optimisation, transactions, storage organisation, database administration, data warehousing and big data and business analytics. Other topics in data management and DBMS technology with an overview of modern NoSQL databases may also be included.

Intended learning outcomes

Intended Learning Outcomes (ILOs)

On completion of this subject the student is expected to:

  1. Demonstrate proficiency in solving practical data-modelling tasks
  2. Design content-management systems using relational database techniques
  3. Use SQL to interact with a relational database
  4. Develop a web-based database application
  5. Use database transactions

Generic skills

On completion of this subject students, should have developed the following generic skills:

  • The ability to analyse and solve problems involving large amounts of real-world data
  • The ability to synthesise information and communicate results effectively
  • The ability to work effectively as a member of a project team
  • The capacity for critical and independent thought and reflection
  • The ability to apply knowledge of basic science and engineering fundamentals
  • The ability to undertake problem identification, formulation and solution

Last updated: 31 August 2017