Question 1

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

Accepted Answer

A)  Application development 
B)  Normalization 
C)  Structuring 
D)  Clarification 
E)  Conversion

Question 2

Tables are transformed into ________ to remove duplicate data and other problems.

Accepted Answer

A)  regular design 
B)  normalized design 
C)  regular form 
D)  normal form 
E)  relational form

Question 3

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

Question 4

In a relational database,each entity is described by

Accepted Answer

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

Question 5

Any mistake in the data modeling stage will come back to haunt you.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

Each entity should have one unique identifier.

Accepted Answer

A) True 
 B)False

Question 8

In a one-to-many relationship,the foreign key is stored in the table that is on the ________ side of the relationship.

Accepted Answer

A)  weak 
B)  many 
C)  many-to many 
D)  one 
E)  cardinal

Question 9

A person,place or object would be represented in a database application as a(n)

Accepted Answer

A)  entity. 
B)  record. 
C)  table. 
D)  class. 
E)  object.

Question 10

When a student can have more than one adviser it is a N:M relationship.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 answer of What are the different keys used for...

Question 14

An entity is something you want to track.

Accepted Answer

A) True 
 B)False

Question 15

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

Question 16

Users need to verify the data model for correctness.

Accepted Answer

A) True 
 B)False

Question 17

In an automobile table the ________ would make the best table key

Accepted Answer

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

Question 18

Normalization is a process that helps ensure that the tables from the database design process are well structured.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 15: Database Design and Entity Relationships

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

Tables are transformed into ________ to remove duplicate data and other problems.

Database developers ________ as the first step in development.

In a relational database,each entity is described by

Any mistake in the data modeling stage will come back to haunt you.

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

Each entity should have one unique identifier.

In a one-to-many relationship,the foreign key is stored in the table that is on the ________ side of the relationship.

A person,place or object would be represented in a database application as a(n)

When a student can have more than one adviser it is a N:M relationship.

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

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

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

An entity is something you want to track.

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

Users need to verify the data model for correctness.

In an automobile table the ________ would make the best table key

Normalization is a process that helps ensure that the tables from the database design process are well structured.

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

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