Chapter 4, Problem 4.1RQ

Program Plan Intro

(a)

Definition of Determinant.

Explanation of Solution

Functional dependency is considered as a relationship between two attributes like in a primary key attribute and other non key attributes. In a functional dependency, the attribute on the left side of the arrow is called as determinant.

Program Plan Intro

(b)

Definition of Functional dependency.

Explanation of Solution

Functional dependency is considered as a relationship between the attributes like in a primary key attribute and other non key attributes. An attribute A is a functional dependent on a primary key attribute B if the value of B uniquely determines the value of A.

Program Plan Intro

(c)

Definition of Transitive Dependency.

Explanation of Solution

Transitive dependency is a functional dependency between the non key attributes and primary key where non-key attributes are dependent on primary key through another non-key attribute.

Program Plan Intro

(d)

Definition of Recursive Foreign Key.

Explanation of Solution

When the primary key values of the some relation are referenced by the foreign key of same relation, that foreign key is called as Recursive foreign key.

Program Plan Intro

(e)

Definition of Normalization.

Explanation of Solution

Normalization is the process that decomposes the anomalies relations to produce well-structured and smaller relations.

Program Plan Intro

(f)

Definition of Composite Key.

Explanation of Solution

Composite key is the combination of more than one attribute forming a primary key that uniquely identifies a record.

Program Plan Intro

(g)

Definition of Relation.

Explanation of Solution

In relational database, relation is referred as a table that contains set of tuples and it defines the relationship between the tables.

Program Plan Intro

(h)

Definition of Normal form.

Explanation of Solution

Normal form is the state of a relation that requires certain rules to be satisfied regarding the relationship between the attributes including their functional dependencies.

Program Plan Intro

(i)

Define partial functional dependency

Explanation of Solution

Partial functional dependency is a functional dependency where non-key attributes are dependent on part of the primary key.

Program Plan Intro

(j)

Definition of Enterprise Key.

Explanation of Solution

An Enterprise key is a primary key with unique value across the relations..

Program Plan Intro

(k)

Definition of Surrogate primary key.

Explanation of Solution

Surrogate primary key is the system generated key that does not have any business to uniquely identify a record.