differentiate between records, data and fields
Answers
Answer:
Differentiate between records, data, and fields
Explanation:
Data
Databases are organized according to fields and records so that they are easily searched. To find a phone number in the phone book, you simply have to locate the person's id, which is unique; once the person's id is located, the correct phone number is found in the "phone number" column of that same row. Most databases follow these basic organizing and functional principles.
Field
In the phone book example, the four data categories of the last name, first name, address, and phone number are called "fields." A field is a 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.
Record - a record is a row in a table that contains information about a given person product or an event
Field - a field is a column in a table that contains a specific piece of information within a record it is the smallest unit of data
Data - data specially refers to no. but can means words , sounds and images metadata is data about data it is used to find data
please mark me us brainliest✌✌ and follow me