Deck 16: Database Design

Question 1

Entities have ________ that describe the characteristics of the entities.

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

Answer 1

A

Question 2

In a classroom,each student can have multiple advisers.In a data model,this can be best represented by the ________.

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

Answer 2

C

Question 3

Maximum cardinality in an E-R diagram refers to ________.

A)the maximum number of relationships possible in a diagram
B)the maximum number of entities that can be involved in a relationship
C)the maximum number of constraints possible for a particular relationship
D)the maximum number of attributes an entity can have

Answer 3

B

Question 4

The ________ notation 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 5

The acronym UML refers to ________.

A)unified markup language
B)unified modeling language
C)uniform markup language
D)uniform modeling language

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

Question 7

The little lines in an E-R diagram used as shorthand for the multiple lines between two entities are referred to as a(n)________.

A)crow's foot
B)identifier
C)attribute
D)tracker

Question 8

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

Question 9

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

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

Question 10

The general goal of normalization is to ________.

A)create a copy of an existing table
B)construct tables such that every table has a similar topic
C)convert two or more tables into a single table
D)construct tables such that every table has a single topic

Question 11

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 12

The data integrity problem can occur only if ________.

A)data are duplicated
B)data are missing
C)data are replaced
D)data are redundant

Question 13

The easiest time to change the database structure is ________.

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

Question 14

Which of the following is a highly popular technique for creating a data model where the developers describe the content of a database by defining the things that will be stored in the database and the relationships among those entities?

A)E-R data model
B)UML model
C)object-role model
D)data integrity model

Question 15

Which of the following is true of entities?

A)An identifier's 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)Entities have attributes that describe characteristics of the entity.
D)The relationships between entities are known as attributes.

Question 16

Normalized tables eliminate ________.

A)data redundancy
B)data duplication
C)data entry
D)data conversion

Question 17

The first step to finding volunteers for a new drive is calling volunteers from previous drives.

Question 18

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

Question 19

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

A)entities
B)cardinalities
C)normal forms
D)attributes

Question 20

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

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

Question 21

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

Question 22

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

Question 23

Entities have attributes that describe characteristics of the entity.

Question 24

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

Question 25

A data model can be transformed into a database design only after the users have approved and validated it.

Question 26

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

Question 27

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

Question 28

How is a data model transformed into a database design?

Question 29

Entities have relationships to attributes,but not to each other.

Question 30

Tables that are not normalized are subject to data integrity problems.

Question 31

Explain the database development process.

Question 32

1: N means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

Question 33

Explain the difference between maximum and minimum cardinality.

Question 34

Normalization is the process of converting poorly structured tables into two or more well-structured tables.

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

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

Question 41

Explain the role of users in designing a database.