Question

How fields and records are related with each other in a table? Explain with suitable example.​

Answer 1

$\huge\mathfrak\green{Holaa Mate}$

Field is a part of record and contains a single piece of data for the subject of a record.

Records is composed of a fields and contains all the data about one particular person.

$\huge\mathfrak\orange{Hope it helps}$

Answer 2

Fields are the inter related attributes of the same record in the table , thus the member of the fields in composite form makes a record.

EXAMPLE:

If BOOK is a relation then its member may be BOOK ID, Title, Author, Publisher, Price, etc . So if a person selects a book say <12, Computer Basics, Raj Kumar, 290,3>, then all the fields entries of this record is for the same Book.

HOPE U GOT IT.