Question 1

________ is the process of converting poorly structured tables into two or more well-structured tables.

Accepted Answer

A)  Sharing 
B)  Reengineering 
C)  Normalization 
D)  Decentralization 
E)  Redesigning 
A)  Sharing 
B)  Reengineering 
C)  Normalization 
D)  Decentralization 
E)  Redesigning C

Question 2

When a student can have more than one adviser, it is a N:M relationship.

Accepted Answer

A) True 
 B)False  True

Question 3

When two rows in a database are supposed to refer to the same thing and they do not, you have a data integrity problem.

Accepted Answer

A) True 
 B)False  True

Question 4

________ is (are) the most popular diagramming tool(s) for database applications.

Accepted Answer

A)  O-O 
B)  E-R diagrams 
C)  Flowcharts 
D)  Workflows 
E)  UML 
A)  O-O 
B)  E-R diagrams 
C)  Flowcharts 
D)  Workflows 
E)  UML

Question 5

In a one-to-many relationship, the foreign key is stored in the table that is on the ________ side of the relationship.

Accepted Answer

A)  weak 
B)  many 
C)  many-to many 
D)  one 
E)  cardinal 
A)  weak 
B)  many 
C)  many-to many 
D)  one 
E)  cardinal

Question 6

The easiest time to change a database design is during the data modelling stage.

Accepted Answer

A) True 
 B)False

Question 7

The number of entities that can be involved in a relationship in a data model is called the ________.

Accepted Answer

The answer of The number of entities that can be...

Question 8

An E-R data model captures both the entities involved and the ________ between the entities.

Accepted Answer

The answer of An E-R data model captures both the...

Question 9

In an automobile table, the ________ would make the best table key.

Accepted Answer

A)  model 
B)  a combination of make and model 
C)  make 
D)  license plate number 
E)  VIN 
A)  model 
B)  a combination of make and model 
C)  make 
D)  license plate number 
E)  VIN

Question 10

________ is a process for ensuring that the tables in a database design are efficient and well-structured.

Accepted Answer

The answer of ________ is a process for ensuring that...

Question 11

A N:M relationship is represented with a(n)

Accepted Answer

A)  intersection table. 
B)  entity. 
C)  composite table. 
D)  linking field. 
E)  index field. 
A)  intersection table. 
B)  entity. 
C)  composite table. 
D)  linking field. 
E)  index field.

Question 12

Data ________ problems make your database unreliable.

Accepted Answer

The answer of Data ________ problems make your database unreliable....

Question 13

The easiest time to change a database is during the ________ stage.

Accepted Answer

The answer of The easiest time to change a database...

Question 14

In E-R diagrams, entities are represented with rectangles.

Accepted Answer

A) True 
 B)False

Question 15

A crow's foot diagram is a type of ________.

Accepted Answer

The answer of A crow's foot diagram is a type...

Question 16

The user's review of the data model is

Accepted Answer

A)  done after the database is programmed 
B)  treated as a casual process 
C)  not necessary 
D)  not usually done 
E)  crucial 
A)  done after the database is programmed 
B)  treated as a casual process 
C)  not necessary 
D)  not usually done 
E)  crucial

Question 17

The easiest time to make changes to the database structure is during the ________ phase.

Accepted Answer

The answer of The easiest time to make changes to...

Question 18

UML stands for

Accepted Answer

A)  Unified Modeling Language. 
B)  Unified Metadata Language. 
C)  United Metadata Language. 
D)  Universal Metadata Language. 
E)  Universal Modeling Language. 
A)  Unified Modeling Language. 
B)  Unified Metadata Language. 
C)  United Metadata Language. 
D)  Universal Metadata Language. 
E)  Universal Modeling Language.

Question 19

Understanding how to interpret E-R diagrams will help you interpret ________ with a bit of study.

Accepted Answer

A)  flow diagrams 
B)  relational models 
C)  UML models 
D)  O-O models 
E)  workflow models 
A)  flow diagrams 
B)  relational models 
C)  UML models 
D)  O-O models 
E)  workflow models

Question 20

An entity is something you want to track.

Accepted Answer

A) True 
 B)False

________ is the process of converting poorly structured tables into two or more well-structured tables.

When a student can have more than one adviser, it is a N:M relationship.

When two rows in a database are supposed to refer to the same thing and they do not, you have a data integrity problem.

________ is (are) the most popular diagramming tool(s) for database applications.

In a one-to-many relationship, the foreign key is stored in the table that is on the ________ side of the relationship.

The easiest time to change a database design is during the data modelling stage.

The number of entities that can be involved in a relationship in a data model is called the ________.

An E-R data model captures both the entities involved and the ________ between the entities.

In an automobile table, the ________ would make the best table key.

________ is a process for ensuring that the tables in a database design are efficient and well-structured.

A N:M relationship is represented with a(n)

Data ________ problems make your database unreliable.

The easiest time to change a database is during the ________ stage.

In E-R diagrams, entities are represented with rectangles.

A crow's foot diagram is a type of ________.

The user's review of the data model is

The easiest time to make changes to the database structure is during the ________ phase.

UML stands for

Understanding how to interpret E-R diagrams will help you interpret ________ with a bit of study.

An entity is something you want to track.

Information Systems and You

Business Processes and Decision Making

Application Extension-Introduction to Business Process Modeling With Microsoft Visio

Productivity, Innovation, and Strategy

Application Extension-Introduction to Microsoft Excel 2013

Hardware and Software

Database and Content Management

Extension-Using Microsoft Access 2013

Networks and Collaboration

Competitive Advantage and Business Processes

Decision Making and Business Intelligence

E-commerce, Social Networking, and Web 20

Acquiring Information Systems Through Projects

Application Extension-Introduction to Microsoft Project

Structure, Governance, and Ethics

Managing Information Security and Privacy

Filters

Exam 9: Extension-Database Design

________ is the process of converting poorly structured tables into two or more well-structured tables.

When a student can have more than one adviser, it is a N:M relationship.

When two rows in a database are supposed to refer to the same thing and they do not, you have a data integrity problem.

________ is (are) the most popular diagramming tool(s) for database applications.

In a one-to-many relationship, the foreign key is stored in the table that is on the ________ side of the relationship.

The easiest time to change a database design is during the data modelling stage.

The number of entities that can be involved in a relationship in a data model is called the ________.

An E-R data model captures both the entities involved and the ________ between the entities.

In an automobile table, the ________ would make the best table key.

________ is a process for ensuring that the tables in a database design are efficient and well-structured.

A N:M relationship is represented with a(n)

Data ________ problems make your database unreliable.

The easiest time to change a database is during the ________ stage.

In E-R diagrams, entities are represented with rectangles.

A crow's foot diagram is a type of ________.

The user's review of the data model is

The easiest time to make changes to the database structure is during the ________ phase.

UML stands for

Understanding how to interpret E-R diagrams will help you interpret ________ with a bit of study.

An entity is something you want to track.

Information Systems and You

Business Processes and Decision Making

Application Extension-Introduction to Business Process Modeling With Microsoft Visio

Productivity, Innovation, and Strategy

Application Extension-Introduction to Microsoft Excel 2013

Hardware and Software

Database and Content Management

Extension-Using Microsoft Access 2013

Networks and Collaboration

Competitive Advantage and Business Processes

Decision Making and Business Intelligence

E-commerce, Social Networking, and Web 20

Acquiring Information Systems Through Projects

Application Extension-Introduction to Microsoft Project

Structure, Governance, and Ethics

Managing Information Security and Privacy

Filters