Question 1

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

Accepted Answer

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

Question 2

What occurs when two entities can be related to each other in many instances?
A)One-to-one relationship
B)One-to-many relationship
C)Many-to-many relationship
D)Composite entity

Accepted Answer

This is the definition of a many-to-many relationship.

Question 3

Which of the following statements is accurate?
A)A correct business rule for one organization may not be correct for another organization.
B)Each business rule will have entities and sometimes even attributes.
C)A typical business may have hundreds of business rules.
D)All of the above.

Accepted Answer

All of the above are accurate.

Question 4

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 one-to-one relationship occurs between two entities in which an instance of one entity can be related to only one instance of a related entity.

Question 5

What kind of attribute can be calculated using the value of another attribute?
A)Single-valued attribute
B)Multi-valued attribute
C)Derived attribute
D)Stored attribute

Accepted Answer

This is the definition of derived attribute.

Question 6

Which of the following is a possible business rule?
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 above

Accepted Answer

These are all business rules.

Question 7

A primary key is a field that uniquely identifies a given record in a table.

Accepted Answer

This is the definition of a primary key.

Question 8

Which of the following is a type of attribute?
A)Single-valued attribute
B)Multi-valued attribute
C)Null-valued attribute
D)All of the above

Accepted Answer

These are all types of attributes.

Question 9

What kind of attribute is assigned to an attribute when no other value applies or when a value is unknown?
A)Single-valued attribute
B)Multi-valued attribute
C)Derived attribute
D)Null-valued attribute

Accepted Answer

This is the definition of null-valued attribute.

Question 10

What is a statement that defines an aspect of a business?
A)Attribute
B)Entity
C)Business relational diagram
D)Business rule

Accepted Answer

This is the definition of business rule.

Question 11

What kind of attribute would be date of birth?
A)Null-valued attribute
B)Multi-valued attribute
C)Derived attribute
D)Stored attribute

Accepted Answer

Date of birth would be a stored attribute.

Question 12

What occurs between two entities in which an instance of one entity can be related to only one instance of a related entity?
A)One-to-one relationship
B)One-to-many relationship
C)Many-to-many relationship
D)Composite entity

Accepted Answer

This is the definition of a one-to-one relationship.

Question 13

What kind of attribute would be age?
A)Null-valued attribute
B)Multi-valued attribute
C)Derived attribute
D)Stored attribute

Accepted Answer

Age is a derived attribute from date of birth.

Question 14

What has only a single value of each attribute of an entity?
A)Single-valued attribute
B)Multi-valued attribute
C)Null-valued attribute
D)All of the above

Accepted Answer

This is the definition of single-valued attribute.

Question 15

Date of birth would be a stored attribute.

Accepted Answer

Date of birth would be a stored attribute.

Question 16

What occurs between two entities in which an instance of one entity can be related to many instances of a related entity?
A)One-to-one relationship
B)One-to-many relationship
C)Many-to-many relationship
D)Composite entity

Accepted Answer

This is the definition of a one-to-many relationship.

Question 17

What has the potential to contain more than one value for an attribute?
A)Single-valued attribute
B)Multi-valued attribute
C)Null-valued attribute
D)All of the above

Accepted Answer

This is the definition of multi-valued attribute.

Question 18

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

This is the definition of a foreign key.

Question 19

What is a technique for documenting the entities and relationships in a database environment?
A)Entity-relationship diagram
B)Data model
C)Database
D)Relational database model

Accepted Answer

This is the definition of entity-relationship diagram.

Question 20

What kind of attribute would be given for a person who does not have an email address?
A)Null-valued attribute
B)Multi-valued attribute
C)Single-valued attribute
D)Stored attribute

Accepted Answer

A null-valued attribute is provided when no other value applies or is unknown.

Quiz 12: Designing Databases

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

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

Which of the following statements is accurate?

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.

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

Which of the following is a possible business rule?

A primary key is a field that uniquely identifies a given record in a table.

Which of the following is a type of attribute?

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

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

What kind of attribute would be date of birth?

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

What kind of attribute would be age?

What has only a single value of each attribute of an entity?

Date of birth would be a stored attribute.

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

What has the potential to contain more than one value for an attribute?

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.

What is a technique for documenting the entities and relationships in a database environment?

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