Question 1

What kind of attribute is date of birth?

Accepted Answer

A)   Null-valued attribute
B)   Multi-valued attribute
C)   Derived attribute
D)   Stored attributeE) A) and D)
F) C) and D)

Question 2

What is a foreign key?

Accepted Answer

A)   A field that uniquely identifies a given record in a table
B)   A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables
C)   A table that uniquely identifies a given record in a field
D)   A foreign key of one table that appears as an entity in another table and acts to provide a logical relationship between the two recordsE) All of the above
F) B) and D)

Question 3

Which of the following is a type of attribute?

Accepted Answer

A)   Single-valued attribute
B)   Multi-valued attribute
C)   Null-valued attribute
D)   All of these choicesE) A) and B)
F) None of the above

Question 4

What exists to represent the relationship between two other entities?

Accepted Answer

A)   One-to-one relationship
B)   One-to-many relationship
C)   Many-to-many relationship
D)   Composite entityE) B) and C)
F) All of the above

Question 5

A one-to-many relationship occurs between two entities in which an instance of one entity can be related to only one instance of a related entity.

Accepted Answer

A) True 
 B)False

Question 6

A foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Accepted Answer

A) True 
 B)False

Question 7

What kind of attribute is assigned to an attribute when no other value applies or when a value is unknown?

Accepted Answer

A)   Single-valued attribute
B)   Multi-valued attribute
C)   Derived attribute
D)   Null-valued attributeE) B) and C)
F) C) and D)

Exam 12: Database Design and Entity Relationships

What exists to represent the relationship between two other entities?

Correct Answer
verified

What kind of attribute is date of birth?

Correct Answer
verified

A foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Correct Answer
verified

What is a foreign key?

Correct Answer
verified

Which of the following is a type of attribute?

Correct Answer
verified

A one-to-many relationship occurs between two entities in which an instance of one entity can be related to only one instance of a related entity.

Correct Answer
verified

What kind of attribute is assigned to an attribute when no other value applies or when a value is unknown?

Correct Answer
verified

Exam 12: Database Design and Entity Relationships

What exists to represent the relationship between two other entities?

Correct AnswerverifiedShow Answer

What kind of attribute is date of birth?

Correct AnswerverifiedShow Answer

A foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Correct AnswerverifiedShow Answer

What is a foreign key?

Correct AnswerverifiedShow Answer

Which of the following is a type of attribute?

Correct AnswerverifiedShow Answer

A one-to-many relationship occurs between two entities in which an instance of one entity can be related to only one instance of a related entity.

Correct AnswerverifiedShow Answer

What kind of attribute is assigned to an attribute when no other value applies or when a value is unknown?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified