Question 1

In IDEF1X, _______________ categories are represented by two horizontal lines below the category symbol.

Accepted Answer

The answer of In IDEF1X, _______________ categories are represented by...

Question 2

List the types of information that must be included on a survey form in order for it to be considered valuable to the design process.

Accepted Answer

The answer of List the types of information that must...

Question 3

The information-level design methodology is completed independently of any particular DBMS that the organization will ultimately use.

Accepted Answer

A) True 
 B)False

Question 4

You can recognize entity subtypes by the fact the primary key is also a(n) ____________________.

Accepted Answer

The answer of You can recognize entity subtypes by the...

Question 5

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 6

In an entity-relationship diagram, rectangles represent foreign keys.

Accepted Answer

A) True 
 B)False

Question 7

When the user views are not clearly defined, you should consider each stated requirement as a separate user view.

Accepted Answer

A) True 
 B)False

Question 8

The E-R model (also called ERM) uses diagrams to represent the high-level abstract and conceptual representation of data, along with entities, attributes, and ____________________.

Accepted Answer

The answer of The E-R model (also called ERM) uses...

Question 9

What type of primary key is system-generated and is usually hidden from users?

Accepted Answer

A)  weak entity 
B)  surrogate key 
C)  natural key 
D)  artificial key

Question 10

You create a many-to-many relationship by creating a new table whose primary key is the combination of the primary keys of the original tables.

Accepted Answer

A) True 
 B)False

Question 11

What type of key is also called a logical key?

Accepted Answer

A)  surrogate 
B)  intelligent 
C)  secondary 
D)  synthetic

Question 12

A rectangle represents each _____________ in an E-R diagram.

Accepted Answer

The answer of A rectangle represents each _____________ in an...

Question 13

Which of the following is an example of an enforcing restriction?

Accepted Answer

A)  ensuring each row has a primary key 
B)  verifying there are no null values 
C)  verifying there is at least one secondary key in each table 
D)  ensuring values in foreign keys are legitimate

Question 14

A(n) ____________________ is a special value that represents the absence of a value in a field.

Accepted Answer

The answer of A(n) ____________________ is a special value that...

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

When combining third normal form tables, the resulting table will not be in third normal form when a column A in one user view determines a column B in a second user view, yet column A is not a column in the second user view.

Accepted Answer

A) True 
 B)False

Question 17

What is an existence dependency? Provide an example.

Accepted Answer

The answer of What is an existence dependency? Provide an...

Question 18

When determining the primary key of a table you must decide what properties are required to uniquely identify an entity.

Accepted Answer

A) True 
 B)False

Question 19

What does it mean when 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 zeros in the data fields.

Question 20

A design that supports all user views is called a constructive design.

Accepted Answer

A) True 
 B)False

Exam 6: Database Design 2: Design Method

In IDEF1X, _______________ categories are represented by two horizontal lines below the category symbol.

List the types of information that must be included on a survey form in order for it to be considered valuable to the design process.

The information-level design methodology is completed independently of any particular DBMS that the organization will ultimately use.

You can recognize entity subtypes by the fact the primary key is also a(n) ____________________.

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

In an entity-relationship diagram, rectangles represent foreign keys.

When the user views are not clearly defined, you should consider each stated requirement as a separate user view.

The E-R model (also called ERM) uses diagrams to represent the high-level abstract and conceptual representation of data, along with entities, attributes, and ____________________.

What type of primary key is system-generated and is usually hidden from users?

You create a many-to-many relationship by creating a new table whose primary key is the combination of the primary keys of the original tables.

What type of key is also called a logical key?

A rectangle represents each _____________ in an E-R diagram.

Which of the following is an example of an enforcing restriction?

A(n) ____________________ is a special value that represents the absence of a value in a field.

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

When combining third normal form tables, the resulting table will not be in third normal form when a column A in one user view determines a column B in a second user view, yet column A is not a column in the second user view.

What is an existence dependency? Provide an example.

When determining the primary key of a table you must decide what properties are required to uniquely identify an entity.

What does it mean when an entity has a minimum cardinality of zero?

A design that supports all user views is called a constructive design.