Question 1

When two rows in a database are supposed to refer to the same thing and they do not,you have a data integrity problem.

Accepted Answer

A) True 
 B)False

Question 2

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 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

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 7

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

Accepted Answer

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

Question 8

In E-R diagrams,entities are represented with rectangles.

Accepted Answer

A) True 
 B)False

Question 9

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

Question 10

________ is the process of converting poorly structured tables into two or more well-structured tables.

Accepted Answer

A)  Sharing 
B)  Reengineering 
C)  Normalization 
D)  Decentralization 
E)  Redesigning 
A)  Sharing 
B)  Reengineering 
C)  Normalization 
D)  Decentralization 
E)  Redesigning

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 13

Describe how normalization works.

Accepted Answer

Normalization is the process o

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

UML stands for

Accepted Answer

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

Question 18

Understanding how to interpret E-R diagrams will help you interpret ________ with a bit of study.

Accepted Answer

A)  flow diagrams 
B)  relational models 
C)  UML models 
D)  O-O models 
E)  workflow models 
A)  flow diagrams 
B)  relational models 
C)  UML models 
D)  O-O models 
E)  workflow models

Question 19

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 20

The user's review of the data model is

Accepted Answer

A)  done after the database is programmed 
B)  treated as a casual process 
C)  not necessary 
D)  not usually done 
E)  crucial 
A)  done after the database is programmed 
B)  treated as a casual process 
C)  not necessary 
D)  not usually done 
E)  crucial

When two rows in a database are supposed to refer to the same thing and they do not,you have a data integrity problem.

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

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

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

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

A crow's foot diagram is a type of

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

In E-R diagrams,entities are represented with rectangles.

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

________ is the process of converting poorly structured tables into two or more well-structured tables.

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

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

Describe how normalization works.

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

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

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

UML stands for

Understanding how to interpret E-R diagrams will help you interpret ________ with a bit of study.

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

The user's review of the data model is

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

When two rows in a database are supposed to refer to the same thing and they do not,you have a data integrity problem.

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

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

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

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

A crow's foot diagram is a type of

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

In E-R diagrams,entities are represented with rectangles.

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

________ is the process of converting poorly structured tables into two or more well-structured tables.

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

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

Describe how normalization works.

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

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

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

UML stands for

Understanding how to interpret E-R diagrams will help you interpret ________ with a bit of study.

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

The user's review of the data model is

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

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