All categories

3 years ago

A ________ database state is one in which all data integrity constraints are satisfied

Computers and Technology

2 answers:

beks73 [17]3 years ago

8 0

A consistent database base is one in which all data integrity constraints are satisfied.

seropon [69]3 years ago

7 0

A state where all data integrity constraints are satisfied is called a consistent state. It is achieved by ensuring that any data which are going to be written follow the database rules. If a certain attempt to introduce inconsistent data occurs, the attempt is rolled back and an error will be returned to the user.

You might be interested in

Suppose two computers (A & B) are directly connected through Ethernet cable. A is sending data to B, Sketch the waveform pro

storchak [24]

Answer:

Physical and data link layer.

Explanation:

The ethernet cable is used at the physical layer. The physical layer consists of hardware components. This layer is responsible for transmission of data bits between two nodes via a physical wire. The data link layer provides the means in which data packets are transmitted from one node to another.

Suppose two computers (A & B) are directly connected through Ethernet cable. A is sending data to B, the packets would be sent from computer A to computer B if computer B is free if not it would wait until computer B is not transmitting before it can start sending data packets to computer B.

5 0

3 years ago

How many comparisons will be done to find 8 in this list using a linear search?

Margaret [11]

Answer:

I think 4 comparisons

8 0

3 years ago

About how many jobs in the United States require Microsoft expertise?

GarryVolchara [31]

Answer: C because bill gates is the owner

5 0

3 years ago

A computer retail store has 15 personal computers in stock. A buyer wants to purchase 3 of them. Unknown to either the retail st

Dima020 [189]

Answer:

a. 1365 ways

b. Probability = 0.4096

c. Probability = 0.5904

Explanation:

Given

PCs = 15

Purchase = 3

Solving (a): Ways to select 4 computers out of 15, we make use of Combination formula as follows;

$^nC_r = \frac{n!}{(n-r)!r!}$

Where $n = 15\ and\ r = 4$

$^{15}C_4 = \frac{15!}{(15-4)!4!}$

$^{15}C_4 = \frac{15!}{11!4!}$

$^{15}C_4 = \frac{15 * 14 * 13 * 12 * 11!}{11! * 4 * 3 * 2 * 1}$

$^{15}C_4 = \frac{15 * 14 * 13 * 12}{4 * 3 * 2 * 1}$

$^{15}C_4 = \frac{32760}{24}$

$^{15}C_4 = 1365$

Hence, there are 1365 ways 

Solving (b): The probability that exactly 1 will be defective (from the selected 4)

First, we calculate the probability of a PC being defective (p) and probability of a PC not being defective (q)

From the given parameters; 3 out of 15 is detective;

So;

$p = 3/15$

$p = 0.2$

$q = 1 - p$

$q = 1 - 0.2$

$q = 0.8$

Solving further using binomial;

$(p + q)^n = p^n + ^nC_1p^{n-1}q + ^nC_2p^{n-2}q^2 + .....+q^n$

Where n = 4

For the probability that exactly 1 out of 4 will be defective, we make use of

$Probability = ^nC_3pq^3$

Substitute 4 for n, 0.2 for p and 0.8 for q

$Probability = ^4C_3 * 0.2 * 0.8^3$

$Probability = \frac{4!}{3!1!} * 0.2 * 0.8^3$

$Probability = 4 * 0.2 * 0.8^3$

$Probability = 0.4096$

Solving (c): Probability that at least one is defective;

In probability, opposite probability sums to 1;

Hence;

Probability that at least one is defective + Probability that at none is defective = 1

Probability that none is defective is calculated as thus;

$Probability = q^n$

Substitute 4 for n and 0.8 for q

$Probability = 0.8^4$

$Probability = 0.4096$

Substitute 0.4096 for Probability that at none is defective

Probability that at least one is defective + 0.4096= 1

Collect Like Terms

Probability = 1 - 0.4096

Probability = 0.5904

8 0

3 years ago

Why header files are needed in every c program ?expalin

bonufazy [111]

Answer:

Header files serve two purposes. System header files declare the interfaces to parts of the operating system. You include them in your program to supply the definitions and declarations you need to invoke system calls and libraries.

6 0

2 years ago