What Does One-to-Many Relationship Mean?
In relational databases, a one-to-many relationship occurs 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 important thing is that the child cannot have more than one parent record.
Techopedia Explains One-to-Many Relationship
Consider a database for recording sales information in a store. There are two tables in this database:
