Question 1

Normalization is done before creating the database design.

Accepted Answer

A) True 
 B)False

Question 2

A relation is a characteristic or property of an entity.

Accepted Answer

A) True 
 B)False

Question 3

How does a DBMS that follows the relational model handle entities, attributes of entities, and relationships between entities?

Accepted Answer

The answer of How does a DBMS that follows the...

Question 4

In the one-to-many type of relationship, the word many always indicates a large number.

Accepted Answer

A) True 
 B)False

Question 5

A table is in third normal form if it is in second normal form and no nonkey column is dependent on only a portion of the primary key.

Accepted Answer

A) True 
 B)False

Question 6

In a relation, all values in a column are values of the same attribute.

Accepted Answer

A) True 
 B)False

Question 7

A(n) ____________________ is the association between entities.

Accepted Answer

The answer of A(n) ____________________ is the association between entities....

Question 8

In one style of entity-relationship (E-R) diagrams, diamonds are used to describe ____________________.

Accepted Answer

The answer of In one style of entity-relationship (E-R) diagrams,...

Question 9

When you convert an unnormalized table to a table in first normal form, the primary key of the table in first normal form is usually the concatenation of at least two columns.

Accepted Answer

A) True 
 B)False

Question 10

Columns are sometimes called tuples.

Accepted Answer

A) True 
 B)False

Question 11

A(n) ____ is the association between entities.

Accepted Answer

A)  qualification 
B)  functional dependency 
C)  relationship 
D)  join

Question 12

A relational database is a collection of ____________________.

Accepted Answer

The answer of A relational database is a collection of...

Question 13

A relation is essentially a three-dimensional table.

Accepted Answer

A) True 
 B)False

Question 14

A(n) ____________________ is another name for a record or a row.

Accepted Answer

The answer of A(n) ____________________ is another name for a...

Question 15

A(n) ____________________ is a person, place, thing, or event for which you want to store and process data.

Accepted Answer

The answer of A(n) ____________________ is a person, place, thing,...

Exam 2: Database Design Fundamentals

Normalization is done before creating the database design.

A relation is a characteristic or property of an entity.

How does a DBMS that follows the relational model handle entities, attributes of entities, and relationships between entities?

In the one-to-many type of relationship, the word many always indicates a large number.

A table is in third normal form if it is in second normal form and no nonkey column is dependent on only a portion of the primary key.

In a relation, all values in a column are values of the same attribute.

A(n) ____________________ is the association between entities.

In one style of entity-relationship (E-R) diagrams, diamonds are used to describe ____________________.

When you convert an unnormalized table to a table in first normal form, the primary key of the table in first normal form is usually the concatenation of at least two columns.

Columns are sometimes called tuples.

A(n) ____ is the association between entities.

A relational database is a collection of ____________________.

A relation is essentially a three-dimensional table.

A(n) ____________________ is another name for a record or a row.

A(n) ____________________ is a person, place, thing, or event for which you want to store and process data.