COT2132

Database systems

(IT)

R Redpath

6 points + One 2-hour lecture and one 2-hour tutorial per week + First, second semester + Caulfield + Prerequisites: COT1140,CSE1201 or equivalent + Prohibitions: BUS2112, CFR2132, CFR2201, COT2138, COT2180, COT2901, COT3180, CSC3161, CSE3316

Synopsis: Introduction to the concepts necessary for planning, designing, using and implementing database systems. Database design. Structures and techniques underlying databases: file organisations, data structures, index structures. The database concept: data sharing, related data, data independence, data integrity, data dictionary. Relational databases: referential and entity integrity, SQL data definition, creating and amending tables and rows, data manipulation, distributed database, data warehousing and data mining.

Assessment: Examination (2 hours): 60% + Practical work: 40%