Question: SQL language The Company database from the textbook has an Employee table with attributes SSN, Fname, Minit, Lname, etc., plus a Dependent table with the
SQL language

The Company database from the textbook has an Employee table with attributes SSN, Fname, Minit, Lname, etc., plus a Dependent table with the SSN of the employee who is the guardian of the dependent, the first name of the dependent and the relationship of the dependent to the employee (like son or mother). It is possible for a dependent to also be an employee. If we wanted to add this possibility to the model, how would we do it? Add a new table DependentEmployees with fields that reference Dependent and Employee Add a new table DependentEmployees with a field that references Dependent Add a field IsADependent to the Employee table Add a field DepSSN to the Dependent table that is a foreign key to the Employee table Clear my selection
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
