top of page

LIKE THE BLOG? DID MY COURSEWORK HELP YOU?

Feel free to donate to support me and be able to host this site as a free educational tool for everyone to use.

Any amount is appreciated and is not required!

Unit 18 (P1, M1, D1): Relational Databases

Explain the features of a relational database (P1)

Relationships

A relationship is a defined connection between the rows of two tables. This connection is general determined by values in selected columns from the parent table that correspond to values in the child table.


One-To-Many

A one-to-many relationship is when a parent record in one table can potentially reference several child records in another table. In a one-to-many relationship, the parent is not required to have child records; therefore, the one-to-many relationship allows zero child records, a single child record or multiple child records (the child record cannot have more than on parent record).