Question 1

In an E -R data model,the crow's feet symbol is used to indicate the__________side of the relationship.

Accepted Answer

many

Question 2

Entities have___________ that describes characteristics of the entity.

Accepted Answer

A) names 
B) relations 
C) attributes 
D) properties 
E) files 
A) names 
B) relations 
C) attributes 
D) properties 
E) files C

Question 3

A(n)__________ diagram is like a blueprint of a database application.

Accepted Answer

A) O -R 
B) O -O 
C) workflow 
D) Entity -Relationship (E -R) 
E) flowchart 
A) O -R 
B) O -O 
C) workflow 
D) Entity -Relationship (E -R) 
E) flowchart D

Question 4

__________ Is the process of converting poorly structured tables into two or more well -structured tables.

Accepted Answer

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

Question 5

The foreign key is put on the_____side of a one -to -many relationship.

Accepted Answer

The answer of The foreign key is put on the_____side...

Question 6

A physical representation of a database is called a data model.

Accepted Answer

A) True 
 B)False

Question 7

What are the stages in developing a database application? At what point is it easiest to make changes?

Accepted Answer

Once a suitable application has been ide

Question 8

A(n)__________is an attribute or group of attributes whose value is associated with one and only one entity instance.

Accepted Answer

The answer of A(n)__________is an attribute or group of attributes...

Question 9

__________would be the best identifier attribute for an employee table.

Accepted Answer

A) Social Insurance number 
B) Birth Date 
C) First Name and Last Name 
D) Phone number 
E) Last Name 
A) Social Insurance number 
B) Birth Date 
C) First Name and Last Name 
D) Phone number 
E) Last Name

Question 10

Database developers__________as the first step in development.

Accepted Answer

A) create an E -R diagram 
B) create a relational model 
C) create a data model 
D) write queries 
E) interview users 
A) create an E -R diagram 
B) create a relational model 
C) create a data model 
D) write queries 
E) interview users

Question 11

At times you may not place a field in a table because it can be readily computed in forms or reports.

Accepted Answer

A) True 
 B)False

Question 12

What are the different keys used for in relational databases? How do they maintain the integrity of the information in the database applications?

Accepted Answer

The primary key is also known as the ide

Question 13

An example of a one -to -many type of relationship might be

Accepted Answer

A) an employee can be assigned more than one computer. 
B) an employee is assigned a company car. 
C) an employee cannot be assigned a computer. 
D) an employee can be assigned one and only one computer. 
E) an employee can be assigned an office. 
A) an employee can be assigned more than one computer. 
B) an employee is assigned a company car. 
C) an employee cannot be assigned a computer. 
D) an employee can be assigned one and only one computer. 
E) an employee can be assigned an office.

Question 14

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

Accepted Answer

A) Application development 
B) Clarification 
C) Structuring 
D) Normalization 
E) Conversion 
A) Application development 
B) Clarification 
C) Structuring 
D) Normalization 
E) Conversion

Question 15

__________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 the...

Question 16

In order to represent a(n)__________type of relationship,a third table is created using the keys from the two entities being related.

Accepted Answer

The answer of In order to represent a(n)__________type of relationship,a...

Question 17

__________is the notation used to describe a many -to -many relationship.

Accepted Answer

The answer of __________is the notation used to describe a...

Question 18

In a 1:N type of relationship,the foreign key is stored on the "1" side.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

In an E -R data model,the crow's feet symbol is used to indicate the__________side of the relationship.

Entities have___________ that describes characteristics of the entity.

A(n)__________ diagram is like a blueprint of a database application.

__________ Is the process of converting poorly structured tables into two or more well -structured tables.

The foreign key is put on the_____side of a one -to -many relationship.

A physical representation of a database is called a data model.

What are the stages in developing a database application? At what point is it easiest to make changes?

A(n)__________is an attribute or group of attributes whose value is associated with one and only one entity instance.

__________would be the best identifier attribute for an employee table.

Database developers__________as the first step in development.

At times you may not place a field in a table because it can be readily computed in forms or reports.

What are the different keys used for in relational databases? How do they maintain the integrity of the information in the database applications?

An example of a one -to -many type of relationship might be

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

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

In order to represent a(n)__________type of relationship,a third table is created using the keys from the two entities being related.

__________is the notation used to describe a many -to -many relationship.

In a 1:N type of relationship,the foreign key is stored on the "1" side.

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

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

Is in the Life of Business Professionals

Business Processes, Information, and Information Systems

Extensions S: Using Collaboration Information Systems

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Database Processing

Extensions B: Introduction to Microsoft Excel

Data Communications

Business Process Management

E-Commerce and Web 2.0

Business Intelligence and Information Systems for Decision Making

Information Systems Development

Extensions A: How the Internet Works

Information Systems Management

Information Security Management

Filters

Exam 5: Extensions A: Introduction to Microsoft Excel

In an E -R data model,the crow's feet symbol is used to indicate the__________side of the relationship.

Entities have___________ that describes characteristics of the entity.

A(n)__________ diagram is like a blueprint of a database application.

__________ Is the process of converting poorly structured tables into two or more well -structured tables.

The foreign key is put on the_____side of a one -to -many relationship.

A physical representation of a database is called a data model.

What are the stages in developing a database application? At what point is it easiest to make changes?

A(n)__________is an attribute or group of attributes whose value is associated with one and only one entity instance.

__________would be the best identifier attribute for an employee table.

Database developers__________as the first step in development.

At times you may not place a field in a table because it can be readily computed in forms or reports.

What are the different keys used for in relational databases? How do they maintain the integrity of the information in the database applications?

An example of a one -to -many type of relationship might be

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

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

In order to represent a(n)__________type of relationship,a third table is created using the keys from the two entities being related.

__________is the notation used to describe a many -to -many relationship.

In a 1:N type of relationship,the foreign key is stored on the "1" side.

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

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

Is in the Life of Business Professionals

Business Processes, Information, and Information Systems

Extensions S: Using Collaboration Information Systems

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Database Processing

Extensions B: Introduction to Microsoft Excel

Data Communications

Business Process Management

E-Commerce and Web 2.0

Business Intelligence and Information Systems for Decision Making

Information Systems Development

Extensions A: How the Internet Works

Information Systems Management

Information Security Management

Filters