INFO6002

Database Management 2

10 Units

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 Science and Information Technology
School School of Design, Communication and Information Technology
Availability Trimester 2 - 2015 (Callaghan Campus)
Trimester 2 - 2015 (WebLearn GradSchool)
Learning Outcomes

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

  1. Understand and 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
Contact Hours
  • Computer Lab: for 2 hour(s) per Week for Full Term (Computer Laboratory can incorporate a practical session or tutorial.)
  • Lecture: for 2 hour(s) per Week for Full Term
  • Self-Directed Learning: for 10 hour(s) per Week for Full Term (Self Directed Learning component is only applicable to Distance Learning students. The number of hours for week is a minimum recommendation and may vary with individual students's learning styles for on-line learning.)
Timetable 2015 Course Timetables for INFO6002

Sound like the course for you?

  Apply Now