unisa logo
books-library-folders

Area/Catalogue
INFS 2011

graduate-cap

Course Level
Undergraduate

globe-earth-geography

Offered Externally
Yes

diploma-certificate-graduate-degree

Course ID
012517

pie-chart-graph

Unit Value
4.5

compass

University-wide elective course
Yes

calendar-2
Timetable/s
First Semester
(Study Period 2)
Course owner

Course owner
School of Information Technology and Mathematical Sciences

Course aim

To introduce techniques used in web data management and databases, including XML, distributed databases, data warehouses, data mining and other special databases.

Course content

XML databases: XML model, DTD, XSchema and constraints, XPath and XQuery

Concurrency and transaction management

Data organization, hash, indexes, query optimization, active databases, and procedures

Distributed database design, fragmentation, and replication

Distributed transaction

Data warehouse architecture and components

Data warehouse modelling: star and snow flake schema

Analysis: multidimensional OLAP and relational OLAP

Warehouse design, data uploading, updating and integration

Introduction to special purpose databases, NO SQL databases

Textbook(s)

Connolly, Thomas M; Begg, Carolyn E 2015, Database Systems: A Practical Approach to Design, Implementation, and Management: Global Edition, 6th Edition, Pearson Education Limited ISBN:9781292061184 , United Kingdom

Prerequisite(s)

Common to all relevant programs
Subject Area & Catalogue Number Course Name
INFT 1020 Database Fundamentals

Corequisite(s)

Nil

Teaching method

Component Duration
INTERNAL, MAWSON LAKES
Lecture 2 hours x 13 weeks
Tutorial 1 hour x 13 weeks
Computer Practical 1 hour x 11 weeks
EXTERNAL, MAWSON LAKES, ONLINE
Online (Online materials and moderated discussion boards) N/A x 13 weeks

Note: These components may or may not be scheduled in every study period. Please refer to the timetable for further details.


Assessment

Task Length Weighting Duration
INTERNAL, MAWSON LAKES
Continuous assessment N/A 20% N/A
Assignment 1 2000 words 15% 15 hours
Assignment 2 2000 words 15% 15 hours
Examination N/A 50% 3 hours
EXTERNAL, MAWSON LAKES, ONLINE
Continuous assessment N/A 20% N/A
Assignment 1 2000 words 15% 15 hours
Assignment 2 2000 words 15% 15 hours
Examination N/A 50% 3 hours

Fees

EFTSL*: 0.125
Commonwealth Supported program (Band 2)
To determine the fee for this course as part of a Commonwealth Supported program, go to:
How to determine your Commonwealth Supported course fee. (Opens new window)

Fee-paying program for domestic and international students
International students and students undertaking this course as part of a postgraduate fee paying program must refer to the relevant program home page to determine the cost for undertaking this course.

Non-award enrolment
Non-award tuition fees are set by the Division offering the course. To determine the cost of this course, go to:
How to determine the relevant non award tuition fee. (Opens new window)

Not all courses are available on all of the above bases, and students must check to ensure that they are permitted to enrol in a particular course.

* Equivalent Full Time Study Load. Please note all EFTSL values are published and calculated at ten decimal places. Values are displayed to three decimal places for ease of interpretation

Course Coordinators

School of Information Technology and Mathematical

Degrees this course is offered in

Checking your eligibility