433-351 Database Systems

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 3 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.