Question 1

The little 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 A

Question 2

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

Accepted Answer

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

Question 3

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  False

Question 4

In an entity-relationship diagram,a vertical bar on a line indicates that at least one entity of that type is required in the relationship.

Accepted Answer

A) True 
 B)False

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

Tables that are not normalized can have data integrity problems.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

Explain the difference between maximum and minimum cardinality.

Accepted Answer

Cardinality is the number of entities th

Question 12

Entities have relationships to attributes but not to each other.

Accepted Answer

A) True 
 B)False

Question 13

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

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

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 18

Explain the database development process.

Accepted Answer

A database application consists of forms

Question 19

Entities have attributes that describe characteristics of the entity.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 17: Database Design

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

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

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

In an entity-relationship diagram,a vertical bar on a line indicates that at least one entity of that type is required in the relationship.

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

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

Tables that are not normalized can have data integrity problems.

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

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.

Explain the difference between maximum and minimum cardinality.

Entities have relationships to attributes but not to each other.

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

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?

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

Normalized tables eliminate ________.

The general goal of normalization is to ________.

Explain the database development process.

Entities have attributes that describe characteristics of the entity.

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

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 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 2013

Using Microsoft Access 2013

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

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters