Database management systems
4 points * Two 1-hour lectures per week * First semester * Clayton * Prerequisites: As for CSC3010 * Corequisites: As for CSC3030 * Prohibitions: BUS2112, CFR2132, CFR2201, COT2132, COT2138, COT2180, COT2901, COT3180, GCO2815
This subject provides a comprehensive knowledge of the problems of complex database management systems and database organisation. Both theoretical and pragmatic approaches will be presented to the problems of logical data description, organisation and manipulation. Topics include data models, normalisation, query languages, fourth-generation languages, integrity and security.
Assessment
Examination (2 hours): 80% * Practical work: 20%
Recommended texts
Date C J An introduction to databases 5th edn, Addison-Wesley, 1990
Elmasri R and Navathe S B Fundamentals of database systems Benjamin-Cummings, 1989