Difference Between Field And Record In Database
Posted by catrinathomas
from the Human Interest category at
02 Sep 2022 04:25:41 pm.
Share this page: 
Data set Structure
Normal instances of a data set are a telephone directory, library index or the web search tool of a retail site. A data set is normally developed in a matrix like configuration with lines and sections. For instance, a phone directory triumphs ultimately a last name, first name, address and telephone number for every passage; those classes structure the "sections" of the information base. Every passage in the telephone directory has a remarkable distinguishing quality, which is the individual's name; each named section in the telephone directory shapes a line, which contains extraordinary information in every one of those four segments.
Data set Function
Data sets are coordinated by fields and records with the goal that they are effortlessly looked. To find a telephone number in the telephone directory, you basically need to find the individual's name, which is remarkable; when the individual's name is found, the right telephone number is viewed as in the "telephone number" segment of that equivalent line. Most data sets follow these fundamental getting sorted out and useful standards.
Field
In the telephone directory model, the four information classes of last name, first name, address and telephone number are designated "fields." A field is single unit of information that is special inside every section/line, yet the general information classification is normal to all passages. For example, "address" is a field that is normal to all named sections in the telephone directory; in any case, the substance of the location field will be one of a kind for each named passage. As a rule, an information base field alludes to the segments, or information classes, that are utilized by all sections/lines.
Record
A record is a line of an information base, an even gathering of fields; the substance of those fields is remarkable to that column. In the telephone directory model, each last name starts a record/line which contains information in the name, address and telephone number fields. A record is many times utilized in a data set search in light of the fact that each record has an exceptional, recognizing quality (or worth). A data set record is, essentially, a column that contains special information in every one of the fields. A data set will as a rule contain an enormous number of records yet just few fields.
0 Comments