Question 1

The second step in creating a user view is to normalize the tables.

Accepted Answer

A) True 
 B)False

Question 2

A weak entity corresponds to the term ____________________.

Accepted Answer

The answer of A weak entity corresponds to the term...

Question 3

In the ____________________ design method,specific user requirements are synthesized into a design.

Accepted Answer

The answer of In the ____________________ design method,specific user requirements...

Question 4

The basic relationships among entities are: one-to-many,many-to-many,and one-to-one.

Accepted Answer

A) True 
 B)False

Question 5

Explain the difference between a minimum cardinality of zero and a minimum cardinality of one.

Accepted Answer

The answer of Explain the difference between a minimum cardinality...

Question 6

If a many-to-many-to-many relationship is created when it is not appropriate to do so,the conversion to ____ normal form will correct the problem.

Accepted Answer

A) first 
B) second 
C) third 
D) fourth

Question 7

One way to indicate a one-to-many relationship is to place a crow's foot at the ____________________ end of the relationship.

Accepted Answer

The answer of One way to indicate a one-to-many relationship...

Question 8

When you combine third normal form tables,the result will always be in third normal form.

Accepted Answer

A) True 
 B)False

Question 9

For each table in a database,you must identify the primary key and any alternate keys,secondary keys,and ____________________ keys.

Accepted Answer

The answer of For each table in a database,you must...

Question 10

An entity that does not require a relationship to another entity for identification is called a(n) ____.

Accepted Answer

A) alternative entity 
B) foreign entity 
C) independent entity 
D) single entity

Question 11

____ means that an entity has a minimum cardinality of zero.

Accepted Answer

A) The entity has a mandatory role in the relationship 
B) The entity is not required in the relationship 
C) The entity should not be in the relationship as an attribute 
D) The entity must be listed with all zeroes in the data fields

Question 12

The use of an "m" and an "n" in an E-R diagram indicates a many-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 13

A(n) ____ is a system-generated primary key that is usually hidden from users.

Accepted Answer

A) logical key 
B) surrogate key 
C) natural key 
D) artificial key

Question 14

The simplest way to implement a one-to-one relationship is to treat it as a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 15

In IDEF1X,the ____ is the symbol for category.

Accepted Answer

A) square 
B) rectangle 
C) diamond 
D) circle

Exam 6: Database Design 2: Design Method

The second step in creating a user view is to normalize the tables.

A weak entity corresponds to the term ____________________.

In the ____________________ design method,specific user requirements are synthesized into a design.

The basic relationships among entities are: one-to-many,many-to-many,and one-to-one.

Explain the difference between a minimum cardinality of zero and a minimum cardinality of one.

If a many-to-many-to-many relationship is created when it is not appropriate to do so,the conversion to ____ normal form will correct the problem.

One way to indicate a one-to-many relationship is to place a crow's foot at the ____________________ end of the relationship.

When you combine third normal form tables,the result will always be in third normal form.

For each table in a database,you must identify the primary key and any alternate keys,secondary keys,and ____________________ keys.

An entity that does not require a relationship to another entity for identification is called a(n) ____.

____ means that an entity has a minimum cardinality of zero.

The use of an "m" and an "n" in an E-R diagram indicates a many-to-many relationship.

A(n) ____ is a system-generated primary key that is usually hidden from users.

The simplest way to implement a one-to-one relationship is to treat it as a one-to-many relationship.

In IDEF1X,the ____ is the symbol for category.