COT4230

Database systems

(IT)

R Redpath

6 points + 2-hour lecture and 2-hour tutorial per week + First semester + Caulfield

Synopsis: Objectives of database technology, data sharing, data independence, data integrity and data security, three-schema architecture. The relational data model: structures, domains, relations and attributes. Integrity constraints: entity, referential and user-defined integrity. Operations: relational algebra, relational calculus, domain and tuple calculus. Relational database design: conceptual design, logical design, physical design. Major SQL and relational systems.

Assessment: Examination (2 hours): 50% + Practical work: 50%