Question 1

Tables that are not normalized can have data integrity problems.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

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

Question 5

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 6

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

Accepted Answer

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

Question 7

A vertical bar on a line representing a relationship indicates that there is a minimum requirement for the entity.

Accepted Answer

A) True 
 B)False

Question 8

Explain the role of users in designing a database.

Accepted Answer

A database is a model of how the users v

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is true of an E-R diagram?

Accepted Answer

A)  Every entity has an identifier. 
B)  Many-to-many relationships are generally denoted as N:N. 
C)  A crow's-foot is required to represent a 1:1 relationship. 
D)  Identifiers are shown in a section at the top of the entity. 
A)  Every entity has an identifier. 
B)  Many-to-many relationships are generally denoted as N:N. 
C)  A crow's-foot is required to represent a 1:1 relationship. 
D)  Identifiers are shown in a section at the top of the entity.

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is true of entities?

Accepted Answer

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' characteristics are described by attributes. 
D)  The relationships between entities are known as attributes. 
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' characteristics are described by attributes. 
D)  The relationships between entities are known as attributes.

Question 13

The easiest time to change the database structure is ________.

Accepted Answer

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

Question 14

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

Accepted Answer

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

Question 15

The little lines in an 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)  entity 
A)  crow's foot 
B)  identifier 
C)  attribute 
D)  entity

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

How is a data model transformed into a database design?

Accepted Answer

Database design is the process of conver

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

The general goal of normalization is to ________.

Accepted Answer

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

Exam 17: Database Design

Tables that are not normalized can have data integrity problems.

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

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

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

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

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

A vertical bar on a line representing a relationship indicates that there is a minimum requirement for the entity.

Explain the role of users in designing a database.

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

Which of the following is true of an E-R diagram?

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

Which of the following is true of entities?

The easiest time to change the database structure is ________.

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

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

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

How is a data model transformed into a database design?

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

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

The general goal of normalization is to ________.

The Importance of Mis

Business Processes information Systems and Information

Organizational Strategy information Systems and Competitive Advantage

Hardware and Software

Database Processing

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

Mobile Systems

Introduction to Microsoft Excel 2013

Using Microsoft Access 2013

Using Excel and Access Together

Network and Cloud Technology

Enterprise Resource Planning ERP Systems

Supply Chain Management

Hyper-Social Organizations and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems GIS

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters