1 Semester or equivalent

48 Hours

Hawthorn, Sarawak

Nil

Credit Points: 12.5 Credit Points

Related Course/s:

A unit of study in the Graduate Diploma of Information Technology, Master of Information Technology, Master of Information Technology (Professional Computing) and Master of Technology (Information Technology). A co-elective unit of study in the Master of Multimedia, Master of Multimedia Technology and Master of Multimedia (Honours).

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 and 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 (Labs) (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

Reading Materials:

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)