Question 1

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

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

Describe an E-R diagram.

Accepted Answer

An E-R diagram is a high level data model of a database that list the following components:
1.Entities and their attributes including the potential primary keys of the entity
2.The relationships between the entities and their cardinalities

Question 4

A 1:N relationship relates ________ record(s)to ________ record(s )in a database.

Accepted Answer

A)  many, one 
B)  one, three 
C)  one, one 
D)  many, many 
E)  one, many 
A)  many, one 
B)  one, three 
C)  one, one 
D)  many, many 
E)  one, many

Question 5

________ 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 6

The Object-Relationship (OR)technique is the most popular one for creating a data model.

Accepted Answer

A) True 
 B)False

Question 7

Entities have an ________ which is an attribute whose value is associated with one and only one entity instance.

Accepted Answer

A)  index 
B)  agenda 
C)  attribute 
D)  initial 
E)  identifier 
A)  index 
B)  agenda 
C)  attribute 
D)  initial 
E)  identifier

Question 8

If the same data element is stored differently in another table,this is said to be an issue of

Accepted Answer

A)  inaccurate data. 
B)  entity integrity. 
C)  data repetition. 
D)  normalization. 
E)  data integrity. 
A)  inaccurate data. 
B)  entity integrity. 
C)  data repetition. 
D)  normalization. 
E)  data integrity.

Question 9

________ is the last step in developing a database application.

Accepted Answer

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

Question 10

"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 11

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

Accepted Answer

A) True 
 B)False

Question 12

________ is used to indicate a many-to-many relationship.

Accepted Answer

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

Question 13

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 14

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 15

"Name" would be a good identifier for a customer entity in a database application.

Accepted Answer

A) True 
 B)False

Question 16

Entities have ________ that describes characteristics of the entity.

Accepted Answer

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

Question 17

In E-R diagrams,attributes can be represented with crow's feet.

Accepted Answer

A) True 
 B)False

Question 18

A data model should show how users see their "world".

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

Accepted Answer

A) True 
 B)False

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

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

Describe an E-R diagram.

A 1:N relationship relates record(s)to record(s )in a database.

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

The Object-Relationship (OR)technique is the most popular one for creating a data model.

Entities have an ________ which is an attribute whose value is associated with one and only one entity instance.

If the same data element is stored differently in another table,this is said to be an issue of

________ is the last step in developing a database application.

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

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

________ is used to indicate a many-to-many relationship.

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

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

"Name" would be a good identifier for a customer entity in a database application.

Entities have ________ that describes characteristics of the entity.

In E-R diagrams,attributes can be represented with crow's feet.

A data model should show how users see their "world".

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

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

Information Systems and You

Business Process Management and Decision Making

Productivity, innovation and Strategy

Hardware and Software

Database and Content Management

Networks and Collaboration

Competitive Advantage and Business Proces

Decision Making and Business Intelligence

E-Commerce, social Networking and Web 2.0

Acquiring Information Systems Through Projects

Structure, governance and Ethics

Managing Information Security and Privacy

Business Process Modeling: Techniques, Rules, and Applications

Excel Basics: Understanding Spreadsheets, Cells, and Formulas

Creating and Utilizing Forms, Queries, and Reports in MS Access

Understanding MS Project: Features and Functions

Filters

Exam 15: Database Design and Entity Relationships

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

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

Describe an E-R diagram.

A 1:N relationship relates ________ record(s)to ________ record(s )in a database.

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

The Object-Relationship (OR)technique is the most popular one for creating a data model.

Entities have an ________ which is an attribute whose value is associated with one and only one entity instance.

If the same data element is stored differently in another table,this is said to be an issue of

________ is the last step in developing a database application.

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

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

________ is used to indicate a many-to-many relationship.

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

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

"Name" would be a good identifier for a customer entity in a database application.

Entities have ________ that describes characteristics of the entity.

In E-R diagrams,attributes can be represented with crow's feet.

A data model should show how users see their "world".

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

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

Information Systems and You

Business Process Management and Decision Making

Productivity, innovation and Strategy

Hardware and Software

Database and Content Management

Networks and Collaboration

Competitive Advantage and Business Proces

Decision Making and Business Intelligence

E-Commerce, social Networking and Web 2.0

Acquiring Information Systems Through Projects

Structure, governance and Ethics

Managing Information Security and Privacy

Business Process Modeling: Techniques, Rules, and Applications

Excel Basics: Understanding Spreadsheets, Cells, and Formulas

Creating and Utilizing Forms, Queries, and Reports in MS Access

Understanding MS Project: Features and Functions

Filters

A 1:N relationship relates record(s)to record(s )in a database.