[DM1-2] The Relational Model

The Relational Model is the most important database model, therefore it is explained in more detail here: - Basic concepts (tables, tuples, etc.) - Relation to relational algebra (RA), basics of RA - Constraints (key, domain, referential integrity) - Relation to entity relation (ER) model, basics of ER

External resources

• Genesereth. (2010). Data integration: The relational logic approach (Synthesis lectures on artificial intelligence and machine learning, # 8). San Rafael, Calif. (1537 Fourth Street, San Rafael, CA 94901 USA): Morgan & Claypool.
• Haslam, N. (2004). Relational models theory: A contemporary overview. Mahwah: Erlbaum.

Learning outcomes

• 2284 - Explain the key elements of the relational - database - model

  Explain the key elements of the relational - database - model

Self assessment

Outgoing relations

• [DM1-2] The Relational Model subclassof [DM1] Foundations for Data Modelling Storage and Exploitation