Referential integrity states that:______.

Computers and Technology

1 answer:

densk [106]2 years ago

7 0

Answer:

D. Each foreign key value MUST match a primary key value in another relation or the foreign key value must be null.

Explanation:

In Computer programming, integrity constraints can be defined as a set of standard rules that ensures quality information and database are maintained.

Basically, there are four (4) types of integrity constraints and these are;

1. Key constraints.

2. Domain constraints.

3. Entity integrity constraints.

4. Referential integrity constraints.

Referential integrity states that each foreign key value must match a primary key value in another relation or the foreign key value must be null.

For instance, when a foreign key in Table A points to the primary key of Table B, according to the referential integrity constraints, all the value of the foreign key in Table A must be null or match the primary key in Table B.

<em>Hence, the referential Integrity constraints ensures that the relationship between the data in a table is consistent and valid. </em>

You might be interested in

List one unprofessional AND one professional example of internet/social media

Leni [432]

Professional: Using social media to advertise a company you created

Unprofessional: Using social media to watch cat videos

4 0

2 years ago

_____ is a function performed by control programs that manages computer resources, such as storage and memory.

Fudgin [204]

Resource allocation is a function performed by control programs that manages computer resources, such as storage and memory. It is necessary for any application to be run on the system because the computer is required to allocate certain resources for it to be able to run once the user opens any program.

5 0

3 years ago

When you think of computers, I want you to think:

jekas [21]

Answer:

Explanation:

When I think about computers, I can understand about the software and the hardware, we can touch the hardware, but the software don't because is only data stored in the hardware, we can interact with the stored data using the hardware, we can complete a system with data, software, hardware, and people, people try to learn about software because it is better paid than fix a hardware.

5 0

2 years ago

Examine the efficiency the various recovery algorithms used in deadlock handling

sineoko [7]

Solution:

The process of transaction can guarantee the reliability of business applications. Locking resources is widely used in distributed transaction management (e.g; two phase commit, 2PC) to keep the system consistent. The locking mechanism, however, potentially results in various deadlocks. In service oriented architecture, the deadlock problem becomes even worse because multiple transactions try to lock shared resources in the unexpectable way due to the more randomicity of transaction requests, which has not been solved by existing research results. In this paper, we investigate how to prevent local deadlocks, caused by the resource competition among multiple sub-transactions of a gl obal transaction, and global deadlocks from the competition among different global transactions. We propose a replication based approach to avoid the local deadlocks, and a timestamp based approach to significantly mitigate the global deadlocks. A general algorithm is designed for both local and global deadlock prevention. The experimental results demonstrate the effectiveness and efficiency of our deadlock prevention approach. Further, it is also proved that our approach provides higher system performance than traditional resource allocation schemes.

This is the required answer.

4 0

3 years ago

Write the following program in C++ to print:

Alenkinab [10]

1.
#include <iostream>#include <string>
using namespace std;
int main(){ string chars; // This is where we will put our @ signs and print them for(int x=0;x < 5; x++){
chars = chars + '@'; // This will concatenate an @ sign at the end of the variable cout << chars << "\n"; }}

2.
#include <iostream>#include <string>
using namespace std;
int main(){ string name; // Our variable to store the name cout << "What is your name? \n"; // Asks the user for their name cin >> name; cout << "\nWell, hello " << name << "!";}

3.
#include <iostream>#include <string>
using namespace std;
int main(){ int number; // Our variable cout << "Enter a number\n"; // Asks for a number cin >> number; cout << "You entered " << number << "%!";}

4.
#include <iostream>#include <string>
using namespace std;
int main(){ int number; // Our variable cout << "Enter a number\n"; cin >> number;
int check = number % 2; // The modulo operator (the percent sign) gets the remainder of the quotient if (check == 0) { cout << number << " is even!"; // If the remainder is 0 then it prints out "x is even" } else { cout << number << " is odd!"; // If the remainder is not 0 then it prints out "x is odd" }}

5.
#include <iostream>#include <string>
using namespace std;
int main(){ float r; // Our variable cout << "Enter a radius\n"; cin >> r; if (r < 0){ cout << "Lol. No."; // If the radius is less than zero print out that message } float circumference=2*3.14*r; float area=r*r*3.14; cout << "\n\n Circumference of circle: " << circumference; cout << "\n Area of circle: " << area;}

4 0

3 years ago