Question 1

The little lines in an entity-relationship (E-R)diagram used as shorthand to represent multiple relationships are referred to as a(n)________.

Accepted Answer

A)  crow's foot
B)  identifier
C)  attribute
D)  cardinality line A

Question 2

The data integrity problem can occur only if data are ________.

Accepted Answer

A)  duplicated
B)  missing
C)  inefficient
D)  insufficient A

Question 3

The easiest time to change the database structure is after the database has been constructed and loaded with data.

Accepted Answer

A) True 
 B)False  False

Question 4

In an entity-relationship diagram,a vertical bar on a line indicates that at least one entity of that type is required in the relationship.

Accepted Answer

A) True 
 B)False

Question 5

Maximum cardinality in an entity-relationship (E-R)diagram refers to the maximum number of ________.

Accepted Answer

A)  normalizations possible in a diagram
B)  entities that can be involved in a relationship
C)  identifiers possible in a particular diagram
D)  attributes associated with an entity

Question 6

A data model does not depict the relationships among the data.

Accepted Answer

A) True 
 B)False

Question 7

Tables that are not normalized can have data integrity problems.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is true of an entity-relationship (E-R)diagram?

Accepted Answer

A)  Each entity is shown in separate rectangles.
B)  Many-to-many relationships are generally denoted by N:N.
C)  A crow's foot represents a 1:N relationship between two entities.
D)  Crow's foot is a shorthand representation for a single relationship between entities.

Question 9

What are the steps involved in transforming a data model into a relational database design?

Accepted Answer

The answer of What are the steps involved in transforming...

Question 10

A data model is a logical representation of the structure of the data.

Accepted Answer

A) True 
 B)False

Question 11

Explain the difference between maximum and minimum cardinality.

Accepted Answer

The answer of Explain the difference between maximum and minimum...

Question 12

Entities have relationships to attributes but not to each other.

Accepted Answer

A) True 
 B)False

Question 13

________ are attributes whose values are associated with one,and only one,entity instance.

Accepted Answer

A)  Cardinalities
B)  Descriptors
C)  Dependencies
D)  Identifiers

Question 14

Which of the following is a highly popular technique for creating a data model with which the developers describe the content of a database by defining what is to be stored in the database and the associations among them?

Accepted Answer

A)  entity-relationship (E-R) data model
B)  Unified Modeling Language (UML) 
C)  object-relational model
D)  semantic data model

Question 15

In an entity-relationship (E-R)diagram,a line is used to represent a relationship between two entities.

Accepted Answer

A) True 
 B)False

Question 16

Normalized tables eliminate ________.

Accepted Answer

A)  data dependency
B)  data duplication
C)  data insufficiency
D)  data conversion

Question 17

The general goal of normalization is to ________.

Accepted Answer

A)  create a copy of an existing table
B)  establish relationships among the entities in a table
C)  convert two or more tables into a single table
D)  construct tables such that every table has a single topic

Question 18

Explain the database development process.

Accepted Answer

The answer of Explain the database development process....

Question 19

Entities have attributes that describe characteristics of the entity.

Accepted Answer

A) True 
 B)False

Question 20

According to the kinds of problems they have,database practitioners classify tables into various ________.

Accepted Answer

A)  solved forms
B)  cardinalities
C)  normal forms
D)  relationships

Exam 17: Database Design

The little lines in an entity-relationship (E-R) diagram used as shorthand to represent multiple relationships are referred to as a(n) ________.

The data integrity problem can occur only if data are ________.

The easiest time to change the database structure is after the database has been constructed and loaded with data.

In an entity-relationship diagram,a vertical bar on a line indicates that at least one entity of that type is required in the relationship.

Maximum cardinality in an entity-relationship (E-R) diagram refers to the maximum number of ________.

A data model does not depict the relationships among the data.

Tables that are not normalized can have data integrity problems.

Which of the following is true of an entity-relationship (E-R) diagram?

What are the steps involved in transforming a data model into a relational database design?

A data model is a logical representation of the structure of the data.

Explain the difference between maximum and minimum cardinality.

Entities have relationships to attributes but not to each other.

________ are attributes whose values are associated with one,and only one,entity instance.

Which of the following is a highly popular technique for creating a data model with which the developers describe the content of a database by defining what is to be stored in the database and the associations among them?

In an entity-relationship (E-R)diagram,a line is used to represent a relationship between two entities.

Normalized tables eliminate ________.

The general goal of normalization is to ________.

Explain the database development process.

Entities have attributes that describe characteristics of the entity.

According to the kinds of problems they have,database practitioners classify tables into various ________.