Basic File Terminology

Database Systems Design, Implementation, and Management, 6e
Chapter 1: Database Systems

ISBN: 061921323X Author: Peter Rob, Carlos M. Coronel
copyright © 2005 Course Technology

Table 1.1 Basic File Terminology


“Raw” facts, such as a telephone number, a birth date, a customer name, and a year-to-date (YTD) sales value. Data have little meaning unless they have been organized in some logical manner. The smallest piece of data that can be “recognized” by the computer is a single character, such as the letter A, the number 5, or a symbol such as /. A single character requires one byte of computer storage.

A character or group of characters (alphabetic or numeric) that has a specific meaning. A field is used to define and store data.

A logically connected set of one or more fields that describes a person, place, or thing. For example, the fields that constitute a record for a customer named J.D. Rudd might consist of J.D. Rudd’s name, address, phone number, date of birth, credit limit, and unpaid balance.

A collection of related records. For example, a file might contain data about vendors of ROBCOR Company; or a file might contain the records for the students currently enrolled at Gigantic University.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License