Lecturer: Dr G.M. Bierman
No. of lectures: 12
The overall aim of the course is to cover the fundamentals of database management systems, paying particular attention to relational database systems. The course covers modelling techniques, transferring designs to actual database implementations, SQL/92, models of query languages, transactions as well as more recent developments, including object-relational DBMSs, pure object DBMSs and XML. The lectures will make use of a relational DBMS.
At the end of the course students should
Elmasri, R. & Navathe, S.B. (2000). Fundamentals of database
systems. Addison Wesley (3rd ed.).
Silberschatz, A., Korth, H.F. & Sudarshan, S. (2002). Database system concepts. McGraw Hill (4th ed.).
Ullman, J. & Widom, J. (1997). A first course in database systems. Prentice Hall.
Date, C.J. (2000). An introduction to database systems. Addison Wesley (7th ed.).
Stonebraker, M. & Brown, P. (1999). Object-relational DBMSs. Morgan Kaufmann (2nd ed.).
Cattell, R., Barry, D. et al. (2000). The Object Database standard ODMG: 3.0. Morgan Kaufmann.
Abiteboul, S., Buneman, P. & Suciu, D. (2000). Data on the Web. Morgan Kaufmann.