Terminologies

Database
A collection of tables, that form an overall data structure.

Database Management System
A collection of tools, features, and interfaces that enable users to add, update, manage, access, analyze and also delete the content of a set of data.

Field
The smallest unit of named application data recognized by a system software.

First Normal Form
A relation in which the intersection of each row and column contains one and only one value.

Fully Dependency
A condition where a1 and a2 attributes of relation R. If a1 ->a2, then a2 is fully dependent a1.

Terminologies

Normalization
A technique for producing a set of relations with desirable properties, given the data requirements of an enterprise.

Second Normal Form
A relation that is in 1NF and every non key attribute is fully functional dependent on the key.

Table Processes
The relational database that is equivalent of a file.

Third Normal Form
A relation that is in first and second normal form and in which no non-key attribute is transitively dependent on the key.

Transitive Dependency
A condition where a1, a2 and a3 are attributes of relation R. If a1 ->a2 and a2-> a3, then a3 is transitively dependent on a1 via a2.