Monday 2 July 2012

RELATIONSHIP BETWEEN FIELD, RECORD AND FILE

FIELD
Field is a specific category of information in a table. In a table, fields are usually shown in columns and it has its own field name at the top.

 
For example, StudentID, Name, MyKad Number, Date of Birth, Gender,
Address and Contact Number. All the data within the same field holds the same data type.


For example, StudentID, Name, Gender, Address and ContactNumber use text as data type.
MyKad Number uses number as data type.
Date Of Birth uses date as data type.
Several fields make up a record.

RECORD
Record is a collection of fields about one person, place or thing in a table.
Records are arranged in rows.


A record is also known as the row or tuple.
For example, we have a total of five records in this table.

FILE
A file is a set of data arranged in columns and rows. They are grouped together for a specific purpose. For example, this is a Student Registration System which records all the students’ information.
To form a file, the file must have fields and records. A file is sometimes called a table or relation.For example, a Book file and a Student file.


0 comments:

Post a Comment