---
# System prepended metadata

title: Relational Data Modeling

---

# Relational Data Modeling

## Agenda

(a) Intro to Relational Model
- Objectives of relational data modelling
- Foundations of the relational data model
	- Formal definition
	- Functional dependencies
	- Keys
- Elements of an RDBMS
    -   Codd‘s functions of a relational database
    -   Codd‘s criteria for the evaluation of  RDBMS (“12 rules”)

(b) Transformation of an E/R diagram into the relational model
- Mapping of Entity types, attributes and relationships

## References
1. [Codd‘s functions of a database](https://blog.triona.de/development/database/die-neun-regeln-von-codd-und-ein-einblick-in-das-formale-relationenmodell.html)
2. Edgar F. Codd: [„A Relational Model of Data for Large Shared Data Banks”](http://www.seas.upenn.edu/~zives/03f/cis550/codd.pdf), 1970.
3. Avi Silberschatz, Henry F. Korth, S. Sudarshan: [Database System Concepts – Sixth Edition -> Chapter 2. Introduction to the Relational Model](https://www.db-book.com/db6/slide-dir/index.html)
4. [Nine RDBMS properties (Codd) and an insight into the formal model of relations](https://blog.triona.de/development/database/die-neun-regeln-von-codd-und-ein-einblick-in-das-formale-relationenmodell.html)
5. [Codd's 12 rules for RDBMS](https://en.wikipedia.org/wiki/Codd%27s_12_rules) [1]
[Codd's 12 rules for RDBMS](https://www.studytonight.com/dbms/codd-rule.php) [2]
[Codd's 12 rules for RDBMS](https://computing.derby.ac.uk/c/codds-twelve-rules/) [3]
5. [What is a Foreign Key? (With SQL Examples)](https://www.cockroachlabs.com/blog/what-is-a-foreign-key/?utm_campaign=nl-email&utm_source=mkto&utm_medium=email&utm_term=december-monthly&utm_content=newsletter-2021-12)
6. [Foundations of Schema Design](https://university.cockroachlabs.com/courses/foundations-of-schema-design/?utm_campaign=nl-email&utm_source=mkto&utm_medium=email&utm_term=september-monthly-newsletter&utm_content=newsletter-2021-9%20&mkt_tok=MzUwLVFJTi04MjcAAAF_QUVud1RuVAWpla0jRg4xqKJ-0Iaq-BjqYUsXQMPlWtJOOrOAi6r5byZhfibqnEzCCFlj5Jp-NqY6zi9wMDIgGs8-X9PfVmDp1W_Iiy7j)
7. [The Third Manifesto](http://thethirdmanifesto.com/)
8. [Data Model Design & Best Practices](https://www.izeno.com/data-model-design-best-practices-part-1/)
9. [Database Schema Example Design: Step-by-Step Explanation](https://hevodata.com/learn/schema-example/)

## The person behind it
[Edgar F. Codd - Wikipedia](https://en.wikipedia.org/wiki/Edgar_F._Codd)

## Flashcards
[Relational Database Design - AnkiWeb](https://ankiweb.net/shared/info/1521623445)