Question 1

An identifier is an attribute whose value is associated with every entity in the data model.

Accepted Answer

A) True 
 B)False  False

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

Which of the following is TRUE of entities?

Accepted Answer

A)   Entities have an identifier whose value is associated with every entity in the data model.
B)   Entities can only represent a logical construct or transaction, not a physical object.
C)   The characteristics of entities are described by attributes.
D)   The names of entities are always plural. C

Question 4

The notation N:N is used to indicate a many-to-many relationship in an E-R diagram.

Accepted Answer

A) True 
 B)False

Question 5

Normalization is a database design concept that helps to construct well-structured tables.

Accepted Answer

A) True 
 B)False

Question 6

Entities have relationships with each other.

Accepted Answer

A) True 
 B)False

Question 7

While representing the relationship between two entities in an entity-relationship diagram, the N:N notation is used to indicate that the same number of entities are present on each end of the relationship.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Roger teaches a Chemistry class at the state university. Each student in the class can only be tutored by Roger; however, he can tutor multiple students. In a data model, this relationship is best represented as a(n) ________.

Accepted Answer

A)   N:M relationship
B)   N:N relationship
C)   1:N relationship
D)   1:1 relationship

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

What is the next step after the users validate the data model?

Accepted Answer

A)   The database is designed.
B)   The requirements are verified.
C)   The tables are identified.
D)   The database is created.

Question 13

Once the users have validated and approved the data model, it is transformed into a ________.

Accepted Answer

A)   database design
B)   technical report
C)   knowledge system
D)   data repository

Question 14

Which of the following statements is TRUE of identifiers?

Accepted Answer

A)   They are constraints on minimum requirements in a relationship.
B)   They are data that users want to track.
C)   They highlight instances of data duplication in a database.
D)   They are attributes whose values are associated with only one entity instance.

Question 15

It is not necessary for a user to understand the data model. The IT department will handle any misunderstandings.

Accepted Answer

A) True 
 B)False

Question 16

The angled 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

Question 17

Carol, an online shopping customer, raises a complaint stating she had placed an order for books two weeks ago but has still not received them. Nigel, in charge of handling complaints for the site, wants to verify Carol's complaint. He tracks the order number and the order date for Carol's books. The data that Nigel is tracking are also called ________.

Accepted Answer

A)   attributes
B)   dependencies
C)   cardinalities
D)   alternatives

Question 18

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

Question 19

Which of the following is TRUE of a data model?

Accepted Answer

A)   It is created after the database is designed.
B)   It is an attribute whose value is associated with only one entity instance.
C)   It is a logical representation of the structure of the data.
D)   It does not describe the relationships among the data.

Question 20

Explain the database development process.

Accepted Answer

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

Exam 17: Database Design

An identifier is an attribute whose value is associated with every entity in the data model.

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

Which of the following is TRUE of entities?

The notation N:N is used to indicate a many-to-many relationship in an E-R diagram.

Normalization is a database design concept that helps to construct well-structured tables.

Entities have relationships with each other.

While representing the relationship between two entities in an entity-relationship diagram, the N:N notation is used to indicate that the same number of entities are present on each end of the relationship.

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

Roger teaches a Chemistry class at the state university. Each student in the class can only be tutored by Roger; however, he can tutor multiple students. In a data model, this relationship is best represented as a(n) ________.

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

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

What is the next step after the users validate the data model?

Once the users have validated and approved the data model, it is transformed into a ________.

Which of the following statements is TRUE of identifiers?

It is not necessary for a user to understand the data model. The IT department will handle any misunderstandings.

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

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

Which of the following is TRUE of a data model?

Explain the database development process.