Question 1

How is a data model transformed into a database design?

Accepted Answer

Database design is the process of conver

Question 2

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 3

Entities have relationships to attributes but not to each other.

Accepted Answer

A) True 
 B)False

Question 4

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 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

According to the kinds of problems they have, database practitioners classify tables into various ________.

Accepted Answer

A)  solved forms 
B)  cardinalities 
C)  normal forms 
D)  relationships 
A)  solved forms 
B)  cardinalities 
C)  normal forms 
D)  relationships

Question 8

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

Accepted Answer

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

Question 9

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?

Accepted Answer

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

Question 10

Explain the difference between maximum and minimum cardinality.

Accepted Answer

Cardinality is the number of entities th

Question 11

Explain the role of users in designing a database.

Accepted Answer

A database is a model of how the users v

Exam 17: Database Design

How is a data model transformed into a database design?

Normalized tables eliminate ________.

Entities have relationships to attributes but not to each other.

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

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

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

According to the kinds of problems they have, database practitioners classify tables into various ________.

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

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?

Explain the difference between maximum and minimum cardinality.

Explain the role of users in designing a database.

The Importance of Mis

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Processes, 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, Problem Solving, and Project Management

Collaborative Information Systems for Student Projects

Mobile Systems

Introduction to Microsoft Excel 2016

Using Microsoft Access 2016

Using Excel and Access Together

Network and Cloud Technology

Enterprise Resource Planning Erp Systems

Supply Chain Management

Enterprise Social Networks and Knowledge Management

Database Marketing

Reporting Systems and Olap

Artificial Intelligence and Automation

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters