Database Management Systems

Description

Provides students with theoretical knowledge and practical skills in the use of databases and database management systems in information technology applications. The logical design, physical design and implementation of relational databases are covered.

Availability

UoN Singapore

  • Trimester 1 - 2015 (Singapore)
  • Trimester 3 - 2015 (Singapore)

Callaghan Campus

  • Semester 1 - 2015

Ourimbah

  • Semester 1 - 2015

Learning Outcomes

1. Understand and evaluate the role of database management systems in information technology applications within organisations;

2. Recognise and use contemporary logical design methods and tools for databases;

3. Derive a physical design for a database from its logical design;

4. Implement a database solution to an information technology problem;

5. Understand the SQL data definition and SQL query languages;

6. Have been introduced to the alternative design techniques utilised for Management Reporting applications.

7. Develop sophisticated queries to extract information from large datasets.

Content

Topics will generally include:

  1. The role of databases and database management systems.
  2. Algebra and the relational database.
  3. Logical design of databases.
  4. Physical design of databases.
  5. SQL
  6. Data Warehouses

Assumed Knowledge

SENG1110 or INFT1004 or INFT1001 or equivalent.

Assessment Items

Project: Assignment 1 Database Project - Descriptionand EER model

In Term Test: Practical Test - Lab test on SQL

Formal Examination: Final Examination

Project: Assignment 2, Database Project - Logical and Physical Database Design

Contact Hours

Computer Lab

Face to Face On Campus 2 hour(s) per Week for Full Term

Computer Laboratory can incorporate a practical session or tutorial.

Lecture

Face to Face On Campus 2 hour(s) per Week for Full Term