Skip to Content

Future Students - Courses

click here for a printable version of this page  

Database Systems

Unit Code: HIT2422




Duration

Contact Hours

Campus

Prerequisite

Corequisite

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

Nil

Credit Points: 12.5 Credit Points

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.

Back to Top

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.

Back to Top

Teaching Methods:

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

Back to Top

Assessment:

Assignments, Test, Examination

Back to Top

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

Back to Top

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)

Back to Top