Four actions that can be implemented on a database to autocorrect violations of referential integrity, and the outcomes of the a
1 answer:
Answer:
Follows are the matching to this question:
Explanation:
While time-consuming or prone to errors mechanical adjustments to both the referential, databases could be configured with four measures to engine violations. The restricted action causes the insert, update, and removes to only be denied. Set Null to NULL sets the invalid external key, whereas Set Default to a specific core consideration specified in SQL sets a default foreign key. Its Cascade operation spreads the main changes in external keys.
You might be interested in
Answer:
The code is given as follows,
Explanation:
Code:
#include <stdio.h>
#include <string.h>
int n; //to store size of array
char* ArrayChallenge(int arr[]) //function returns string true or false
{
int i, j;
int sum = 0;
for(i = 0; i < n; i++)
{
sum = sum + arr[i]; //count sum
}
for(i = 0; i < n; i++)
{
for(j = i+1; j < n; j++) //loop for every two elements in array
{
if(arr[i]*arr[j] > 2*sum) //check if proudct of two elements > 2 times sum
{
printf("\n%d x %d = %d, 2xSum = %d\n", arr[i], arr[j], arr[i]*arr[j], 2*sum);
return "true"; //If proudct of two elements > 2 times sum. return true
}
}
}
return "false"; // If proudct of two elements < 2 times sum. return false
}
int main()
{
printf("\nEnter size of array: ");
scanf("%d", &n); //read size of array
int A[n]; //array of size n
printf("\nEnter array elements: ");
int i;
for(i = 0; i < n; i++)
{
scanf("%d", &A[i]); //read array from stdin
}
printf("%s\n",ArrayChallenge(A)); //ccall function and print answer
return 0;
}
Answer:
Explanation:
The objective of this program we are to develop is to compute a C++ program and a flowchart that calculates a cost to replace all tablets and desktop computers in a business.
C++ Program
#include<iostream>
#include<iomanip>
using namespace std;
/*
⦁ // Name:
⦁ // Date:
⦁ // Program Name:
⦁ // Description:
*/
int main()
{
const double SalesTaxRate = .075, DiscountPercent = .10, FinanceCharge = .15;
const double TABLET = 320.00, DESKTOP = 800.00;
double total = 0.0, subTotal = 0.0,avg=0.0;
int numberOfTablets, numberOfDesktop;
cout << "-------------- Welcome to Computer Selling Company ------------------ ";
cout << "Enter number of tablets: ";
cin >> numberOfTablets;
cout << "Enter number of desktops: ";
cin >> numberOfDesktop;
subTotal = TABLET * numberOfTablets + numberOfDesktop * DESKTOP;
char choice;
cout << "Paying cash or financing: (c/f): ";
cin >> choice;
cout << fixed << setprecision(2);
if (choice == 'c' || choice == 'C')
{
cout << "You have choosen paying cash." << endl;
total = subTotal - subTotal * DiscountPercent;
cout << "Discount you get $" << subTotal * DiscountPercent<<endl;
cout << "Sales Tax: $" << SalesTaxRate * total << endl;
total = total + total * SalesTaxRate;
cout << "Total computers' Cost: $" << total << endl;
avg = total / (numberOfDesktop + numberOfTablets);
cout << "Average computer cost: $ " << avg << endl;
}
else if (choice == 'f' || choice == 'F')
{
cout << "You have choosen Finance option." << endl;
total = subTotal + subTotal * FinanceCharge;
cout << "Finance Charge $" << subTotal * FinanceCharge << endl;
cout << "Sales Tax: $" << SalesTaxRate * total << endl;
total = total + total * SalesTaxRate;
cout << "Total computers' Cost: $" << total << endl;
avg = total / (numberOfDesktop + numberOfTablets);
cout << "Average computer cost: $ " << avg << endl;
}
else
{
cout << "Wrong choice.......Existing.... ";
system("pause");
}
//to hold the output screen
system("pause");
} }
OUTPUT:
The Output of the program is shown in the first data file attached below:
FLOWCHART:
See the second diagram attached for the designed flowchart.
