Question 1

A(n)____ is a primary key that consists of a column that uniquely identifies an entity,such as a person's Social Security number.​

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

In the standard E-R diagrams,relationships are drawn as ____,with lines connecting the entities involved in relationships.​

Accepted Answer

A)   ​rectangles
B)   ​diamonds
C)   ​circles
D)   ​squares B

Question 4

A relationship that is necessary for identification is called a(n)____.​

Accepted Answer

A)   ​objectifying relationship
B)   ​merging relationship
C)   ​identifying relationship
D)   ​referential relationship

Question 5

A subtype is called a(n)____ in IDEF1X terminology.​

Accepted Answer

A)   ​dependent
B)   ​inner type
C)   ​specification
D)   ​category

Question 6

The information-level design methodology involves representing the individual user view as a collection of tables,refining them to eliminate any problems,and then merging them into a cumulative design.

Accepted Answer

A) True 
 B)False

Question 7

In a one-to-many relationship,the primary key of the "many" table becomes the foreign key of the "one" table.​

Accepted Answer

A) True 
 B)False

Question 8

____ means that an entity has a minimum cardinality of one.​

Accepted Answer

A)   ​The entity is required 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 ones in the data fields.

Question 9

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 10

An alternative to the primary key of a table is listed with the ____ abbreviation in DBDL.​

Accepted Answer

A)   ​SK
B)   ​FK
C)   ​PK
D)   ​AK

Question 11

The ____________________ design method begins with a general database design that models the overall enterprise and repeatedly refines the model to achieve a design that supports all necessary applications.​

Accepted Answer

The answer of The ____________________ design method begins with a...

Question 12

A weak entity is a column or collection of columns that could have been chosen as a primary key,but was not.​

Accepted Answer

A) True 
 B)False

Question 13

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

Question 14

Which of the following shows sample DBDL documentation for the Employee table?​

Accepted Answer

A)   ​Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode) 
B)   ​Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode) 
C)   ​Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode, (WageRate, SocSecNum, DepartmentNum)  ) 
D)   ​Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode, WageRate, SocSecNum, DepartmentNum) AK SocSecNumSK LastNameFK DepartmentNum→Department

Question 15

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 16

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

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

Accepted Answer

A) True 
 B)False

Question 18

​An entity that exists to implement a many-to-many relationship is called a(n)____.

Accepted Answer

A)   ​composite entity
B)   ​complex entity
C)   ​complicated entity
D)   ​circular entity

Question 19

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 20

​Careful planning in the early stages of the normalization process will usually avoid the need to consider fourth normal form.

Accepted Answer

A) True 
 B)False

Exam 6: Database Design 2: Design Method

A(n) ____ is a primary key that consists of a column that uniquely identifies an entity,such as a person's Social Security number.

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

In the standard E-R diagrams,relationships are drawn as ____,with lines connecting the entities involved in relationships.

A relationship that is necessary for identification is called a(n) ____.

A subtype is called a(n) ____ in IDEF1X terminology.

The information-level design methodology involves representing the individual user view as a collection of tables,refining them to eliminate any problems,and then merging them into a cumulative design.

In a one-to-many relationship,the primary key of the "many" table becomes the foreign key of the "one" table.

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

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

An alternative to the primary key of a table is listed with the ____ abbreviation in DBDL.

The ____________________ design method begins with a general database design that models the overall enterprise and repeatedly refines the model to achieve a design that supports all necessary applications.

A weak entity is a column or collection of columns that could have been chosen as a primary key,but was not.

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

Which of the following shows sample DBDL documentation for the Employee table?

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

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

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

An entity that exists to implement a many-to-many relationship is called a(n) ____.

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.

Careful planning in the early stages of the normalization process will usually avoid the need to consider fourth normal form.

Exam 6: Database Design 2: Design Method

A(n) ____ is a primary key that consists of a column that uniquely identifies an entity,such as a person's Social Security number.​

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

In the standard E-R diagrams,relationships are drawn as ____,with lines connecting the entities involved in relationships.​

A relationship that is necessary for identification is called a(n) ____.​

A subtype is called a(n) ____ in IDEF1X terminology.​

The information-level design methodology involves representing the individual user view as a collection of tables,refining them to eliminate any problems,and then merging them into a cumulative design.

In a one-to-many relationship,the primary key of the "many" table becomes the foreign key of the "one" table.​

____ means that an entity has a minimum cardinality of one.​

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

An alternative to the primary key of a table is listed with the ____ abbreviation in DBDL.​

The ____________________ design method begins with a general database design that models the overall enterprise and repeatedly refines the model to achieve a design that supports all necessary applications.​

A weak entity is a column or collection of columns that could have been chosen as a primary key,but was not.​

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

Which of the following shows sample DBDL documentation for the Employee table?​

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

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

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

​An entity that exists to implement a many-to-many relationship is called a(n) ____.

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

​Careful planning in the early stages of the normalization process will usually avoid the need to consider fourth normal form.

A(n) ____ is a primary key that consists of a column that uniquely identifies an entity,such as a person's Social Security number.

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

In the standard E-R diagrams,relationships are drawn as ____,with lines connecting the entities involved in relationships.

A relationship that is necessary for identification is called a(n) ____.

A subtype is called a(n) ____ in IDEF1X terminology.

In a one-to-many relationship,the primary key of the "many" table becomes the foreign key of the "one" table.

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

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

An alternative to the primary key of a table is listed with the ____ abbreviation in DBDL.

The ____________________ design method begins with a general database design that models the overall enterprise and repeatedly refines the model to achieve a design that supports all necessary applications.

A weak entity is a column or collection of columns that could have been chosen as a primary key,but was not.

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

Which of the following shows sample DBDL documentation for the Employee table?

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

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

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

An entity that exists to implement a many-to-many relationship is called a(n) ____.

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.

Careful planning in the early stages of the normalization process will usually avoid the need to consider fourth normal form.