CSE3316

Database management systems

6 points - Two 1-hour lectures per week - Second semester - Clayton - Prerequisites: CSC1030 or CSE1303 or equivalent - Prohibitions: BUS2112, BUS3112, CFR2132, CFR2201, CFR7112, COT2132, COT2138, COT2180, COT2901, COT3180, CSC2161, CSC3161, CSE2316, 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 (3 hours): 80% - Assignments: 20%

Recommended texts

Date C J An introduction to database systems 6th edn, Addison-Wesley, 1995
Elmasri R and Navathe S B Fundamentals of database systems Benjamin-Cummings, 2nd edn, 1994
Ullman J D and Widom J A first course in database systems Prentice-Hall, 1997

Back to the 1999 Science Handbook