Define the following terms: Database, Data Inconsistency, Primary Key, Candidate Key, Indexes

Q. Define the following terms:

 

(i) Database

(ii) Data Inconsistency

(iii) Primary Key

(iv) Candidate Key

(v) Indexes

Answer =

(i) Database is the collection of interrelated data stored together to serve multiple applications.

(ii) Data inconsistency is a situation where there are multiple tables within a database that deal with the same data but may receive it from different inputs.

(iii) A primary key is asset of one or more attributes that can uniquely tuples within the relation.

(iv) All attribute combinations inside a relation that can serve as primary key are Candidate key as they are candidates for the primary key position.

(v) An index is a data structure maintained by a database that helps it find record within a table more quickly. An index stored / ordered values within the index field and their location in the actual table.