Blogpost #1

 Fields

A collection of related character. It is the smallest unit of information that has meaning to the user and can consist of one character.  Each field gives the value of some property (or attribute) of the entity represented by a record. For example, a personnel file may contain a series of records, one for each individual in the organization, and each record would contain fields that contain that person’s name, address, phone number, e-mail address, and so forth 

Records

A record is a collection of related fields. A student depending on the type of character the field will contain. It is a group of fields within a table that are relevant to a specific entity. For example, in a table called customer contact information, a row would likely contain fields such as: ID number, name, street address, city, telephone number and so on.

Files

A collection of records. Application creates files or modify existing ones to holds data which will later be processed into usable facts and figures. Generally, the records in a file are stored together for some common purpose. Files contain data and objects such as tables, indexes, stored procedures, and views. Log files contain the information that is required to recover all transactions in the database.

Master Files

A collection of records pertaining to one of the main subjects of an information system, such as customers, employees, products and vendors. Master files contain descriptive data, such as name and address, as well as summary information, such as amount due and year-to-date sales. It is contained relatively permanent data or historical status data. It represents a static view of some aspect of an organization at a specific point in time.