Question 1

Once the entities have been defined,the data model can be implemented directly on the DBMS.

Accepted Answer

A) True 
 B)False

Question 2

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 3

__________ is the last step in developing a database application.

Accepted Answer

A) Creating a data model 
B) Reviewing the data model with users 
C) Getting the information requirements 
D) Creating the database tables in the DBMS 
E) Designing the tables with the keys 
A) Creating a data model 
B) Reviewing the data model with users 
C) Getting the information requirements 
D) Creating the database tables in the DBMS 
E) Designing the tables with the keys

Question 4

The cardinality of the relationship between a employer and its employees is

Accepted Answer

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

Question 5

The data model should summarize the data requirements as derived from interviews with the end users.

Accepted Answer

A) True 
 B)False

Question 6

__________form removes duplicate data and other problems from a table.

Accepted Answer

The answer of __________form removes duplicate data and other problems...

Question 7

Normalization is a process that helps ensure that the tables from the database design process are well structured.

Accepted Answer

A) True 
 B)False

Question 8

A column whose value uniquely identifies a specific row in a table is known as the

Accepted Answer

A) foreign key. 
B) index attribute. 
C) identifier. 
D) key attribute. 
E) index field. 
A) foreign key. 
B) index attribute. 
C) identifier. 
D) key attribute. 
E) index field.

Question 9

If a student is allowed to have multiple majors and advisers are assigned to multiple students,these would be examples of ____________ relationships.

Accepted Answer

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

Question 10

Describe an E -R diagram.

Accepted Answer

An E -R diagram is a high level data mod

Question 11

Normalization is a trade -off between the elimination of data duplication and processing speed.

Accepted Answer

A) True 
 B)False

Question 12

A person,place or object would be represented in a database application as a(n)

Accepted Answer

A) class. 
B) record. 
C) table. 
D) object. 
E) entity. 
A) class. 
B) record. 
C) table. 
D) object. 
E) entity.

Question 13

A(n)__________is a characteristic of an entity.

Accepted Answer

The answer of A(n)__________is a characteristic of an entity....

Question 14

Users validate and approve the data model prior to its transformation into a database design.

Accepted Answer

A) True 
 B)False

Question 15

Tables are transformed into__________  to remove duplicate data and other problems.

Accepted Answer

A) normalized design 
B) relational form 
C) normal form 
D) regular design 
E) regular form 
A) normalized design 
B) relational form 
C) normal form 
D) regular design 
E) regular form

Question 16

Any mistake in the data modeling stage will come back to haunt you.

Accepted Answer

A) True 
 B)False

Question 17

A crow's foot diagram is a type of__________ .

Accepted Answer

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

Question 18

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) one 
C) many -to many 
D) cardinal 
E) many 
A) weak 
B) one 
C) many -to many 
D) cardinal 
E) many

Question 19

When you place data into a database you need to place (the)___________records first.

Accepted Answer

A) indexed 
B) first 
C) foreign key 
D) any 
E) primary key 
A) indexed 
B) first 
C) foreign key 
D) any 
E) primary key

Question 20

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

Once the entities have been defined,the data model can be implemented directly on the DBMS.

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

__________ is the last step in developing a database application.

The cardinality of the relationship between a employer and its employees is

The data model should summarize the data requirements as derived from interviews with the end users.

__________form removes duplicate data and other problems from a table.

Normalization is a process that helps ensure that the tables from the database design process are well structured.

A column whose value uniquely identifies a specific row in a table is known as the

If a student is allowed to have multiple majors and advisers are assigned to multiple students,these would be examples of ____________ relationships.

Describe an E -R diagram.

Normalization is a trade -off between the elimination of data duplication and processing speed.

A person,place or object would be represented in a database application as a(n)

A(n)__________is a characteristic of an entity.

Users validate and approve the data model prior to its transformation into a database design.

Tables are transformed into__________ to remove duplicate data and other problems.

Any mistake in the data modeling stage will come back to haunt you.

A crow's foot diagram is a type of__________ .

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

When you place data into a database you need to place (the)___________records first.

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

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

Once the entities have been defined,the data model can be implemented directly on the DBMS.

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

__________ is the last step in developing a database application.

The cardinality of the relationship between a employer and its employees is

The data model should summarize the data requirements as derived from interviews with the end users.

__________form removes duplicate data and other problems from a table.

Normalization is a process that helps ensure that the tables from the database design process are well structured.

A column whose value uniquely identifies a specific row in a table is known as the

If a student is allowed to have multiple majors and advisers are assigned to multiple students,these would be examples of ____________ relationships.

Describe an E -R diagram.

Normalization is a trade -off between the elimination of data duplication and processing speed.

A person,place or object would be represented in a database application as a(n)

A(n)__________is a characteristic of an entity.

Users validate and approve the data model prior to its transformation into a database design.

Tables are transformed into__________ to remove duplicate data and other problems.

Any mistake in the data modeling stage will come back to haunt you.

A crow's foot diagram is a type of__________ .

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

When you place data into a database you need to place (the)___________records first.

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

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