Question: What is referential integrity rule? a. Primary keys cannot be null. b. Foreign keys cannot be null. c. The data values of a forging key

What is referential integrity rule?
a. Primary keys cannot be null.
b. Foreign keys cannot be null.
c. The data values of a forging key always exist in the corresponding table.
d. Foreign keys could be null.

Step by Step Solution

★★★★★

3.31 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The correct answer is b Foreign keys cannot be null The referential integrity rule states that forei... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Information Systems Questions!

Starting with the data values of 70 and 85, add three data values to your sample so that the sample has the following: (Justify your answer in each case.) a. A standard deviation of 5 b. A standard...

What are primary keys and foreign keys? How are they used to create links between tables in a relational database?

What rules must be followed if referential integrity is enforced?

What is referential integrity rule? Multiple Choice Primary keys cannot be null. Foreign keys cannot be null. The data values of a forging key always exist in the corresponding table. Foreign keys...

What is referential integrity rule? a. Primary keys cannot be null. b. Foreign keys cannot be null. c. The data values of a forging key always exist in the corresponding table. d. Foreign keys could...

What is referential integrity rule? Multiple Choice Primary keys cannot be null. Foreign keys cannot be null. The data values of a foreign key may not exist in the corresponding table. Foreign keys...

MULTIPLE CHOICE QUESTIONS 1. Nulls, if used improperly, can create problems because they can represent ____. a. a default value b. a known, but missing, attribute value c. zero d. an unsortable value...

Group Project Part III Kim s Flower Inc. Purchasing ( Expenditure ) Cycle Requirements: The final part of the project requires your team to implement the logical data model in MS Access. Please read...

Which of the following correctly states the referential integrity rule? The primary key of a table must have data values ( cannot be null ) . The foreign key of a table must have a data value (...

Group Project - Part III Kim's Flower Inc. Purchasing (Expenditure) Cycle Requirements: The final part of the project requires your team to implement the logical data model in MS Access. Please read...

A matrix organization is difficult to manage all by itself. What do you think the problems would be in managing mixed organizational systems?

According to surveys by the Merritt Hawkins White Paper Series, 2018, the average family practice physician earned approximately what amount in 2018? a. $145,000 b. $220,000 C. $192,000 d. $160,000...

11. On June 30 the general ledger of Osaki, Inc., had the following balances: Purchases $46,980 Dr. Freight In 3,396 Dr. Purchases Returns and Allowances 3,960 Cr. Purchases Discounts 651 Cr....

The peripheral nervous system a. connects the brain to the spinal cord. b. calms the body after an emergency. c. is limited to the control of voluntary movement. d. controls only the arms and the...

The Beach Dude Inc. (BD) sells surf gear and clothing to retail stores around the country. It outsources the production of most of its items, so its warehouse is very busy receiving incoming...

SlowRider Inc. had a rudimentary business intelligence (BI) system. Analysts at SlowRider Inc. pulled data from three different ERP systems, loaded the data into Excel spreadsheets, and e-mailed...

Moore's law suggests that computing power for the same cost doubles every two-and-a-half years. A combination of Moore's law and the commoditization of computer components has made it possible to buy...

3. Although we did not spend time in lecture to study signals SIGCONT and SIGSTOP, it is not hard at all to see how these two signals work. Read the brief description on these two signals in textbook...

Two young entrepreneurs want to invest $275,000 in a restaurant. Their business plan shows that the restaurant will generate the following cash flows: Year Cashflow 1 S 2 $ 3 $ 4 $ 5 $ 20,000 30,000...

Your friend, Cindy Brady, has come to you for financial advice. She graduated from college three years ago and was hired right out of college by a firm she had interned with the summer before her...