Question 1

Which of the following is true of entities?

Accepted Answer

A) An identifier's value is associated with every entity in the data model. 
B) Entities can only represent a logical construct or transaction,not a physical object. 
C) Entities have attributes that describe characteristics of the entity. 
D) The relationships between entities are known as attributes. 
A) An identifier's value is associated with every entity in the data model. 
B) Entities can only represent a logical construct or transaction,not a physical object. 
C) Entities have attributes that describe characteristics of the entity. 
D) The relationships between entities are known as attributes. C

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

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

How is a data model transformed into a database design?

Accepted Answer

Database design is the process of conver

Question 7

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 8

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

Accepted Answer

Entities in a data model have relationsh

Question 9

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 10

Explain the database development process.

Accepted Answer

A database application consists of forms

Question 11

In a classroom,each student can have multiple advisers.In a data model,this can be best represented by the ________.

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Question 14

1: N means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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:N 
B) N:M 
C) N:1 
D) N:N 
A) 1:N 
B) N:M 
C) N:1 
D) N:N

Question 18

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

Accepted Answer

A) entities 
B) cardinalities 
C) normal forms 
D) attributes 
A) entities 
B) cardinalities 
C) normal forms 
D) attributes

Question 19

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 data designing stage 
D) after creating the application programs 
A) during the data modeling stage 
B) after constructing the database 
C) during the data designing stage 
D) after creating the application programs

Question 20

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

Exam 16: Database Design

Which of the following is true of entities?

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

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

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

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

How is a data model transformed into a database design?

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

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

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

Explain the database development process.

In a classroom,each student can have multiple advisers.In a data model,this can be best represented by the ________.

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

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

1: N means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

The general goal of normalization is to ________.

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

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

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

The easiest time to change the database structure is ________.

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

The Importance of Mis

Business Processes information Systems and Information

Organizational Strategy information Systems and Competitive Advantage

Hardware and Software

Database Processing

Data Communication and the Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Development

Information Systems Management

Information Security Management

Collaboration Information Systems for Decision Making, Problem Solving, and Project Management

Collaborative Information Systems for Student Projects

Introduction to Microsoft Excel 2010

Using Microsoft Access 2010

Using Excel and Access Together

Mobile Systems

Functional Applications

Enterprise Resource Planning ERP systems

Supply Chain Management

Hyper-Social Organizations and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters