Relational database
R Redpath
6 points * 4 hours per week * First/Second semester * Caulfield * Prerequisites: COT1140 * Prohibitions: BUS2112, CFR2132, CFR2201, COT2138, COT2180, COT2901, COT3180, CSC3161
Structures and techniques underlying databases: file organisations, data structures, index structures. The database concept: data sharing, related data, data independence, data integrity, data dictionary. Data models: hierarchical, network, relational. Relational databases: relational algebra, relational calculus, referential and entity integrity, SQL data definition, creating and amending tables and rows, data manipulation.
Assessment
Examination (2 hours): 60% * Practical work: 40%
Prescribed texts
McFadden F R and Hoffer J A Modern database management 4th edn, Benjamin-Cummings, 1994