ITM 100 Lecture Notes - Lecture 6: Referential Integrity, Data Warehouse, Data Cleansing

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 100
• Professor: Raymond Moss

Document Summary

6. 1 organizing data in a traditional file environment. Effective information system provides users with accurate, timely, and relevant information. It"s accurate when it"s free of error, timely when it"s available to decision makers when needed and relevant when it"s useful and appropriate for the types of work and decisions it requires. A computer system organizes data in a hierarchy that starts with bits and bytes and progresses to fields, records, files, and databases. Bit: the smallest unit of data a computer can handle; binary digit (0,1). Byte: a group of bits that represents a single character. Field: a group of words or a complete number (person"s name or age) Record: a group of related fields (student"s name, course taken, date & grade) File: group of records of the same type. Entity: a person, place, thing, or event about which information is maintained. Key field: identifier field used to retrieve, update, and store a record.