DEFINE THE FOLLOWING TERMS; 1)FILE; 2) RECORD; 3) FIELD
A file, record and a field are database terms used especially when dealing with tables.
What is a file
A file is a collection of records, database files organize the data into records and fields.
Further definition of a file;
What is a record?
A record is a collection of related fields that represent a single entity
What is a field?
A field is a character or a logical combination of characters that represent a single data item.
Definition of Normalization
Normalization is the process of organizing data in a database by establishing relationships between tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency, insertion anomaly, update anomaly & deletion anomaly.
Objectives of Normalization