Database Systems

Unit Code:HIT2422

Credit Points	Duration	Contact Hours	Campus	Prerequisite	Corequisite
12.5 Credit Points	1 Semester or equivalent	48 Hours	Hawthorn, Sarawak	HIT1402 Database Analysis and Design (or HIT2016 Database 1) and (an introductory programming unit such as HIT1051 Software Development 1or HIT1109 Introduction to Programming in VB or HIT1301 Algorithmic Problem Solving or HIT1404 Introduction to Programming in .NETor HIT2080 Introduction to Programming). Preclusions: HIT3017 Database 2 HIT2420 Database Management Systems	Nil

Credit Points

Duration

Contact Hours

Campus

Prerequisite

Corequisite

12.5 Credit Points

1 Semester or equivalent

48 Hours

Hawthorn, Sarawak

HIT1402 Database Analysis and Design (or HIT2016 Database 1) and (an introductory programming unit such as HIT1051 Software Development 1or HIT1109 Introduction to Programming in VB or HIT1301 Algorithmic Problem Solving or HIT1404 Introduction to Programming in .NETor HIT2080 Introduction to Programming).

Preclusions: HIT3017 Database 2

HIT2420 Database Management Systems

Nil

Related Course/s:

A unit of study in the Bachelor of Business Information Systems, Bachelor of Business Information Systems/ Bachelor of Commerce, Bachelor of Science (Professional Software Development), Bachelor of Information Technology, Bachelor of Applied Information and Communication Technology and Bachelor of Information and Communication Technology.

Aims & Objectives:

Students who complete this unit of study should be able to:

describe the architecture and capabilities of a modern Relational Database Management System (DBMS) and compare and contrast with other database models.
evaluate the effects of data restructuring and take action to maintain data independence.
explain and describe how a DBMS facilitates transaction management, concurrency and recovery.
implement a concurrent, multi-user business application using form based software.
understand the structure of distributed databases & issues associated with the physical distribution..
use the concepts underlying data warehouse, data mining and OLAP systems build a simple data warehouse system applying appropriate design principles.
describe the principles involved in ensuring data security and privacy in a database system.

Teaching Methods:

Lecture (24 hrs), Tutorial (lab) (24 hrs)

Assessment:

Assignments, Test, Examination

Content:

Database Objects and the Data Dictionary
Data Independence through Views
Transactions and Concurrency
Database Recovery Control
Client server systems
Distributed database systems
Database models
Data Warehousing, Data Mining
Data security and privacy
PL/SQL
Cursors
Stored Procedures/ functions
Triggers
XML

References:

Kroenke, DM, Database Processing: Fundamentals Design and Implementation, 10th edn, Intl. ed., Upper Saddle River, N.J., Prentice-Hall, 2006.

Connolly, T, Begg, C. and Strachan, A., Database Systems, 5th Ed, Addison Wesley, 2008

Mannino, M., Database Application Development & Design, 2nd Ed, McGraw-Hill, 2004.

Casteel, J., Oracle 10g SQL

Michael Kifer, Arthur Bernstein, Philip M. Lewis. Database Systems :An Application-oriented Approach, Complete version, 2nd ed. Pearson/Addison-Wesley, 2006.

Thomas Kyte, Expert Oracle (e-book in library)