Fields vs Records

Summary: Differences between Fields and Records in a Database is that field is a combination of one or an ext related characters or bytes and is the smallest unit that data a user accesses. A ar name unique identifies each field. When looking for data in a database, you frequently specify the field name. While A record is a team of related fields. For example, a college student record consists of a set of fields about one student. A primary key is a ar that uniquely identifies each record in a file. The data in a primary crucial is distinct to a details record.

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

*

Fields

A field is a combination of one or an ext related personalities or bytes and also is the the smallest unit that data a user accesses. A field name uniquely identifies every field. When in search of data in a database, you frequently specify the field name. Ar names for the data in the Instructor document are Instructor ID, an initial Name, last Name, Extension, Office, and Web Address.

A database supplies a range of characteristics, together as ar size and also data type, to define each field. The ar size defines the maximum number of characters a ar can contain. For example, the Instructor id field includes 6 characters and thus has actually a ar size that 6.

Types of Data in a Field

*

The form of data in a ar is an essential consideration. The photo to your appropriate identifies the data types for areas in the Instructor and Student files. The data form specifies the sort of data a ar can contain and also how the ar is used. Usual data species include:

Text (also called alphanumeric) — letters, numbers, or special characters.Text (also dubbed alphanumeric) — letters, numbers, or special charactersAutoNumber — distinctive number immediately assigned by the DBMS to each included record.Currency — dollar and also cent quantities or numbers containing decimal values.Date (also called date/time) — month, day, year, and sometimes time.Memo — lengthy text entries.Yes/No — only the worths Yes or No (or True or False).Hyperlink — E-mail attend to or Web deal with that links to a net page on the web or paper on a regional network.Object — photo, audio, video, or a record created in various other programs and stored as a bitmap in the database.Attachment — file or photo that is attached come the field, which have the right to be opened up in the routine that created the file or image (functioning likewise to e-mail attachments).

See more: There Were Five Dollars Active Or Passive, Categorize Each Sentence Below As Using Either

Records

A document is a team of connected fields. For example, a student record includes a set of fields about one student. A primary vital is a ar that unique identifies each document in a file. The data in a primary crucial is distinctive to a details record. Because that example, the student ID ar uniquely identifies every student due to the fact that no two students deserve to have the exact same Student ID. In part tables, the primary crucial consists of multiple fields, called a composite key. Because that example, the primary vital for the Schedule the Classes record could consist of the fields Semester Code, course Code, and Class Section, which with each other would uniquely determine each class listed in a schedule.