Question 1

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 entity D

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

What is composed of rows and columns that represent an entity?

Accepted Answer

A)  Field
B)  Table
C)  Record
D)  Key B

Question 4

What kind of attribute would be age?

Accepted Answer

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

Question 5

What kind of attribute would be date of birth?

Accepted Answer

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

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 entity

Question 7

What is a collection of related data elements?

Accepted Answer

A)  Field
B)  Table
C)  Record
D)  Key

Question 8

Which of the following statements is accurate?

Accepted Answer

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.

Question 9

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 the above

Question 10

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.

Question 11

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 attribute

Question 12

What is a characteristic of a table?

Accepted Answer

A)  Field
B)  Table
C)  Record
D)  Key

Question 13

What expresses the specific number of instances in an entity?

Accepted Answer

A)  Cardinality
B)  Composite entity
C)  Business rule
D)  Null-valued attribute

Question 14

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

Accepted Answer

A)  Single-valued attribute
B)  Multi-valued attribute
C)  Null-valued attribute
D)  All of the above

Question 15

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 16

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

Question 17

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

Accepted Answer

A)  Entity-relationship diagram
B)  Data model
C)  Database
D)  Relational database model

Question 18

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

Accepted Answer

A)  Attribute
B)  Entity
C)  Business relational diagram
D)  Business rule

Question 19

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 attribute

Question 20

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 above

Exam 12: Designing Databases

What exists to represent the relationship between two other entities?

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

What is composed of rows and columns that represent an entity?

What kind of attribute would be age?

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 many instances of a related entity?

What is a collection of related data elements?

Which of the following statements is accurate?

Which of the following is a type of attribute?

What is a primary key?

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

What is a characteristic of a table?

What expresses the specific number of instances in an entity?

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

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 foreign key?

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

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

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

Which of the following is a possible business rule?