define the following
Answers
Answer:
Field
In the phone book example, the four data categories of last name, first name, address and phone number are called "fields." A field is single unit of data that is unique within each entry/row, but the overall data category is common to all entries. For instance, "address" is a field that is common to all named entries in the phone book; however, the content of the address field will be unique for each named entry. As a guideline, a database field refers to the columns, or data categories, that are used by all entries/rows.
Record
A record is a row of a database, a horizontal grouping of fields; the content of those fields is unique to that row. In the phone book example, each last name begins a record/row which contains data in the name, address and phone number fields. A record is often used in a database search because each record has a unique, identifying quality (or value). A database record is, basically, a row that contains unique data in each of the fields. A database will usually contain a large number of records but only a small number of fields.
Fields and Records are two important part of a database.
■Fields■➹➷
In computer science, data has several parts which are known as records, further divided into fields. This term refers to "columns" or vertical categories of data. In other words, we can say that a field is aan area of a fixed location in a unit of data.
★Records★
It is a collection of fields of different data types , in fixed number and sequence.Moreover, it is held within the same structure. Specifically, we can say thata record is a grouping of fields within a tablethat reference a particular object.