Prerequisites:COS110
This module will expose students to the evolution of databases systems. They will be able to model data conceptually, in terms of models such as conceptual, relational, object oriented, graph-based and network and the mapping between models, in particular between the conceptual and relational model. Foundational concepts relating to the relational model will be considered, such as: entity and referential integrity, relational algebra and calculus, functional dependency, normals forms, Indexing of database systems and transaction processing will also form an integral part of the curriculum. The physical data representation of the databases system both in memory and within the file system of the operating system will be considered.
