Ask question

Ask question

All categories

3 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]3 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

What common communication devices are used in homes to connect to the internet and remote networks and what capabilities do thes

harkovskaia [24]

Answer:

A device is indeed a computer unit that can relay a signal throughout the phone, any contact cable or wirelessly. A modem is the best illustration of such a device of communication.

Explanation:

A device that transforms a computer's signals and transmits data over cell towers, known as Modem.

It stands for "Modulator and Demodulator" and are of two types such as: Internal and External. It is being used for accessing the site that modulates carrier tides to encode the transmitting data as well as demodulates arriving waves to decode the documentation they hold.

Other means of communication shall include:

Routers.
Hub.
Switch.
Bridge.
Network cards.

So, it's the right answer.

6 0

3 years ago

What are the two types of electronic components

IrinaVladis [17]

Answer:

The two type of electronic components are Active components and passive components

Active components are parts of a circuit that rely on an external power source to control or modify electrical signals. ... - Passive components like resistors, transformers, and diodes don't need an external power source to function. These components use some other property to control the electrical signal.

5 0

3 years ago

Read 2 more answers

Using the Sakila database, create a query that displays the film title, description, as well the actor first and last name for a

Alex787 [66]

Answer:

Select title, description , first_name, last_name from film inner join film_actor on film.film_id = film_actor.film_id inner join actor on film_actor.actor_id = actor.actor_id where title LIKE 'zo%';

Explanation:

The INNER JOIN keyword selects records that have matching values in both tables.
The WHERE clause is used to filter records.
The WHERE clause is used to extract only those records that fulfill a specified condition.

7 0

3 years ago

The beginning statement of a loop is called a declaration.<br> True<br> False

Ilya [14]

It is true the reason why it is true is

4 0

3 years ago

Read 2 more answers

Ld' is the instruction with the longest latency on the CPU from Section 4.4 (in RISC-V text). If we modified ld and sd so that t

antiseptic1488 [7]

Answer:

See explaination

Explanation:

a)

The primary factors that influence the program's speed on a new CPU are given as:-

CPU Clock speed where the speed of the process instructions is being measured.

Multi-core which is when the transistors work faster than respective CPU.

Cache which helps to note that the transition of data is smooth and fast.

b)

So, there are two CPUs suppose the old one as 'A' and the modified one as 'B'.

'A' has following features---

It takes more time to execute program as it has more clock cycle time or we can say it has low clocking rate or low speed in terms of MHz or GHz. Clock rate is the inverse of Clock Cycle Time. When you will increase the clocking rate of CPU, it will get faster and then Clock Cycle Time will get reduced.

It has less instructions provided.

'B' has following features----

It takes less time to execute program as it has less clock cycle time or we can say it has high clocking rate or high speed in terms of MHz or GHz.

It has more instructions provided.

The performance of CPU depends upon 2 factors:

The number and types of instructions that are executed by the CPU

How fast the CPU can execute those instructions?

So, overall CPU B is better as it has less execution time than CPU A but the performance will always depend upon the number and type of instructions executed by the CPU so it may vary.

Please refer to attachment for instructions and formulas.

8 0

3 years ago