Question 1

The data integrity problem can occur only if ________.

Accepted Answer

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

Question 2

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?

Accepted Answer

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

Question 3

Normalized tables eliminate ________.

Accepted Answer

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

Question 4

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

Accepted Answer

The first step in transforming a data mo

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Explain the difference between maximum and minimum cardinality.

Accepted Answer

Cardinality is the number of entities th

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Entities have attributes that describe characteristics of the entity.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

Entities have ________ that describe the characteristics of the entities.

Accepted Answer

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

Question 13

The acronym UML refers to ________.

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Explain the role of users in designing a database.

Accepted Answer

A database is a model of how the users v

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 16: Database Design

The data integrity problem can occur only if ________.

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?

Normalized tables eliminate ________.

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

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

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

Explain the difference between maximum and minimum cardinality.

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

Entities have attributes that describe characteristics of the entity.

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

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

Entities have ________ that describe the characteristics of the entities.

The acronym UML refers to ________.

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

Which of the following is true of a data model?

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

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

Explain the role of users in designing a database.

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

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

The Importance of Mis

Business Processes information Systems and Information

Organizational Strategy information Systems and Competitive Advantage

Hardware and Software

Database Processing

Data Communication and the Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Development

Information Systems Management

Information Security Management

Collaboration Information Systems for Decision Making, Problem Solving, and Project Management

Collaborative Information Systems for Student Projects

Introduction to Microsoft Excel 2010

Using Microsoft Access 2010

Using Excel and Access Together

Mobile Systems

Functional Applications

Enterprise Resource Planning ERP systems

Supply Chain Management

Hyper-Social Organizations and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters