Share via

One-to-Many with Inheritance Relation

  • Article

A one-to-many with inheritance relation resembles the 1:M relation. However, it enables the child to see and populate all the data members of the parent.

Relation Example 5

Insert into the child of 1:M with inheritance relation in an empty database, as shown in the following command.

Insert Dog (DogName="Spot", DogBreed="Cocker Spaniel", DogOwnerName="Bob", DogOwnerAddress="Redmond")

See Also

Other Resources

What Are the Data Warehouse Logical Schema Relations?