Deck 17: Database Design

Question 1

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

Answer 1

True

Question 2

Entities have attributes that describe characteristics of the entity.

Answer 2

True

Question 3

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

Answer 3

C

Question 4

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 5

Explain the database development process.

Question 6

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 7

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

Question 8

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

Question 9

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 10

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 11

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 12

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 13

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

Question 14

Entities have relationships to attributes but not to each other.

Question 15

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

Question 16

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 17

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.

Question 18

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 19

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

Question 20

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 21

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 22

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 23

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

Question 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

Normalized tables eliminate ________.

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

Question 29

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

Question 30

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

Question 31

Explain the difference between maximum and minimum cardinality.

Question 32

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

Question 33

How is a data model transformed into a database design?

Question 34

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

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

Question 35

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

Question 36

Tables that are not normalized can have data integrity problems.

Question 37

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 38

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 39

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

Question 40

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 41

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

Question 42

In an entity relationship diagram, constraints on minimum requirements are called ________.

A) crow's foot
B) identifier
C) least cardinality
D) minimum cardinality

Question 43

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

Question 44

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

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

Question 45

Entities have relationships with each other.

Question 46

Jackie is a new database administer. She notices that many of the tables are poorly constructed. What should she do to create more well-structured tables?

A) Jackie should delete the table and begin again.
B) Jackie should create a new database.
C) There is nothing Jackie can do; once the tables are created they are set.
D) Jackie should normalize the tables.

Question 47

Data integrity problems are not serious and can be easily fixed.

Question 48

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

Question 49

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 50

Who should validate and approve the data model?

A) the CIO
B) the IT staff
C) the users
D) managers

Question 51

Explain the role of users in designing a database.