Question 1

In an automobile table the__________  would make the best primary key

Accepted Answer

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

Question 2

E -R diagrams are too cumbersome for use in database design discussions.

Accepted Answer

A) True 
 B)False

Question 3

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

Question 4

Data _____ problems are serious.

Accepted Answer

The answer of Data _____ problems are serious....

Question 5

On difficulty with designing database is the __________number of possibilities of what to include.

Accepted Answer

A) small 
B) known 
C) minimal 
D) large 
E) fixed 
A) small 
B) known 
C) minimal 
D) large 
E) fixed

Question 6

The easiest time to change a database is during the__________stage.

Accepted Answer

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

Question 7

"One department can have many advisers" is an example of

Accepted Answer

A) a one -to -many relationship. 
B) maximum cardinality relationship. 
C) a many -to -many relationship. 
D) a minimum cardinality relationship. 
E) a one -to -one relationship. 
A) a one -to -many relationship. 
B) maximum cardinality relationship. 
C) a many -to -many relationship. 
D) a minimum cardinality relationship. 
E) a one -to -one relationship.

Question 8

A(n) __________data model captures the entities and their relationships in a database application.

Accepted Answer

A) O -O 
B) workflow 
C) E -R 
D) flowchart 
E) Semantic Object 
A) O -O 
B) workflow 
C) E -R 
D) flowchart 
E) Semantic Object

Question 9

Entities have_______with one another.

Accepted Answer

The answer of Entities have_______with one another....

Question 10

Each entity should have one unique identifier.

Accepted Answer

A) True 
 B)False

Question 11

A data model should show how users see their world.

Accepted Answer

A) True 
 B)False

Question 12

In a relational database,each entity is described by

Accepted Answer

A) attributes. 
B) characters. 
C) records. 
D) bytes. 
E) data. 
A) attributes. 
B) characters. 
C) records. 
D) bytes. 
E) data.

Question 13

__________ cardinality indicates the most entities that can be involved in a relationship.

Accepted Answer

The answer of __________ cardinality indicates the most entities that...

Question 14

"PartNumber" would be a good identifier for a part entity in a database application.

Accepted Answer

A) True 
 B)False

Question 15

Database practitioners classify tables into  various____________depending on the type of data integrity problems to which they might be subject.

Accepted Answer

A) strata 
B) categories 
C) types 
D) normal forms 
E) layers 
A) strata 
B) categories 
C) types 
D) normal forms 
E) layers

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

UML stands for

Accepted Answer

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

Question 19

The notation N:N indicates a many -to -many relationship.

Accepted Answer

A) True 
 B)False

Question 20

Describe how normalization works.

Accepted Answer

Normalization is the process o

In an automobile table the__________ would make the best primary key

E -R diagrams are too cumbersome for use in database design discussions.

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

Data _____ problems are serious.

On difficulty with designing database is the __________number of possibilities of what to include.

The easiest time to change a database is during the__________stage.

"One department can have many advisers" is an example of

A(n) __________data model captures the entities and their relationships in a database application.

Entities have_______with one another.

Each entity should have one unique identifier.

A data model should show how users see their world.

In a relational database,each entity is described by

__________ cardinality indicates the most entities that can be involved in a relationship.

"PartNumber" would be a good identifier for a part entity in a database application.

Database practitioners classify tables into various____________depending on the type of data integrity problems to which they might be subject.

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

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

UML stands for

The notation N:N indicates a many -to -many relationship.

Describe how normalization works.

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 automobile table the__________ would make the best primary key

E -R diagrams are too cumbersome for use in database design discussions.

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

Data _____ problems are serious.

On difficulty with designing database is the __________number of possibilities of what to include.

The easiest time to change a database is during the__________stage.

"One department can have many advisers" is an example of

A(n) __________data model captures the entities and their relationships in a database application.

Entities have_______with one another.

Each entity should have one unique identifier.

A data model should show how users see their world.

In a relational database,each entity is described by

__________ cardinality indicates the most entities that can be involved in a relationship.

"PartNumber" would be a good identifier for a part entity in a database application.

Database practitioners classify tables into various____________depending on the type of data integrity problems to which they might be subject.

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

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

UML stands for

The notation N:N indicates a many -to -many relationship.

Describe how normalization works.

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