Question: 1. In a Relational Database, there are several vital rules in the creation of the RDBMS that must be met for a database to be

1. In a Relational Database, there are several vital rules in the creation of the RDBMS that must be met for a database to be well designed. The rule that a foreign key can be null or must represent the primary key of another tables is called:

The Unique Foreign Key Rule

The Unique Attribute Rule

The Foreign Key Rule

The Entity Integrity Rule

The Referential Integrity Rule

The One Fact in One Place Rule

2. An insert anomaly occurs in a database when:

There is a loss of all information about an entity when a row is removed from the table

A non-primary key item is stored multiple times and updating the item in only one location causes data inconsistencies

An attribute that is a primary key in another table is not used to link the two tables.

There is an inability to add records to a database

The non-primary key item is stored multiple times

None of the above are correct

Step by Step Solution

3.50 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Answer 1 The correct answer is optionE The Referential Integrity Rule Referent... View full answer

blur-text-image
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 Questions!