Ask question

Ask question

All categories

2 years ago

6

Consider the two relations with their schemas as listed below: Employee(name, empID, birthDate, gender, address, phone) TaxAccou

nt(name, SSN, empID, federalDeductionAmt, stateDeductionAmt, ficaDeductionAmt) Constraint: TaxAccount must contain information related to all current employees only. Express the foreign key constraint in SQL.

Computers and Technology

1 answer:

Allushta [10]2 years ago

5 0

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

);

You might be interested in

Please write a code for below:

Zanzabum

Answer:

int main()

{

int x,y;

bool b1, b2;

cout<<"enter values of x : ";

cin>>x;

cout<<"enter values of y : ";

cin>>y;

b1 = y > x; // false

b2 = x > y; // true

cout << "b1 is = " << b1 << "\n";

cout << "b2 is = " << b2 << "\n";

if (b2)

cout<<endl << "Larger Number" << "\n";

else

cout << "Smaller Number" << "\n";

return 0;

}

8 0

2 years ago

A. Calculate the diffusion coefficient for magnesium in aluminum at 450°C.

SIZIF [17.4K]

Answer:

a) D = 4.88 * 10^(-14) m^2 / s

b) <em>t </em>= 1.1 hr

Solution:

a) Magnesium in Aluminum diffusion:

D = Do * exp(-Qd / RT)

= (1.2 * 10^(-4) m^2 / s) * exp ( - 130,000 / 8.31 * 723.15)

= 4.88 * 10^(-14) m^2 / s

D = 4.88 * 10^(-14) m^2 / s

b) The composition remains same at say the distance Xo:

(Cx - Co) / (Cs - Co) = Constant

Xo^2 / D_{550} * <em>t </em>= Xo^2 / D_{450} * 15

D_{550} * <em>t </em>= D_{450} * 15

(1.2 * 10^(-4) m^2 / s) * exp ( - 130,000 / 8.31 * 723.15) * <em>t</em>

(4.88 * 10^(-14) m^2 / s) * 15

by, solving for <em>t </em>we get:

<em>t </em>= 1.1 hr

So, the time required is 1.1 hr.

5 0

2 years ago

Which of the following is an antivirus software?

kotegsom [21]

Answer:

McAfee

Explanation:

An antivirus is a standalone software that protects other software. On the other hand, a Firewall is capable of preserving both software and hardware on the network.

4 0

1 year ago

Which of the following recently developed technologies has NOT greatly increased the speed of information dissemination?

Luba_88 [7]

<span>The option which hasn't greatly increased the speed of information dissemination is C. typewriter. Information can be easily and quickly shared through smartphones that have Internet access, through emails which you can send at any time, and through teleconferencing, which is basically using your camera to talk to people. The only technology which isn't really helpful nowadays is the typewriter - there are better things, such as computers, that do a better job today.</span>

3 0

2 years ago

Read 2 more answers

What three files do you need to perform a mail merge?<br><br> HELP ASAP PLEASE!!

Burka [1]

The 3 files you need to have for a successful mail merge are:

An Excel spreadsheet works
Outlook Contact List.
Apple Contacts List or Text file, etc.

<h3>What is Mail Merge?</h3>

This is known to be the act of carrying out a Mail Merge and it is one where a person will need to use a Word document and a recipient list, that is an Excel workbook.

Files needed are:

Text file,
address files, etc.

The 3 files you need to have for a successful mail merge are:

An Excel spreadsheet worksOutlook Contact List.

Apple Contacts List or Text file, etc.

Learn more about mail merge from

brainly.com/question/20904639

#SPJ1

4 0

1 year ago