COT2132

Database systems

R Redpath

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

Objectives At the completion of this subject students should be able to understand the features of databases in a commercial environment; carry out retrieval and update on a relational database using SQL; implement integrity features on a database; tune a database for optimum performance; and understand possible future directions of database technology.

Synopsis This subject aims to provide students with a thorough grounding in the theory and practice of database systems. The syllabus includes the following topics. Database designs. Structures and techniques underlying databases: file organisations, data structures, index structures. The database concept: data sharing, related data, data independence, data integrity, data dictionary. Data models: hierarchical, network, relational. Relational databases: relational algebra, relational calculus, referential and entity integrity, SQL data definition, creating and amending tables and rows, data manipulation, client/server database and Web databases, data warehousing and data mining.

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

Recommended texts

Lorents A L and Morgan J N Database systems concepts, management and applications, Harcourt Brace, 1998
McFadden F R, Hoffer J A and Prescott M B Modern database management 5th edn, Benjamin-Cummings, 1998
Rob P and Coronel C Database systems design, implementation and management 3rd edn, Nelson, 1997

Back to the 1999 Information Technology Handbooks