Question: 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:

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

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?

Step by Step Solution

★★★★★

3.46 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

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 full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

The case spotlights Costco's mission, business model, and strategy, but it also contains good coverage of the company's warehouse operations, compensation practices, business philosophy, core values,...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Course Name: Introduction to Database Section A: Multiple Choice Questions [ 10 questions x I mark - 10 marks] Choose the correct answer for all of the following questions. You must mark your final...

Discrete Problem 4 (25 points) 1. (12 points) Consider the relations below. For each one explain whether the relation is reflexive, symmetric and transitive a) (3 pts) Let A be the set of all strings...

Question 2. Normalisation (10 marks) Consider the two relations below. They are in BCNF with primary key attributes underlined Customer(custlD, firstname, lastname) Item(itemNo, desc, price) A...

EXERCISE 10-I Identifying Relevant Costs [LOI] A number of costs are listed below that may be relevant in decisions faced by the management of Poulsen \& Sonner A/S, a Danish furniture manufacturer:...

1. Specify the following queries on the COMPANY relational database schema shown in Figure 5.5, using the relational operators Also show the result of each query as it would apply to the database...

( 2 Marks) Question One Consider the bank database. [0.5+0.5+1=2 Marks] branch(branch name, branch city, assets) customer (customer name, customer street, customer city) loan (loan number, branch...

The Board of Directors of Chandra Ltd. proposes to issue the prospectus inviting offers from the public to subscribe to the shares of the Company. State the reports which shall be included in the...

Consider a $160,000, 20-year ARM with monthly payments and annual interest adjustments. The initial interest rate is 6.5%. The index for the loan is 1-year US Government bonds, currently yielding...

Explain how a project may play a key role in supporting strategic goals

The following selected transactions relate to investment activities of Ornamental Insulation Corporation during 2021. The company buys debt securities, intending to profit from short-term differences...

As discussed in the chapter, abnormal earnings (AE) are AE t = X t (r e BV t1 ) where X t is the firms net income, r e is the cost of equity capital, and BV t-1 is the book value of equity at t 1....

Imagine you are the manager of a work team in an organisation. Your team is responsible for packaging and dispatching goods to consumers, based on an online ordering process. Suggest three key...

Your company assembles computers and in the process of assembling, key components are acquired from various manufacturers. You have been tasked to assemble a modern computer. Discuss the process you...

Calculate the cost of lime and soda required for softening 1 million litres of water containing: (MgHCO3)2 = 73 mg/L; MgSO4 = 120 mg/L; CaSO4 = 68 mg/L; CaCl2 = 111 mg/L. The cost of lime of 80%...

Which is NOT a buyer benefit of using an ISO 9001 certified supplier?ISO 9001 registration typically demonstrates a higher level of product and service quality than those suppliers that are not...

Using the functional dependencies of Exercise 7.11, compute the canonical cover Fc.

When is it preferable to use a dense index rather than a sparse index? Explain your answer. Discuss.

Define the concept of aggregation. Give two examples of where this concept is useful.

Data from the International Tanker Owners Pollution Federation Limited give the cause of spillage for 459 oil tanker accidents resulting in spills of more than 700 tons of oil from 1970-2013. a)...

The 2.5-mile Indianapolis Motor Speedway has been the home to a race on Memorial Day nearly every year since 1911. Even during the first race, there were controversies. Ralph Mulford was given the...

A survey of athletic trainers asked what modalities (treatment methods such as ice, whirlpool, ultrasound, or exercise) they commonly use to treat injuries. Respondents were each asked to list three...