FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Enforce referential integrity. The purpose of referential integrity is to prevent orphan records – records that reference other records that no longer exist.

Detailed explanation-2: -Data redundancy ensures that the data contained in the database is accurate and reliable. Small slices of a data mart are called data warehouses. A group of related records is called a table.

Detailed explanation-3: -File-a group of related records. Files are frequently classified by the application for which they are primarily used (employee file). A primary key in a file is the field (or fields) whose value identifies a record among others in a data file.

Detailed explanation-4: -This is the correct answer because data integrity is associated with the accuracy and reliability of data held in the databases. Data integrity is related to the accurateness, reliability, completeness, and consistency of data, and hence integrity is the correct answer.

Detailed explanation-5: -A collection of related data is called Database. A database is a data structure that stores organized information. Most databases contain multiple tables, which may each include several different fields.