One-to-Many with Inheritance Relation

  • Article

A one-to-many with inheritance relation is similar to the 1:M relation; however, it allows the child to see and populate all the members of the parent.

Relation Example 5

Insert into the child of 1:M with inheritance relation on a blank database.

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

Table Dog

DogID DogName DogBreed DogOwnerID
1000 Spot Cocker Spaniel 1000
   

Table DogOwner

DogOwnerID DogOwnerName DogOwnerAddress
1000 Bob Redmond
   


All rights reserved.