Question

How are fields, record and a yr table related to each other? Explain with the help of example

Answer 1

Let us consider a sample table :

A                                 B                                  C

1                                   2                                  3 


Records are nothing but a single entry in a table.In the above example, 1,2,3 are called as records.


Each record can be broken into several entities known as fields.In the above example A, B, C are called as fields.


Hope this helps!