1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Alchen [17]
3 years ago
10

What is a foreign key and how does it provide referential integrity?

Computers and Technology
1 answer:
Step2247 [10]3 years ago
4 0

Answer:

By definition a foreign key of table A is a primary key of another table B, thereby establishing a link between them.

To provide referential integrity you can use these referential actions:

  • <u>Cascade:</u> If rows in table B are deleted, the matching foreign key columns in table A are deleted.
  • <u>Set Null:</u> If rows in table B are deleted, the matching foreign key columns in table A are set to null.
  • <u>Set Default:</u> If rows in table B are deleted, the matching foreign key columns in table A are set with the default value of the column.
  • <u>Restrict:</u> A value in table B cannot be deleted or updated while as it is referred to by a foreign key in table A.

You might be interested in
Can someone help me with these questions?
REY [17]

website will be the first, hyperlink will be the second, A will be number three, and webpage will be number 4

8 0
3 years ago
A Chief Security Officer (CSO) has asked a technician to devise a solution that can detect unauthorized execution privileges fro
VikaD [51]

A solution which would best meet the CSO's requirements is: B. Sandboxing.

<h3>What is a sandbox?</h3>

A sandbox can be defined as an isolated environment in a computer system or on a network that is designed and developed to mimic end user operating system (OS) and environments, so as to detect unauthorized execution privileges from the operating system (OS).

In cybersecurity, sandboxing is typically used to safely execute suspicious code and data files without causing any harm to the host device or network. Also, sandboxing can work in conjunction with proxies or unified threat management (UTM).

Read more on sandboxing here: brainly.com/question/25883753

8 0
2 years ago
When is an original work considered Public Domain? A. When posted via social media. B. When is it posted on the internet C. When
I am Lyosha [343]
<span>Best Answer is (D)
</span>

Any<span> materials not protected by copyright, patent laws or trademark are referred to as copyright. Generally, the public owns these works, and anyone is allowed to use public domain works without obtaining permission. There are various common ways that these works may end up arriving in the public domain. One of those ways includes the expiration of copyright. The copyright owner may also fail to follow renewal rules that govern copyright. </span>The copyright owner may as well decide to place his or her works deliberately in the public <span>domain.</span>

3 0
3 years ago
The below program uses an array salaryBase to hold the cutoffs for each salary level and a parallel array taxBase that has the c
marissa [1.9K]

Answer:

Check the explanation

Explanation:

1. After running the program for annual salary 40000 and 50000 and then enter 0

a) For annual salaries of 40000

taxRate will be . 20

taxToPay will be 40000 x .20 = 8000

b)For annual salaries of 50000

taxRate will be . 30

taxToPay will be 50000 x .30 = 15000

2. Modify the program to use two parallel arrays named annualSalaries and taxesToPay

a) For implementing array of anuualSalaries that take input from user, refer following given code:

Scanner s=new Scanner(System.in);

   System.out.println("enter number of anuualSalaries");

   int n=s.nextInt();

   int anuualSalaries[]=new int[n];

   System.out.println("enter anuualSalaries");

   for(int i=0;i<n;i++){//for reading array

       anuualSalaries[i]=s.nextInt();

b) For implementing array of taxestoPay refer following code

int taxestoPay[] = new int[anuualSalaries.length];

       for (int i = 0; i < taxestoPay.length; i++) {

           taxestoPay[i] = "enter the result value of tax to pay"

       }

4. For two dimensional array of salariesAndTaxes refer following given code

int[][] salariesAndTaxes = new int[2][];

salariesAndTaxes[0] = new int[10];

salariesAndTaxes[1] = new int[10];

5 0
3 years ago
A data mart differs from a data warehouse in that: Group of answer choices it deals with a particular component or functional ar
pickupchik [31]

Answer:

A Data Warehouse is a corporate database that integrates purified information from the various sources in the organization. This information must be homogeneous and reliable, it is stored in a way that allows its analysis from many different perspectives, and that it is in turn of the optimal response times. For this, the information is highly denormalized and modeled in a way quite different from transactional systems, mainly the star models (star scheme) and snowflake (snowflake scheme) that we will study later.

A Data Warehouse is much more than what we have commented so far. According to Bill Inmon it is characterized by being:

Theme-oriented: data is organized by topics to facilitate user understanding, so that all data related to the same element of real life is linked together. For example, all customer data can be consolidated in the same table, all product data in another, and so on.

Integrated: the data must be integrated into a consistent structure, eliminating the inconsistencies involved between the various operational systems. The information is structured in various levels of detail to suit the needs of users. Some of the most common inconsistencies that we usually find are: in nomenclature, in units of measure, in date formats, multiple tables with similar information (for example, having several applications in the company, each with customer tables) .

Historical (time variant): the data, which may vary over time, must remain reflected in such a way that these changes are consulted and the reality that was at the time they were stored is not altered, thus avoiding the problem that occurs in the operational systems, that specifically only the state of the present business activity. A Data Warehouse must save the different values ​​that take a variable over time. For example, if a client has lived in three different cities, he must specify the period he lived in each of them and associate the facts (sales, returns, incidents, etc.) that occurred at any time to the city in which He lived when they occurred, and did not associate all historical facts with the city in which he currently lives. If a customer, during all the time we have been selling has gone through three civil states (single, married and divorced) we must know what marital status he had at the time we made each of the sales.

4 0
3 years ago
Other questions:
  • Mica's creating his web page with a software that is free of charge for the first month. If he likes the program, he will have t
    7·2 answers
  • Which function would you use to make sure all names are prepared for a mailing label?
    10·2 answers
  • In computers, when the print command is executed, a cable carries this signal from the computer to the printer. In comparing a c
    11·1 answer
  • Theodor is researching computer programming. He thinks that this career has a great employment outlook, so he'd like to learn if
    9·2 answers
  • You are creating a presentation and you have come to the last slide. you still have more information to add. what should you do?
    10·2 answers
  • Can someone help me?
    5·2 answers
  • Which of these is not a way of avoiding email fraud and scams?
    6·1 answer
  • From which country samsung is​
    6·2 answers
  • 4 brainly
    9·1 answer
  • Help help help help help help help help
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!