ITEC 1010 Chapter Notes - Chapter 3: Data Manipulation Language, Database, Data Center
22 Jan 2017
School
Department
Course
Professor
Document Summary
Without data and the ability to process it, an organization could not successfully complete most business activities. Data is generally organized in a hierarchy that begins with the smallest piece of data used by computers (a bit) and progresses through the hierarchy to a database. Character: a basic building block of most information, consisting of uppercase letters, lowercase letters, numeric digits or special symbols. Eld: typically a name, number, or combination of characters that describes an aspect of a business object or activity. Record: a collection of data elds all related to one object, activity, or individual. Hierarchy of data: bits, characters, elds, records, les, and databases. Entity: a general class of people, places or things for which data is collected, stored, and maintained. Key: a eld or set of elds in a record that is used to identify the record. Primary key: a eld or set of elds that uniquely identi es the record.
