1

QUESTION 6 Which of the following statements best illustrates the "Key" constraint? The schema MUST be...

Question

QUESTION 6 Which of the following statements best illustrates the "Key" constraint? The schema MUST be...

QUESTION 6 Which of the following statements best illustrates the Key constraint? The schema MUST be created before tables

QUESTION 6 Which of the following statements best illustrates the "Key" constraint? The schema MUST be created before tables are added A primary key MUST NOT have duplicate values A foreign key value MUST have a value already present as a primary key in another table (or be NULL) A primary key value MUST have a value QUESTION 7 Which of the following statements best illustrates the "Referential Integrity" constraint? The schema MUST be created before tables are added A foreign key value MUST have a value already present as a primary key in another table (or be NULL) A primary key value MUST have a value A primary key MUST NOT have duplicate values

Answers

6

Ans: A primary key MUST NOT have duplicate values

In databases mainly we have 2 Types of keys

1. Primary key:

A key should be unique throughout the table and it should not have null values. It is used to uniquely identify the table row or one unique record of table.

2. Foreign key:

A key which is referring to the primary key of another table.

A foreign key has link with the primary key of another table.

7

Ans: a foreign key key value MUST have a value already present as a primary key in another table( or be null)

Referential integrity means having a link with another primary key of another table and if that primary key data changes automatically it will be affected.

A foreign key have a reference of primary key


Similar Solved Questions

1 answers
Which has more stomata, the upper or the lower epidermis? Why?
Which has more stomata, the upper or the lower epidermis? Why?...
1 answers
We were unable to transcribe this imageWe were unable to transcribe this imageJounaize the six adjusting...
We were unable to transcribe this imageWe were unable to transcribe this imageJounaize the six adjusting entries required at July 31, based on the data presented Refer to the Chart of Accounts for exact wordting of account tidies PAGE T0 JOURNAL ACCOUNTING EQUATION POST REF CREDIT ASSETSLIABALITIES ...
1 answers
4 Odessa, Inc., reports the following information concerning operations for the most recent month Master Budget...
4 Odessa, Inc., reports the following information concerning operations for the most recent month Master Budget 14.28 Actual (based on actual of 540 units) $ 88,320 (based on points budgeted 6e0 units) $ 96,e00 Sales revenue Less Manufacturing costs eBook Direct labor 13,632 11,520 14,400 13,440 Mat...
1 answers
Mat t be identifll ricating oil for machili who can id kers Whcsform the materials into...
mat t be identifll ricating oil for machili who can id kers Whcsform the materials into a finished product. n be identified directly, al l transfor orkers the materials into a finished product, often directly WI reasonable cost. manufacturing overhead Al production costs except transsufacturing over...
1 answers
Required information Exercise 2-15 Plantwide and Departmental Predetermined Overhead Rates; Job Costs [LO2-1, LO2-2, LO2-3, LO2-4)...
Required information Exercise 2-15 Plantwide and Departmental Predetermined Overhead Rates; Job Costs [LO2-1, LO2-2, LO2-3, LO2-4) (The following information applies to the questions displayed below.) Delph Company uses a job-order costing system and has two manufacturing departments-Molding and Fab...
1 answers
Calculate 5 mg/kg of Enrofloxican (concentration 22.7 mg/ml) for a 32 kg dog
calculate 5 mg/kg of Enrofloxican (concentration 22.7 mg/ml) for a 32 kg dog...
1 answers
If the Oort cloud extends half way to Alpha Centauri, wouldn't this mean that the Centauri system's cloud would intersect ours?
If the Oort cloud extends half way to Alpha Centauri, wouldn't this mean that the Centauri system's cloud would intersect ours?...
1 answers
To study the effect of temperature on yield in a chemical process, five batches were produced...
To study the effect of temperature on yield in a chemical process, five batches were produced at each of three temperature levels. The results follow. Temperature 50°C 60°C 70°C 34 32 22 24 33 27 36 36 27 39 25 29 32 29 30 Construct an analysis of varianc...
1 answers
Please provide a lot of details. Thank you! 20. Prove the Second Isomorphism Theorem for rings:...
Please provide a lot of details. Thank you! 20. Prove the Second Isomorphism Theorem for rings: Let I be a subring ofa ring R and J an ideal in R. Then In Jis an ideal in I and...
1 answers
Please answer parts A & B Phy280.F18 <p12 Problem 5.46 ▼PartA An unstretched spring is 14.0...
Please answer parts A & B Phy280.F18 <p12 Problem 5.46 ▼PartA An unstretched spring is 14.0 ㎝long, when you hang an 800 g weight from it, it stretches to a length of 17.0 What is the force constant (in N/m) of this spring? N/m PartB What total mass must you hang from the sprin...
1 answers
#14 & 15
Magma (molten rock) comes from the molten outer core.Group of answer choicesTrueFalse Flag this QuestionQuestion 151 ptsMost of the mantle is moltenGroup of answer choicesTrueFalse...
1 answers
What did the Human Genome Project map?
What did the Human Genome Project map?...
1 answers
Please help me solve both of these!! Write the complete stepwise mechanism for the acid catalyzed...
please help me solve both of these!! Write the complete stepwise mechanism for the acid catalyzed hydrolysis of the compound shown. Show all intermediates, indicate with curved arrows the movement of electrons and show all formal charges and lone pairs of electrons where relevant. Write the stru...
1 answers
Exercise 23-7 Scrap or rework LO A1 Varto Company has 11,000 units of its sole product...
Exercise 23-7 Scrap or rework LO A1 Varto Company has 11,000 units of its sole product in inventory that it produced last year at a cost of $24 each. This year's model is superior to last year's, and the 11,000 units cannot be sold at last year's regular selling price of $47 each. Varto ...
1 answers
3. The discrete random variable X has the following probability distribution: IX 13 18 20 24...
3. The discrete random variable X has the following probability distribution: IX 13 18 20 24 27 P(x) 0.22 0.25 0.20 0.17 0.16 a. P(18) b. P(X > 18). C. P(X s 18). d. The mean u of X. e. The standard deviation o of X....
1 answers
2) Give systematic IUPAC names for each of the following; 4 points a) CI OH
2) Give systematic IUPAC names for each of the following; 4 points a) CI OH...
1 answers
Table 2: Complete the table below. When drawing the VSEPR siructures identify the most polar bondis)...
Table 2: Complete the table below. When drawing the VSEPR siructures identify the most polar bondis) by placing &+ and &charges on their atoms ist bond angles IMF(s) Present Bond Angles Line Drawings VSEPR Drawings Methanol 1-Propanol 1-Butasel 2-Butanone Page 9 of 13 MacBook Pro te the tabl...

-- 0.008512--