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 objectives of this subject are 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.

• ability to apply knowledge of basic science and engineering fundamentals

• ability to communicate effectively, not only with engineers but also with the community at large

• in-depth technical competence in at least one engineering discipline

• ability to undertake problem identification, formulation and solution

A half-hour mid-semester test (10%); project work during semester, expected to take about 36 hours (30%); and one 3-hour end-of-semester written examination (60%). To pass the subject, students must obtain at least 50% overall, 15/30 in project work, and 30/60 in the written examination.