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.