# 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)