3.2.4

Entity Relationship Modelling

Test yourself

Entity Relationship Modelling

When you are working with a relational database and forming relationships, you are linking entities together. This is known as entity relationship modelling.

Illustrative background for Entity relationship modellingIllustrative background for Entity relationship modelling ?? "content

Entity relationship modelling

  • There are 3 main types of relationships that exist:
    • One to one.
    • One to many.
    • Many to many.
  • We can show these relationships in entity relationship diagrams.
Illustrative background for One to oneIllustrative background for One to one ?? "content

One to one

  • A one to one relationship is when one entity is linked to one other entity.
Illustrative background for One to manyIllustrative background for One to many ?? "content

One to many

  • A one to many relationship is when one entity is linked to several entitities.
Illustrative background for Many to manyIllustrative background for Many to many ?? "content

Many to many

  • A many to many relationship is when several entities are linked to several other entitities.

Jump to other topics

1Components of a Computer

2Software & Software Development

3Exchanging Data

4Data Types, Data Structures & Algorithms

5Legal, Moral, Cultural & Ethical Issues

6Elements of Computational Thinking

6.1Thinking Abstractly

6.2Thinking Ahead

6.3Thinking Procedurally

6.4Thinking Logically

6.5Thinking Concurrently

7Problem Solving & Programming

8Algorithms

Unlock your full potential with Seneca Premium

  • Unlimited access to 10,000+ open-ended exam questions

  • Mini-mock exams based on your study history

  • Unlock 800+ premium courses & e-books

Get started with Seneca Premium