Chap#12 Data Integrity and Normalization

Question 1

In 3NF, which form of dependency is removed?

Answer 1

Transitive

Question 2

In relational database, a table is also called a:

Answer 2

Relation

Question 3

In 3NF, a non-key attribute must not depend on a(n):

Answer 3

Non-key attribute

Question 4

Different attributes in two different tables having same name are referred to as:

Answer 4

Homonym

Question 5

Every relation must have a:

Answer 5

Primary Key

Question 6

Relationships between _____ in a database management system.

Answer 6

Objects

Question 7

An ______ is a thing is the real world that is distinguishable from all other objects

Answer 7

Entity

Question 8

If an entity is connected to many other entities then the relationship is called:

Answer 8

One to many relationship

Question 9

If an entity is connected directly to another object/entity, then the relationship is called:

Answer 9

One to one relatonship

Question 10

When queries are made over multiple tables, the related tables will be:

Answer 10

Joined automatically

Question 11

Indexes, on fields of the table, are used:

Answer 11

➡To speed up the sorting process
➡To speed up the searching process

Question 12

Each attribute of an entity set has a particular value. The set of possible values that a given attribute can take is called its:

Answer 12

Domain

Question 13

Which of the following is the reverse association?

Answer 13

➡One to one association
➡One to many association
➡Many to many association

Question 14

If there are two possibilities, either one value of data or not, this type of association is called:

Answer 14

Conditional