CSC408_Chapter 5: Foundation of Business Intelligence

A row in a database.

• Record
• Field
• Entity
• Table

A column in a database.

• Field
• Record
• Entity
• Validation

A group of related records.

• Entity
• Validation
• Field
• Filter

A labeled element of a tuple, e.g. "Address" or "Date of birth" that describes a particular database entity is called

• row

• tuple

• attribute

• record

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

• The entity STUDENT with the attribute NAME

• The entity NAME with the attribute COURSE

• The entity NAME with the attribute STUDENT

• The entity COURSE with the attribute NAME

Identify all issues faced by traditional file environment.

• data inconsistency.

• poor security.

• lack of flexibility in creating ad-hoc reports.

• inability to develop specialized applications for functional areas.

It occurs when the same data is duplicated in multiple files of a database.

• Data independence

• Data discrepancy

• Data redundancy

• Data repetition

Data ________ occurs when the same attribute in related data files has different values?

• duplication

• redundancy

• inconsistency

• discrepancy

_________ is the fact that a traditional file system cannot respond to unanticipated information requirements in a timely fashion is an example of issues with traditional file systems.

• Poor security

• Program-data dependence

• Lack of data sharing

• Lack of flexibility

____________ is a feature of DBMS to avoid data redundancy and inconsistency.

• Ability to enforce referential integrity

• Ability to minimize isolated files with repeated data

• Ability to create two-dimensional tables

• Use of a data dictionary