Relational Database Relationships (Updated)

Need more help with your HSC study? Check out my new digital study guides here:
https://www.maximumeducation.com.au

In understanding Relational Database Relationships, we will use a Movie Rental Database schema that contains all three types of relationships:

One to One Relationship
A single record in one entity is only referencing a single record in another entity, and that same record within the other entity is only referencing that same single record.

One to Many / Many to One Relationship
A single record in one entity may reference multiple records in another entity, though within the other entity the records may only reference a single record of the initial entity.

Many to Many Relationship
Records in both entities may reference multiple records in each other’s entities. Though an intermediate entity is required known as a junction to compile the multiple records.

Видео Relational Database Relationships (Updated) канала Christopher Kalodikis