Lecture 4 Questions

Which of the following best illustrates the relationship between entities and attributes?

• The entity CUSTOMER with the attribute PRODUCT

• The entity CUSTOMER with the attribute PURCHASE

• The entity PRODUCT with the attribute PURCHASE

• The entity PRODUCT with the attribute CUSTOMER

• The entity PURCHASE with the attribute CUSTOMER

All of the following are issues with the traditional file environment except

• data inconsistency

• inability to develop specialized applications for functional areas

• lack of flexibility in creating ad-hoc reports

• poor security

• data sharing

A characteristic or quality that describes a particular database entity is called a(n):

• field

• tuple

• key field

• attribute

• relationship

A database ________ describes a database entity

• byte

• field

• record

• value

• file

________ creates confusion that hampers the creation of information systems that integrate data from different sources

• Batch processing

• Data redundancy

• Data independence

• Online processing

• Data quality

Data ________ occurs when the same data is duplicated in multiple files of a database

• redundancy

• repetition

• independence

• partitions

• discrepancy

Which of the following occurs when the same attribute in related data files has different values?

• Data redundancy

• Data duplication

• Data dependence

• Data discrepancy

• Data inconsistency

Which of the following is a grouping of characters into a word, a group of words, or a complete number?

• File

• Table

• Entity

• Field

• Tuple

The fact that a traditional file system cannot respond to unanticipated information requirements in a timely fashion is an example of which of the following issues with traditional file systems?

• Program-data dependence

• Lack of flexibility

• Poor security

• Lack of data sharing

• Data redundancy

Which common database challenge is illustrated by a person receiving multiple copies of an L.L. Bean catalog, each addressed to a slightly different variation of his or her full name?

• Data normalization

• Data accuracy

• Data redundancy

• Data inconsistency

• Data duplication