CSC3161

Database management systems

4 points
* Two 1-hour lectures per week
* Second semester
* Clayton
* Prerequisites: CSC1030 or equivalent
* Prohibitions: BUS2112, BUS3112, CFR2132, CFR2201, CFR7112, COT2132, COT2138, COT2180, COT2901, COT3180, CSC2161, GCO2815

Objectives On completion of the subject, students should be able to make queries using SQL; design and implement a relational database; and write application programs for a database in the INGRES environment.

Synopsis This subject provides a detailed introduction to the principles of database systems and their organisation and management. The problems of logical data description, organisation and manipulation are addressed. Various data models, query languages, and issues of integrity and security are introduced.

Assessment: Examination (2 hours): 80%
* Assignments: 20%

Recommended texts

Date C J An introduction to database systems 6th edn, Addison-Wesley, 1995