Question 1

What is a statement that defines an aspect of a business?

Accepted Answer

A)  Attribute
B)  Entity
C)  Business relational diagram
D)  Business ruleE) A) and B)
F) All of the above

Question 2

What kind of attribute would be given for a person who does not have an email address?

Accepted Answer

A)  Null-valued attribute
B)  Multi-valued attribute
C)  Single-valued attribute
D)  Stored attributeE) All of the above
F) B) and D)

Question 3

What 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)  One-to-one relationship
B)  One-to-many relationship
C)  Many-to-many relationship
D)  Composite entityE) A) and B)
F) A) and C) A

Question 4

What is a primary 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 records.E) B) and D)
F) B) and C)

Question 5

Which of the following is a possible business rule?

Accepted Answer

A)  A customer can purchase many DVDs
B)  DVDs can be purchased by many customers
C)  A DVD title can have many copies
D)  All of the aboveE) A) and B)
F) A) and C)

Question 6

What occurs between two entities in which an instance of one entity can be related to many instances of a related entity?

Accepted Answer

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

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) A) and C) D

Question 8

____________ expresses the specific number of instances in an entity.

Accepted Answer

The answer of ____________ expresses the specific number of instances...

Question 9

What occurs when two entities can be related to each other in many instances?

Accepted Answer

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

Question 10

A field is composed of rows and columns that represent an entity.

Accepted Answer

A) True 
 B)False

Question 11

What expresses the specific number of instances in an entity?

Accepted Answer

A)  Cardinality
B)  Composite entity
C)  Business rule
D)  Null-valued attributeE) All of the above
F) B) and C)

Question 12

A(n)____________ attribute can be calculated using the value of another attribute.

Accepted Answer

The answer of A(n)____________ attribute can be calculated using the...

Question 13

What kind of attribute can be calculated using the value of another attribute?

Accepted Answer

A)  Single-valued attribute
B)  Multi-valued attribute
C)  Derived attribute
D)  Stored attributeE) None of the above
F) B) and C)

Question 14

What is a characteristic of a table?

Accepted Answer

A)  Field
B)  Table
C)  Record
D)  KeyE) A) and D)
F) All of the above

Question 15

An ________________ diagram is a technique for documenting the entities and relationships in a database environment.

Accepted Answer

The answer of An ________________ diagram is a technique for...

Question 16

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

Accepted Answer

The answer of A _______________ relationship occurs between two entities...

Question 17

Date of birth would be a stored attribute.

Accepted Answer

A) True 
 B)False

Question 18

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) C) and D)
F) All of the above D

Question 19

What kind of attribute would be date of birth?

Accepted Answer

A)  Null-valued attribute
B)  Multi-valued attribute
C)  Derived attribute
D)  Stored attributeE) A) and D)
F) None of the above

Question 20

What kind of attribute would be age?

Accepted Answer

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

Exam 12: Designing Databases

What is a statement that defines an aspect of a business?

Correct AnswerverifiedShow Answer

What kind of attribute would be given for a person who does not have an email address?

Correct AnswerverifiedShow Answer

What occurs between two entities in which an instance of one entity can be related to only one instance of a related entity?

Correct AnswerverifiedA

What is a primary key?

Correct AnswerverifiedShow Answer

Which of the following is a possible business rule?

Correct AnswerverifiedShow Answer

What occurs between two entities in which an instance of one entity can be related to many instances 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 AnswerverifiedD

____________ expresses the specific number of instances in an entity.

Correct AnswerverifiedShow Answer

What occurs when two entities can be related to each other in many instances?

Correct AnswerverifiedShow Answer

A field is composed of rows and columns that represent an entity.

Correct AnswerverifiedShow Answer

What expresses the specific number of instances in an entity?

Correct AnswerverifiedShow Answer

A(n)____________ attribute can be calculated using the value of another attribute.

Correct AnswerverifiedShow Answer

What kind of attribute can be calculated using the value of another attribute?

Correct AnswerverifiedShow Answer

What is a characteristic of a table?

Correct AnswerverifiedShow Answer

An ________________ diagram is a technique for documenting the entities and relationships in a database environment.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Date of birth would be a stored attribute.

Correct AnswerverifiedShow Answer

What exists to represent the relationship between two other entities?

Correct AnswerverifiedD

What kind of attribute would be date of birth?

Correct AnswerverifiedShow Answer

What kind of attribute would be age?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified