Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Question 3

________ would be the best identifier attribute for an employee table.

Accepted Answer

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

Question 4

________ problems can occur when data is duplicated.

Accepted Answer

The answer of ________ problems can occur when data is...

Question 5

________ is the notation used to describe a many-to-many relationship.

Accepted Answer

The answer of ________ is the notation used to describe...

Question 6

Database developers ________ as the first step in development.

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

________ is the second most popular data modeling technique.

Accepted Answer

The answer of ________ is the second most popular data...

Question 9

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

Question 10

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

Accepted Answer

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

Question 11

A(n) ________ is something users want to track.

Accepted Answer

The answer of A(n) ________ is something users want to...

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

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

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 15

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

Question 16

When creating tables for an entity, the identifier of the entity becomes the ________ of the table.

Accepted Answer

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

Question 17

Users need to verify the data model for correctness.

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

Accepted Answer

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

Question 20

The most confusing type of a relationship is the ________ relationship.

Accepted Answer

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

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

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.

________ problems can occur when data is duplicated.

________ is the notation used to describe a many-to-many relationship.

Database developers ________ as the first step in development.

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

________ is the second most popular data modeling technique.

The foreign key is put on the ________ side of a one-to-many relationship.

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

A(n) ________ is something users want to track.

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

________ is the last step in developing a database application.

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

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

When creating tables for an entity, the identifier of the entity becomes the ________ of the table.

Users need to verify the data model for correctness.

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

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

The most confusing type of a relationship is 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 data model should summarize the data requirements as derived from interviews with the end users.

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.

________ problems can occur when data is duplicated.

________ is the notation used to describe a many-to-many relationship.

Database developers ________ as the first step in development.

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

________ is the second most popular data modeling technique.

The foreign key is put on the ________ side of a one-to-many relationship.

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

A(n) ________ is something users want to track.

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

________ is the last step in developing a database application.

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

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

When creating tables for an entity, the identifier of the entity becomes the ________ of the table.

Users need to verify the data model for correctness.

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

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

The most confusing type of a relationship is 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