Database Relationship Example for Lecture Test 3
Given the relationship of the Mother to Child is one to many, point out what is wrong with the data in the table. Hint: Referential integrity is not being enforced.
Mothers
MomID
Name
Age
023
Nancy
23
146
Sarah
27
124
Rachel
28
Children
KidID
Name
Age
MomID
C111
Sam
5
146
C222
Ann
15
124
C333
Leah
3
025
C444
Bob
7
023
C555
Lucy
2
125