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

Answer rating: 100% (QA)

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