Deck 12: Designing Databases

Question 1

What kind of attribute would be age?

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

Answer 1

C
Explanation: Age is a derived attribute from date of birth.

Question 2

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.

Answer 2

False
Explanation: 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 3

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

Answer 3

B
Explanation: This is the definition of multi-valued attribute.

Question 4

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

Question 5

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

Question 6

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

Question 7

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.

Question 8

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

Question 9

What kind of attribute would be date of birth?

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

Question 10

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

Question 11

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

Question 12

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

Question 13

Date of birth would be a stored attribute.

Question 14

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

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

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.

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

Question 22

What is a primary key?

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 23

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

Question 24

What is a characteristic of a table?

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

Question 25

What expresses the specific number of instances in an entity?

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

Question 26

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

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

Question 27

____________ expresses the specific number of instances in an entity.

Question 28

A typical business may have hundreds of business ____________.

Question 29

What exists to represent the relationship between two other entities?

A)One-to-one relationship
B)One-to-many relationship
C)Many-to-many relationship
D)Composite entity

Question 30

What is a foreign key?

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 31

What is a collection of related data elements?

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

Question 32

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