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 
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 
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 
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 
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. 
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 
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 SocSecNum
SK LastName
FK DepartmentNum→Department 
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 SocSecNum
SK LastName
FK 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. 
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 
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 
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

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.

Introduction to Database Management

The Relational : Introduction, QBE, and Relational Algebra

The Relational : SQL

The Relational : Advanced Topics

Database Design 1: Normalization

Dbms Functions

Database Administration

Database Management Approaches

Filters

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.

Introduction to Database Management

The Relational : Introduction, QBE, and Relational Algebra

The Relational : SQL

The Relational : Advanced Topics

Database Design 1: Normalization

Dbms Functions

Database Administration

Database Management Approaches

Filters

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.