Question 1

The ________ shows the number of entities that can be involved in a relationship.

Accepted Answer

A)  E-R 
B)  UML 
C)  data integrity 
D)  workflow 
E)  cardinality 
A)  E-R 
B)  UML 
C)  data integrity 
D)  workflow 
E)  cardinality

Question 2

A crow's foot diagram is a type of

Accepted Answer

A)  relationship map. 
B)  data model. 
C)  E-R diagram. 
D)  UML model. 
E)  normalization model. 
A)  relationship map. 
B)  data model. 
C)  E-R diagram. 
D)  UML model. 
E)  normalization model.

Question 3

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

Accepted Answer

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

Question 4

"Address" would be a likely attribute of a customer entity in a database application.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

A(n) ________ is a characteristic of an entity.

Accepted Answer

The answer of A(n) ________ is a characteristic of an...

Question 8

Describe how normalization works.

Accepted Answer

Normalization is the process o

Question 9

What are the different types of relationships represented in a data model? How are these captured by the use of keys?

Accepted Answer

There are four different types of relati

Question 10

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 11

Entities have a(an) ________, which is an attribute whose value is related to one and only one entity instance.

Accepted Answer

The answer of Entities have a(an) ________, which is an...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

________ form removes duplicate data and other problems from a table.

Accepted Answer

The answer of ________ form removes duplicate data and other...

Question 14

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

Accepted Answer

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

Question 15

On the many side of a relationship, you place the ________ of the ________ relationship to represent the relationships in the database.

Accepted Answer

A)  foreign key, one side 
B)  primary key, one side 
C)  index key, one side 
D)  primary key, many side 
E)  foreign key, many side 
A)  foreign key, one side 
B)  primary key, one side 
C)  index key, one side 
D)  primary key, many side 
E)  foreign key, many side

Question 16

A data model describes the data and relationships that will be stored in the database.

Accepted Answer

A) True 
 B)False

Question 17

There is (are) ________ style(s) of E-R diagrams.

Accepted Answer

A)  two 
B)  one 
C)  several 
D)  15 
E)  10 
A)  two 
B)  one 
C)  several 
D)  15 
E)  10

Question 18

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 19

Describe an E-R diagram.

Accepted Answer

An E-R diagram is a high level data mode

Question 20

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

Accepted Answer

The answer of In an E-R data model, the crow's...

The ________ shows the number of entities that can be involved in a relationship.

A crow's foot diagram is a type of

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

"Address" would be a likely attribute of a customer entity in a database application.

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

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

A(n) ________ is a characteristic of an entity.

Describe how normalization works.

What are the different types of relationships represented in a data model? How are these captured by the use of keys?

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

Entities have a(an) ________, which is an attribute whose value is related to one and only one entity instance.

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

________ form removes duplicate data and other problems from a table.

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

On the many side of a relationship, you place the of the relationship to represent the relationships in the database.

A data model describes the data and relationships that will be stored in the database.

There is (are) ________ style(s) of E-R diagrams.

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

Describe an E-R diagram.

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

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

The ________ shows the number of entities that can be involved in a relationship.

A crow's foot diagram is a type of

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

"Address" would be a likely attribute of a customer entity in a database application.

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

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

A(n) ________ is a characteristic of an entity.

Describe how normalization works.

What are the different types of relationships represented in a data model? How are these captured by the use of keys?

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

Entities have a(an) ________, which is an attribute whose value is related to one and only one entity instance.

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

________ form removes duplicate data and other problems from a table.

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

On the many side of a relationship, you place the ________ of the ________ relationship to represent the relationships in the database.

A data model describes the data and relationships that will be stored in the database.

There is (are) ________ style(s) of E-R diagrams.

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

Describe an E-R diagram.

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

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

On the many side of a relationship, you place the of the relationship to represent the relationships in the database.