2. Consider the two relations and their schemas as listed below: Employee(name, emplD, birthDate, gender, address,...

Transcribed Image Text:

2. Consider the two relations and their schemas as listed below: Employee(name, emplD, birthDate, gender, address, phone) TaxAccount(name, SSN, empID, federalDeductionAmt, stateDeductionAmt, ficaDeductionAmt) Constraint: The relation TaxAccount must contain information related to all current employees only. a) (10 points) Express the foreign key constraint in SQL. b) (7 points) What are the appropriate policies for update and delete operations? Why? 2. Consider the two relations and their schemas as listed below: Employee(name, emplD, birthDate, gender, address, phone) TaxAccount(name, SSN, empID, federalDeductionAmt, stateDeductionAmt, ficaDeductionAmt) Constraint: The relation TaxAccount must contain information related to all current employees only. a) (10 points) Express the foreign key constraint in SQL. b) (7 points) What are the appropriate policies for update and delete operations? Why?

Answer rating: 100% (QA)

a Expressing the foreign key constraint in SQL SQL statement SQL ALTER TABLE TaxAccount ADD CONSTRAINT FKTaxAccountEmployee FOREIGN KEY empID REFERENCES EmployeeempID ON DELETE CASCADE ON UPDATE CASCA... View the full answer