433-351 Database Systems

Credit may not be gained for 433-351 Database Systems and 433-258 Database Systems for Engineers and/or 615-230 Database Concepts and/or 615-330 Advanced Concepts in Database.

433-253 Algorithms and Data Structures and 433-255 Logic and Computation

The objective of this subject is for students to understand the fundamentals of database systems, including data modelling and database design; to understand the languages and facilities provided by database systems; and to understand the implementation of database systems.

Topics covered include data models: relational, deductive, object-oriented, network, hierarchical, semantic; database design; relation normalisation; query languages including SQL; integrity; security; concurrency; query processing and optimisation; and implementation of data models and database languages.

Project work (expected to take about 36 hours) during semester and one written examination (not exceeding three hours) at the end of the semester. The project work must be completed satisfactorily to pass the subject. Weighting of assessment components will be advised at the commencement of the subject.