Resources that can be saved through the use of computers

The relational algebra expressions can be rearranged and achieve the same result but with a better processing time. A selection

BigorU [14]

Answer:

c. This would reduce the number of tuples to involve in the join resulting in a more efficient query.

Explanation:

SQL or structured query language is a database querying language used to communicate or interact with databases. A database query could be as simple as returning all the columns from a database table to complex like joining several query results which in turn forms an algebra expression.

Every query statement or expression is executed with time, execution time needs to be minimized for efficiency, so, a well-arranged and reduced joining in the query improves the efficiency of the query.

8 0

3 years ago

Lindsey also needs to calculate the commissions earned each month. If the company earns $200,000 or more in a month, the commiss

lutik1710 [3]

Answer:

I have created and attached an image with example values for this question.

First we'll learn the IF function syntax:

IF(logical_test, value_if_true, [value_if_false])

Where

logical_test is the decision making comparison

value_if_true is the result to return when TRUE

value_if_false is the result to return when FALSE

We assume that cells B10 to G10 contain the Total Sales for January to June. And cells B17 to G17 contain the Commissions for January to June.

a.

The formula to use in cell B17 is:

=IF(B10>=200000;True;False)

b.

The formula to use in cell B17 is:

=IF(B10>=200000;B10*0.35;False)

c.

The formula to use in cell B17 is:

=IF(B10>=200000;B10*0.35;B10*0.27)

d.

To copy the formula in B17 to C17:G17, you can just copy and paste or select cell B17 and drag from the black square on the bottom right of the cell.

8 0

3 years ago

Read 2 more answers

What is the function of a bread crumb trial in a website

joja [24]

Answer:

A “breadcrumb” (or “breadcrumb trail”) is a type of secondary navigation scheme that reveals the user's location in a website or Web application. The term comes from the Hansel and Gretel fairy tale in which the two title children drop breadcrumbs to form a trail back to their home.

Explanation:

A breadcrumb or breadcrumb trail is a graphical control element frequently used as a navigational aid in user interfaces and on web pages. It allows users to keep track and maintain awareness of their locations within programs, documents, or websites. Breadcrumbs make it easier for users to navigate a website – and they encourage users to browse other sections of the site. ... You head to their site and end up on The Nestle company history page. Using their breadcrumbs, you can easily navigate back to About Us, History, or even their home page.

6 0

3 years ago

Anyone got an xb0x and wann be friends 16+

Amiraneli [1.4K]

Answer:pointsssExplanation:

4 0

3 years ago

Read 2 more answers

Which of these is NOT an example of intellectual property? O a song you wrote O an article you published O hardware you purchase

solmaris [256]

Answer:

hardware you purchased

Explanation:

Copyright law can be defined as a set of formal rules granted by a government to protect an intellectual property by giving the owner an exclusive right to use while preventing any unauthorized access, use or duplication by others.

Patent can be defined as the exclusive or sole right granted to an inventor by a sovereign authority such as a government, which enables him or her to manufacture, use, or sell an invention for a specific period of time.

Generally, patents are used on innovation for products that are manufactured through the application of various technologies.

Basically, the three (3) main ways to protect an intellectual property is to employ the use of

I. Trademarks.

II. Patents.

III. Copyright.

An intellectual property can be defined as an intangible and innovative creation of the mind that solely depends on human intellect. They include intellectual and artistic creations such as name, symbol, literary work, songs, graphic design, computer codes, inventions, etc.

Hence, a hardware you purchased is not an example of an intellectual property.

6 0

3 years ago

Resources that can be saved through the use of computers​

Resources that can be saved through the use of computers