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 |
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 spou...
Name Use complete sentences if possible The following StudentGrade relation (table) stores the Student, Major, and Course information Each student has unique StudentID. Assume that a student has only one major. One student can take multiple courses in one SemesterYear. One course can be taken by many students in each SemesterYear. Given values for StudentID, Course Number, and SemesterYear, one can determine all the rest of values for a record. However only Grade is functionally dependent on StudentlD, CourseNumber and...