4.10.1 & 4.10.2 Entity relationship modelling and relational databases

4.10.1 & 4.10.2 Entity relationship modelling and relational databases

1. Concept of a relational database

   • Composite primary key
   • Foreign key

2. Entity descriptions

   • Attribute
   • Entity Identfier
     • Primary Key
   • Entity

3. Entity Relationship diagrams to represent a data model

   • Relationship between entities
     • Many-to-many
     • One-to-many
     • One-to-one