Answer:
CREATE TABLE TaxAccount (
Name int NOT NULL,
SSN int NOT NULL,
empID int FOREIGN KEY REFERENCES employee(empID),
federalDeductionAmt int NOT NULL,
stateDeductionAmt int NOT NULL,
ficaDeductionAmt int NOT NULL
);
Explanation:
TaxAccount table will use the primary key of employees table 'empID' which will serve as foreign key in TaxAccount table.
Therefore TaxAccount table will look like this:
CREATE TABLE TaxAccount (
Name int NOT NULL,
SSN int NOT NULL,
empID int FOREIGN KEY REFERENCES employee(empID),
federalDeductionAmt int NOT NULL,
stateDeductionAmt int NOT NULL,
ficaDeductionAmt int NOT NULL
);
