Relational database
D Ceddia
8 Points * 5 hours per week * First semester * Peninsula * Prerequisites: CFR1202 or (CFR1120 and CFR1121) * Prohibitions: CFR2132, COT2132, COT2138, COT3180, CSC3161, GCO2815
Introduce the ANSI architecture for relational DBMS and data independence; use SQL to interface to a database system. Consider the relationships between relational algebra, relational calculus and SQL; formulate queries in relational algebra. Consider performance implications of SQL queries. Examine the underlying data structures of DBMS, and the criteria for selecting suitable storage structures to enhance database performance. Use of stored rules and procedures to enforce database integrity. Consider the implications of concurrency, locking and transaction boundaries. Develop programs using embedded SQL. Consider other examples of data models for database systems, including object-oriented. Examine distributed database developments such as DRDA and open SQL. Copy management and data replication.
Assessment
Examination (3 hours): 60% * Practical work: 40%
Prescribed texts
Elmasri R and Navathe S Fundamentals of database systems 2nd edn, Benjamin-Cummings, 1994
Recommended texts
Date C An introduction to database systems vol. 1, 5th edn, Addison-Wesley, 1990
McFadden F R and Hoffer J A Modern database management 4th edn, Benjamin-Cummings, 1994