Question 1

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 2

Which of the following is TRUE of an entity-relationship (E-R) diagram?

Accepted Answer

A)  Each entity is shown in separate rectangles. 
B)  Many-to-many relationships are generally denoted by N:N. 
C)  A crow's foot represents a 1:N relationship between two entities. 
D)  Crow's foot is a shorthand representation for a single relationship between entities. 
A)  Each entity is shown in separate rectangles. 
B)  Many-to-many relationships are generally denoted by N:N. 
C)  A crow's foot represents a 1:N relationship between two entities. 
D)  Crow's foot is a shorthand representation for a single relationship between entities.

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

Jackie is a new database administer. She notices that many of the tables are poorly constructed. What should she do to create more well-structured tables?

Accepted Answer

A)  Jackie should delete the table and begin again. 
B)  Jackie should create a new database. 
C)  There is nothing Jackie can do; once the tables are created they are set. 
D)  Jackie should normalize the tables. 
A)  Jackie should delete the table and begin again. 
B)  Jackie should create a new database. 
C)  There is nothing Jackie can do; once the tables are created they are set. 
D)  Jackie should normalize the tables.

Question 6

The general goal of normalization is to ________.

Accepted Answer

A)  create a copy of an existing table 
B)  establish relationships among the entities in a table 
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)  establish relationships among the entities in a table 
C)  convert two or more tables into a single table 
D)  construct tables such that every table has a single topic

Question 7

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 8

Maximum cardinality in an entity-relationship (E-R) diagram refers to the maximum number of ________.

Accepted Answer

A)  normalizations possible in a diagram 
B)  entities that can be involved in a relationship 
C)  identifiers possible in a particular diagram 
D)  attributes associated with an entity 
A)  normalizations possible in a diagram 
B)  entities that can be involved in a relationship 
C)  identifiers possible in a particular diagram 
D)  attributes associated with an entity

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Tables that are not normalized can have data integrity problems.

Accepted Answer

A) True 
 B)False

Question 11

To represent an N:M relationship between two entities, two normalized tables are sufficient.

Accepted Answer

A) True 
 B)False

Question 12

Data integrity problems are not serious and can be easily fixed.

Accepted Answer

A) True 
 B)False

Question 13

Who should validate and approve the data model?

Accepted Answer

A)  the CIO 
B)  the IT staff 
C)  the users 
D)  managers 
A)  the CIO 
B)  the IT staff 
C)  the users 
D)  managers

Question 14

A database contains a description of both the data and the relationships among the data.

Accepted Answer

A) True 
 B)False

Question 15

In an entity relationship diagram, constraints on minimum requirements are called ________.

Accepted Answer

A)  crow's foot 
B)  identifier 
C)  least cardinality 
D)  minimum cardinality 
A)  crow's foot 
B)  identifier 
C)  least cardinality 
D)  minimum cardinality

Question 16

Which of the following is a highly popular technique for creating a data model with which the developers describe the content of a database by defining what is to be stored in the database and the associations among them?

Accepted Answer

A)  entity-relationship (E-R) data model 
B)  Unified Modeling Language (UML) 
C)  object-relational model 
D)  semantic data model 
A)  entity-relationship (E-R) data model 
B)  Unified Modeling Language (UML) 
C)  object-relational model 
D)  semantic data model

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Entities have attributes that describe characteristics of the entity.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

Entities in a data model have relationsh

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 17: Database Design

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

Which of the following is TRUE of an entity-relationship (E-R) diagram?

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

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

Jackie is a new database administer. She notices that many of the tables are poorly constructed. What should she do to create more well-structured tables?

The general goal of normalization is to ________.

The easiest time to change the database structure is ________.

Maximum cardinality in an entity-relationship (E-R) diagram refers to the maximum number of ________.

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

Tables that are not normalized can have data integrity problems.

To represent an N:M relationship between two entities, two normalized tables are sufficient.

Data integrity problems are not serious and can be easily fixed.

Who should validate and approve the data model?

A database contains a description of both the data and the relationships among the data.

In an entity relationship diagram, constraints on minimum requirements are called ________.

Which of the following is a highly popular technique for creating a data model with which the developers describe the content of a database by defining what is to be stored in the database and the associations among them?

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

Entities have attributes that describe characteristics of the entity.

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

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

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