Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

How is a data model transformed into a database design?

Accepted Answer

Database design is the process of conver

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Entities have relationships to attributes but not to each other.

Accepted Answer

A) True 
 B)False

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

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 10

Normalized tables eliminate ________.

Accepted Answer

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Entities have attributes that describe characteristics of the entity.

Accepted Answer

A) True 
 B)False

Question 14

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 15

Tables that are not normalized can have data integrity problems.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Which of the following statements is true of identifiers?

Accepted Answer

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

Explain the difference between maximum and minimum cardinality.

Accepted Answer

Cardinality is the number of entities th

Question 20

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

Exam 17: Database Design

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

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

How is a data model transformed into a database design?

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

Entities have relationships to attributes but not to each other.

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

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

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

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

Normalized tables eliminate ________.

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

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

Entities have attributes that describe characteristics of the entity.

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

Tables that are not normalized can have data integrity problems.

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

Which of the following statements is true of identifiers?

Explain the difference between maximum and minimum cardinality.

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

The Importance of Mis

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems

Hardware and Software

Database Processing

The Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Collaboration Information Systems for Decision Making

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 Erpsystems

Supply Chain Management

Enterprise Social Networks and Knowledge Management

Database Marketing

Reporting Systems and Olap

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters