Question 1

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

Accepted Answer

A)  File numbers 
B)  Descriptors 
C)  Titles 
D)  Identifiers 
A)  File numbers 
B)  Descriptors 
C)  Titles 
D)  Identifiers D

Question 2

Normalized tables eliminate ________.

Accepted Answer

A)  database design 
B)  data duplication 
C)  data entry 
D)  data conversion 
A)  database design 
B)  data duplication 
C)  data entry 
D)  data conversion B

Question 3

The ________ notation signifies that an adviser can be related to many students and that a student can be related to many advisers.

Accepted Answer

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

Question 4

An identifier is an attribute whose value is associated with only one entity instance.

Accepted Answer

A) True 
 B)False

Question 5

Maximum cardinality in an E-R diagram refers to ________.

Accepted Answer

A)  the maximum number of relationships possible in a diagram 
B)  the maximum number of entities that can be involved in a relationship 
C)  the maximum number of constraints possible for a particular relationship 
D)  the maximum number of attributes an entity can have 
A)  the maximum number of relationships possible in a diagram 
B)  the maximum number of entities that can be involved in a relationship 
C)  the maximum number of constraints possible for a particular relationship 
D)  the maximum number of attributes an entity can have

Question 6

Entities have ________ that describe the characteristics of the entities.

Accepted Answer

A)  attributes 
B)  data models 
C)  cardinalities 
D)  relationships 
A)  attributes 
B)  data models 
C)  cardinalities 
D)  relationships

Question 7

In a data model,the entity names are always plural.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

________ is an example of an attribute in the E-R model.

Accepted Answer

A)  Order 
B)  Salesperson 
C)  Order number 
D)  Customer 
A)  Order 
B)  Salesperson 
C)  Order number 
D)  Customer

Question 10

The general goal of normalization is to ________.

Accepted Answer

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

Question 11

Explain the database development process.

Accepted Answer

@#IMG-DLM& A database application consists of form

Question 12

The data model contains a description of the data.However,the model does not depict the relationships among the data.

Accepted Answer

A) True 
 B)False

Question 13

In a classroom,each student can have multiple advisers.In a data model,this can be best represented by which of the following notations?

Accepted Answer

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

Question 14

The UML model is the most popular tool for creating a data model.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

In E-R diagrams,the attributes are represented with crow's feet.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

Entities in a data model have relationsh

Question 18

Entities have relationships to attributes,but not to each other.

Accepted Answer

A) True 
 B)False

Question 19

Tables that are not normalized are subject to data integrity problems.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 19: Database Design

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

Normalized tables eliminate ________.

The ________ notation signifies that an adviser can be related to many students and that a student can be related to many advisers.

An identifier is an attribute whose value is associated with only one entity instance.

Maximum cardinality in an E-R diagram refers to ________.

Entities have ________ that describe the characteristics of the entities.

In a data model,the entity names are always plural.

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

________ is an example of an attribute in the E-R model.

The general goal of normalization is to ________.

Explain the database development process.

The data model contains a description of the data.However,the model does not depict the relationships among the data.

In a classroom,each student can have multiple advisers.In a data model,this can be best represented by which of the following notations?

The UML model is the most popular tool for creating a data model.

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

In E-R diagrams,the attributes are represented with crow's feet.

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

Entities have relationships to attributes,but not to each other.

Tables that are not normalized are subject to data integrity problems.

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

The Importance of MIS

Business Processes, Information, and Information Systems

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Database Processing

Data Communications

Business Process Management

E-Commerce, Web 2.0, and Social Networking

Business Intelligence and Information Systems for Decision Making

Information Systems Development

Information Systems Management

Information Security Management

Improving Your Collaboration Skills

Using Collaboration Information Systems

Information Systems and Decision Making

Knowledge Management and Expert Systems

Introduction to Microsoft Excel

Preparing a Computer Budget Using Excel

Using Microsoft Access 2010

Using Excel and Access Together

Remote, Nomadic, and Mobile Systems

Functional Processes, Applications, and Systems

Enterprise Resource Planning (ERP)Systems

Supply Chain Management

Processing Social Capital: Facebook, Twitter, and User-Generated Content (UGC)

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems

Business Process Management

Systems Development Project Management

Outsourcing

International MIS

Filters