INFO6002
10 units
6000 level
Course handbook
Description
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.
Availability2024 Course Timetables
Callaghan
- Trimester 2 - 2024
Singapore NAIHE
- Trimester 2 - 2024
Online
- Trimester 2 - 2024
Learning outcomes
On successful completion of the 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
- The role of databases and database management systems.
- Database models.
- Conceptual modelling with EER
- Logical design of databases.
- Physical design of databases.
- SQL query language.
- Procedural language extensions to SQL.
- 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 and Implementation
In Term Test: Class Test - SQL
Written Assignment: Assignment 2 - Data Warehouse, OLAP & Business Intelligence
Formal Examination: Final Examination
Compulsory Requirement: Pass requirement 40% - Must obtain 40% in this assessment item to pass the course.
Contact hours
Trimester 2 - 2024 - Callaghan
Computer Lab-1
- Face to Face On Campus 2 hour(s) per week(s) for 12 week(s) starting in week 1
Lecture-1
- Face to Face On Campus 2 hour(s) per week(s) for 12 week(s) starting in week 1
Trimester 2 - 2024 - Singapore NAIHE
Computer Lab-1
- Face to Face On Campus 2 hour(s) per week(s) for 12 week(s) starting in week 1
Lecture-1
- Face to Face On Campus 2 hour(s) per week(s) for 12 week(s) starting in week 1
Trimester 2 - 2024 - Online
Computer Lab-1
- Online 2 hour(s) per week(s) for 13 week(s) starting in week 1
- Computer Laboratory can incorporate a practical session or tutorial.
Lecture-1
- Online 2 hour(s) per week(s) for 12 week(s) starting in week 1
Course outline
Course outline not yet available.
The University of Newcastle acknowledges the traditional custodians of the lands within our footprint areas: Awabakal, Darkinjung, Biripai, Worimi, Wonnarua, and Eora Nations. We also pay respect to the wisdom of our Elders past and present.