Deck 17: Database Design

Question 1

A database contains a description of both the data and the relationships among the data.

Answer 1

False

Question 2

Which of the following statements is true of identifiers?

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.

Answer 2

D

Question 3

Which of the following notations signifies that an adviser can be related to many students and that a student can be related to many advisers?

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

Answer 3

B

Question 4

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

Question 5

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

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

Question 6

In an organization, the administrative department consists of one clerk whose sole responsibility is the management of various administrative functions.The notation that accurately indicates this relationship is ________.

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

Question 7

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

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 8

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

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

Question 9

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 ________.

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

Question 10

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

Question 11

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

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 12

Entities have relationships to attributes but not to each other.

Question 13

Which of the following is true of entities?

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.

Question 14

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

Question 15

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)________.

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

Question 16

Which of the following is true of a data model?

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 17

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?

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

Question 18

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

Question 19

Explain the database development process.

Question 20

Entities have attributes that describe characteristics of the entity.

Question 21

1:N means that more than one entity is allowed on each side of the relationship.

Question 22

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

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

Question 23

The general goal of normalization is to ________.

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 24

The maximum number of entities that can be involved in a relationship is known as maximum cardinality.

Question 25

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

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

Question 26

The crow's foot notation shows the minimum number of entities that can be involved in a relationship.

Question 27

Normalized tables eliminate ________.

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

Question 28

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.

Question 29

The general goal of normalization is to construct tables such that every table has a single topic or theme.

Question 30

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.

Question 31

Tables that are not normalized can have data integrity problems.

Question 32

What are the different types of relationships represented in a data model?

Question 33

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

Question 34

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

Question 35

Explain the difference between maximum and minimum cardinality.

Question 36

Database practitioners classify tables into various normal forms according to the kinds of problems they have.

Question 37

How is a data model transformed into a database design?

Question 38

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

Question 39

The process of converting poorly structured tables into two or more well-structured tables is referred to as ________.

A)replication
B)integration
C)actualization
D)normalization

Question 40

To represent an N:M relationship between two entities, two normalized tables are sufficient.

Question 41

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

Question 42

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

Question 43

The easiest time to change the database structure is ________.

A)during the data modeling stage
B)after constructing the database
C)during the database designing stage
D)after creating database reports

Question 44

Explain the role of users in designing a database.