COT3180

Principles of database systems

(IT)

R Simpson

6 points + First, second,summer semester + Caulfield + Prerequisites: COT1720 or BUS1010 or equivalent + Prohibitions: BUS2112, CFR2132, CFR2201, COT2132, COT2138, COT2180, CSC3161, CSE3316

Synopsis: Data processing and databases. Project planning. Three schema architecture. Data as a resource. User requirements. Database logical design. Introduction to data modelling: the E-R diagram. Introduction to the relational model. Physical storage devices. Transaction processing. System maintenance. Addressability. Data structures. Sorting, physical clustering, dense and non-dense indexing. Database administration.Security, Recovery. SQL commands. Data warehousing, Distributed database.

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