Oracle 12c: SQL
Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
Expert Solution & Answer
Book Icon
Chapter 1, Problem 4RQ

Explanation of Solution

One-to-Many relationship (1:N):

Entity instance of one entity associated to many other entity instances is referred as one-to-many relationship.

  • An entity instance is an occurrence of a particular entity.

Example:

The following example demonstrates a one-to-many relationship between manager entity and employee entity.

  • A manager manages many employees in an organization...

Blurred answer
Students have asked these similar questions
Define the concept of a one-to-many relationship.
What distinguishes a one-to-one relationship from a one-to-many relationship?
Give an example of one to one and one to many relationship?