. . Business rules: Each employee (identified by Employee_ID) may have many kids. • Usually a kid (identified by Kid_ID)

[answerhappygod]

Business Rules Each Employee Identified By Employee Id May Have Many Kids Usually A Kid Identified By Kid Id 1 (73.48 KiB) Viewed 38 times

. . Business rules: Each employee (identified by Employee_ID) may have many kids. • Usually a kid (identified by Kid_ID) is associated with one employee (father or mother). However, it is possible that a kid's parents are both employees. . For each employee, we want to know his/her employee ID and name. For each kid, we need to know his/her name and the employee(s) who is (are) his/her parents. EMPLOYEE PK Employee ID KIO EMPLOYEE KID PK Kid ID PK.FK1 Employee_10 > ----- First Name FK2 Kid ID Last Name FirstName LastName KID EMPLOYEE PK Kid ID PK Employee ID First Name Last Name FirstName LastName FK1 Kid_jo DA0C.png EMPLOYEE EMPLOYEE KID KID PK Employee_ID PKFK2 Kid ID PKFK1 Employee ID PK Kid ID + First Name Last Name FirstName LastName KID EMPLOYEE PK Employee ID PK Kid 10 ---- FirstName Last Name First Name Last Name FK1 Employee ID