A company database needs to store information about employees (identified by ssn, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name and age as attributes). Employees work in departments; each department is managed by an employee; a child must be identified uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We are not interested in information about a child once the parent leaves the company. name the columns that would make up the children table. what is the relationship between employee and child
A. Many to one
B. many to many
C. one to many
D. unary
The columns that would make up the children table would be:
1. Child Name (unique identifier)
2. Age
3. Parent SSN (foreign key referencing the Employee table)
The relationship between Employee and Child is one-to-many (C), as an employee can have multiple children, but a child can only have one parent.
The columns that would make up the children table are:
1. Parent SSN: This column would identify the parent employee, linking the child to their parent.
2. Child Name: This column would store the unique name of the child.
3. Child Age: This column would store the age of the child.
The relationship between employee and child is C. One to many, as one employee can have multiple children, but each child can have only one parent.