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

Transforming a table into a normal form to remove duplicated data and other problems is called normalizing the table.

Accepted Answer

A) True 
 B)False

Question 3

A data model ________.

Accepted Answer

A)  is created after the database is designed 
B)  is an attribute whose value is associated with only one entity instance 
C)  is a logical representation of the structure of the data 
D)  does not describe the relationships among data 
A)  is created after the database is designed 
B)  is an attribute whose value is associated with only one entity instance 
C)  is a logical representation of the structure of the data 
D)  does not describe the relationships among data

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

N:M 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 6

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

Accepted Answer

A)  entities 
B)  data models 
C)  normal forms 
D)  attributes 
A)  entities 
B)  data models 
C)  normal forms 
D)  attributes

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

A database model can be transformed into a database design only after the users have approved and validated it.

Accepted Answer

A) True 
 B)False

Question 9

Explain the role of users in designing a database.

Accepted Answer

A database is a model of how the users v

Question 10

Normalization is the process of combining two or more poorly structured tables into a single structured table.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is a highly popular technique for creating a data model where the developers describe the content of a database by defining the things that will be stored in the database and the relationships among those entities?

Accepted Answer

A)  E-R model 
B)  UML model 
C)  Object-Role model 
D)  Three Schema model 
A)  E-R model 
B)  UML model 
C)  Object-Role model 
D)  Three Schema model

Question 12

Because normalized designs can be slower to process,database designers sometimes choose to accept non-normalized tables.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is true for data models?

Accepted Answer

A)  An identifier's value is associated with every entity in the data model. 
B)  An attribute is some thing that the users want to track. 
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)  An attribute is some thing that the users want to track. 
C)  Entities have attributes that describe characteristics of the entity. 
D)  The relationships between entities are known as attributes.

Question 14

Explain the difference between maximum and minimum cardinality.

Accepted Answer

Cardinality is the number of entities th

Question 15

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 16

The acronym UML refers to ________.

Accepted Answer

A)  unified markup language 
B)  unified modeling language 
C)  uniform markup language 
D)  uniform modeling language. 
A)  unified markup language 
B)  unified modeling language 
C)  uniform markup language 
D)  uniform modeling language.

Question 17

A database application consists of forms,reports,queries,and application programs.

Accepted Answer

A) True 
 B)False

Question 18

The little lines in an E-R diagram used as shorthand for the multiple lines between two entities are referred to as ________.

Accepted Answer

A)  a crow's foot 
B)  identifiers 
C)  attributes 
D)  a tracker 
A)  a crow's foot 
B)  identifiers 
C)  attributes 
D)  a tracker

Question 19

How is a data model transformed into a database design?

Accepted Answer

Database design is the process of conver

Question 20

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

Accepted Answer

A)  replication 
B)  duplication 
C)  actualization 
D)  normalization 
A)  replication 
B)  duplication 
C)  actualization 
D)  normalization

Exam 19: Database Design

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

Transforming a table into a normal form to remove duplicated data and other problems is called normalizing the table.

A data model ________.

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

N:M 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.

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

The easiest time to change the database structure is ________.

A database model can be transformed into a database design only after the users have approved and validated it.

Explain the role of users in designing a database.

Normalization is the process of combining two or more poorly structured tables into a single structured table.

Which of the following is a highly popular technique for creating a data model where the developers describe the content of a database by defining the things that will be stored in the database and the relationships among those entities?

Because normalized designs can be slower to process,database designers sometimes choose to accept non-normalized tables.

Which of the following is true for data models?

Explain the difference between maximum and minimum cardinality.

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

The acronym UML refers to ________.

A database application consists of forms,reports,queries,and application programs.

The little lines in an E-R diagram used as shorthand for the multiple lines between two entities are referred to as ________.

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

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