HOW DATA BEING ORGANIZED??

In this world, there are billions of data presented..

With many of them, how can human classified and organized them??

To be easy, 

data is organized by the following groups :

• character
• field
• record
• table
• database

1. Character -  the most basic element.

A single letter, number, or special character, such as a punctuation mark or $. 
 

2. Field - a set of related characters
Each column of information within a record is called a field.
A field contains related information on a specific item like employee names within a company department.
 

 3. Record - a collection of related field

Each row of information in a database is a record.

Each record contains fields of data about some specific item, like employee name, address and phone, etc. 

A record represents a collection of attributes describing an entity.

4. Table - a collection of related table

5. Database - an integrated collection of related tables

 A collection of related information, like employee names, addresses and phone numbers.

It is organized in a way that a computer program can quickly select the desired pieces of information and display them for you.

 

KEYFIELD..

What is Keyfield?? 

Keyfield is the common field by which tables in a database are related to each other. 

This field uniquely identifies the record. 

For example in university databases, a key field is the social security number. 

Also known as Primary field or Primary key.