MCQ Detailed View

In the structure of a database, a field is a single piece of information, such as a name, date of birth, or email address. When several related fields are grouped together, they form a record. A record represents a complete set of information about one entity or item.

For example, in a student database:

• 
  

  The fields could be Name, Roll Number, Class, and Email.

  
  


• 
  

  All these fields combined for one student make up a single record.

  
  

Records are stored as rows in a database table. Each row (record) contains values for all the fields defined in that table. Records make it easier to organize, access, and manage data.