Skip to content | Change text size

M O N A T A R

InfoTech Unit Avatar

ITW1202 Database Management Systems

Chief Examiner

This field records the Chief Examiner for unit approval purposes. It does not publish, and can only be edited by Faculty Office staff

To update the published Chief Examiner, you will need to update the Faculty Information/Contact Person field below.

NB: This view restricted to entries modified on or after 19990401000000

Unit Code, Name, Abbreviation

ITW1202 Database Management Systems [DBMS ]

Reasons for Introduction

Obsolete Reasons for Introduction

This is a foundation unit that aims to provide the student with an understanding of the database management systems (DBMSs) that underlie business applications. A theoretical introduction as well as hands-on experience are required to take advantage of the sophistication of the modern DBMS.The approach of this unit will be to use the core features of the DBMS without taking advantage of CASE or application development tools. This will provide the student with a deeper appreciation of the internals of the DBMS, and confidence that optimisation of code generated by application development tools is both possible and desirable.The theoretical and practical aspects of Structured Query Language (SQL) in the context of the relational database model will dominate the unit content. Development of usable schemae and optimisation through the use of indexes and user-defined data types will be a second major theme.Finally, this unit will provide an introduction to administration of the DBMS in a multi-user environment, and the role of the Database Administrator (DBA) relative to the system administrator. Practical experience in this area will be advantageous to students in the job market.This unit will be one of the core units in the Bachelor of Information Technology.

Objectives

Unit Content

Teaching Methods

Assessment

Workloads

Resource Requirements

Software Requirements (21 Oct 2005, 1:04pm)

Prerequisites

Faculty Information

Proposer

Pang Hiew

Approvals

School:
Faculty Education Committee:
Faculty Board:
ADT:
Faculty Manager:
Dean's Advisory Council:
Other:

Version History

30 May 2002 Pang Hiew Update unit description.
17 Oct 2005 David Sole Added Software requrirements template
21 Oct 2005 David Sole Updated requirements template to new format

This version: