COT4430

Database design and administration

6 points - 4 hours per week - Second semester - Caulfield - Prerequisites: COT4230

Objectives By completing this subject, students develop an understanding of physical database design and maintenance.

Synopsis Embedded SQL, performance monitoring and modelling, system tuning and optimisation for single-site and networked systems, CASE tools for physical design, schema generators, concurrency and locking, restart and recovery methods, system security.

Assessment Examination (2 hours): 50% - Practical work: 50%

Recommended texts

Chandy K M and Yeh R T (eds) Current trends in programming methodology vol. 3, Software modelling Prentice-Hall, 1978
Sauer C H and Chandy K M Computer systems performance modelling Prentice-Hall, 1981

Back to the 1999 Information Technology Handbooks