CSC2161

Database management systems

4 points
* Two 1-hour lectures per week
* Second semester
* Clayton
* Prerequisites CSC1030 or equivalent
* Prohibitions BUS2112, BUS3112, CSC3161, CFR2132, CFR2201, COT2132, COT2138, COT2180, COT2901, COT3180, 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 edition, Addison-Wesley, 1995