Fields vs Records

Summary: Differences between Fields and Records in a Database is that field is a mix of one or much more related personalities or bytes and is the the smallest unit of data a user accesses. A field name unique identifies every field. When searching for data in a database, you regularly specify the field name. While A record is a team of connected fields. For example, a college student record includes a collection of fields about one student. A primary key is a ar that uniquely identifies each document in a file. The data in a primary crucial is distinctive to a particular record.

You are watching: What is the difference between a record and a field?

*

Fields

A field is a mix of one or much more related characters or bytes and also is the the smallest unit that data a user accesses. A ar name unique identifies every field. When trying to find data in a database, you frequently specify the field name. Field names because that the data in the Instructor paper are Instructor ID, an initial Name, last Name, Extension, Office, and Web Address.

A database uses a selection of characteristics, such as ar size and also data type, to specify each field. The field size defines the maximum number of characters a ar can contain. Because that example, the Instructor identifier field consists of 6 characters and also thus has actually a ar size of 6.

Types of Data in a Field

*

The type of data in a ar is an important consideration. The picture to your appropriate identifies the data varieties for fields in the Instructor and also Student files. The data kind specifies the type of data a field can contain and also how the ar is used. Typical data species include:

Text (also dubbed alphanumeric) — letters, numbers, or distinct characters.Text (also dubbed alphanumeric) — letters, numbers, or one-of-a-kind charactersAutoNumber — distinct number instantly assigned by the DBMS to each included record.Currency — dollar and also cent amounts or numbers containing decimal values.Date (also referred to as date/time) — month, day, year, and also sometimes time.Memo — an extensive text entries.Yes/No — just the worths Yes or No (or True or False).Hyperlink — E-mail deal with or Web address that web links to a internet page ~ above the web or paper on a local network.Object — photo, audio, video, or a document created in other programs and also stored as a bitmap in the database.Attachment — record or picture that is attached come the field, which deserve to be opened in the regimen that developed the document or image (functioning likewise to e-mail attachments).

See more: Why Does Stainless Steel Turn Black, What Process Turns Stainless Steel Black

Records

A record is a team of associated fields. For example, a college student record has a collection of fields about one student. A primary vital is a field that uniquely identifies each document in a file. The data in a primary crucial is distinct to a particular record. For example, the college student ID ar uniquely identifies each student due to the fact that no 2 students have the right to have the exact same Student ID. In part tables, the primary an essential consists of lot of fields, referred to as a composite key. For example, the primary vital for the Schedule of Classes paper could covers the areas Semester Code, class Code, and also Class Section, which together would uniquely recognize each class provided in a schedule.