Database Management and Warehousing

Topics

Video

Resource File

ER-Model

Relational Model: Relational Algebra, Tuple Calculus, SQL, Integrity Constraints, File Organization, Indexing, Data Types, and Data Transformation, such as normalisation, discretisation, sampling, compression, etc.

Data Warehouse Modelling: Schema for Multidimensional Data Models, Concept Hierarchies, Measures: Categorisation and Computations