What is a table?
A single store of related information. A table consists of records, and each record is made up of a number of fields.
What is a record?
A table consists of records, and each record is made up of a number of fields. A record contains all the information about a single 'member' of a table. In a students table, each student's details (name, date of birth, contact details, and so on) will be contained in its own record.
What is a field?
Fields describe a single aspect of each member of a table. A student record, for instance, might contains a last name field, a first name field, a date of birth field and so on.
Let’s take the example of Student’s database in a School
What is a Key Field?
Keys are crucial to a table structure for many reasons, some of which are identified below:
They ensure that each record in a table is precisely identified.
They help establish and enforce various types of integrity.
They serve to establish table relationships.
Primary key will uniquely identify each record. It may or may not provide information about the record it identifies. It must not be Null-able, that is if it exists in a record it cannot have the value Null. It must be unique. It cannot be changed.
