Records and Fields

In a database, a record is one complete entry, like all the stored information about a single customer or product, and a field is one specific labeled piece of information within that record, like a customer's name or a product's price, matching the general record-and-field idea used in programming. Databases add two ideas on top of that general concept: each field usually has a defined data type, like text or a number, that limits what kind of value it can hold, and many tables designate one field, or a small combination of fields, called a primary key, whose values uniquely identify each record so it can never be confused with another.

This explanation is AI-generated and can occasionally be wrong. 🚩 Report