Question

6. Create a typical family relationship-spouse, father, and mother-in a single 3NF relation. Include Name and Date of Birth as non-key attributes. Assume that each family member has only one spouse, one father, and one mother. Show foreign keys with dashed undedine, and Primary keys with solid underline. (Come up with your own field names). (3 points)

Answer 1

1.CHILD

Child_ID _______	F_Name	L_Name	DOB	Birth_Cirtificate	Spouse_ID ---------------	Father_ID -------------	Mother_ID --------------
1	Rattan	Lal	24-02-1990	Taken	A	F1	M1
2	Sahil	Sharma	15-08-1982	Taken	B	F2	M2

2.SPOUSE

Spouse_ID _________	F_Name	L_Name	DOB
A	Neha	Devi	14-01-1996
B	Sonali	Sharma	03-08-1985

3.FATHER

Father_ID _________	F_Name	L_Name	DOB
F1	Hari	Lal	05-12-1965
F2	Sumit	Sharma	13-11-1955

4.MOTHER

Mother_ID _________	F_Name	L_Name	DOB
M1	Lalita	Devi	24-06-1971
M2	Neha	Sharma	19-09-1962