INFO6002

Database Management 2

10 Units

This course provides students with theoretical knowledge and practical skills in the use of databases and database management systems in information technology applications. The conceptual model, logical design, physical design and implementation of relational databases are covered. Contemporary issues and emerging technologies such as On-Line Analytical Processing (OLAP) and Data Warehouses are discussed.

Faculty Faculty of Engineering and Built Environment
School School of Electrical Engineering and Computing
Availability Semester 1 - 2018 (Callaghan)
Semester 1 - 2018 (Online)
Learning Outcomes

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

  1. Evaluate the role of database management systems in information technology applications within organisations;
  2. Recognise and use various conceptual models, logical design methods and tools for developing databases;
  3. Derive a physical design for a database from its logical design;
  4. Implement a database solution to an information technology problem using a commercial RDBMS.
  5. Program using the SQL data definition and SQL query languages.
  6. Recognise the value of and understand the problems associated with the use of procedural language extensions to SQL.
  7. Understand contemporary emerging technologies such as On-Line Analytical Processing (OLAP) and Data Warehouses.
Content
  1. The role of databases and database management systems.
  2. Database models.
  3. Conceptual modelling with EER
  4. Logical design of databases.
  5. Physical design of databases.
  6. SQL query language.
  7. Procedural language extensions to SQL.
  8. Contemporary issues and emerging technologies such as On-Line Analytical Processing (OLAP) and Data Warehouses.
Assumed Knowledge INFO6001
Assessment Items
  • Written Assignment: Assignment 1 - Requirements Gathering & Conceptual Database Design
  • In Term Test: Class Test - SQL
  • Written Assignment: Assignment 2 - Database Implementation
  • Written Assignment: Assignment 3 - Data Warehouse, OLAP & Business Intelligence
  • Formal Examination: Final Examination *

* This assessment has a compulsory requirement.

Contact Hours

Callaghan

Computer Lab

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

Lecture

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

Online

Computer Lab

Online 2 hour(s) per Week for Full Term
Computer Laboratory can incorporate a practical session or tutorial.

Lecture

Online 2 hour(s) per Week for Full Term

Compulsory Requirements
  • Course Assessment Requirements: 1. Formal Examination: Minimum Grade / Mark Requirement - Students must obtain a specified minimum grade / mark in this assessment item to pass the course. (Students whose overall mark in the course is 50% or more, but who score less than 40% in the compulsory item and thus fail to demonstrate the required proficiency, will be awarded a Criterion Fail grade which will show as FF on their formal transcript. However, students in this position who have scored at least 25% in the compulsory assessment item will be allowed to undertake a supplementary 'capped' assessment in which they can score at most 50% of the possible mark for that item.)
Timetable 2018 Course Timetables for INFO6002
Got a question?

Contact us for advice on how to apply, enrol, or for more information.

Ready to start?

Once you’ve read our Application guide you’re ready to apply