ADM 2337 Chapter Notes - Chapter 6: Data Redundancy, Business Intelligence, Online Analytical Processing
Document Summary
Organizing data in a traditional file environment: accurate information is free of errors. Information is timely when it is available to decision makers when it is needed. Information is relevant when it is useful and appropriate for the types of work and decisions that require it. Std num, course taken: file ( a group of records of the same type) database ( a group of related files) A record describes an entity- is a person, place, thing, or event about which we store and maintain information. Database is a collection of data organized to serve many applications efficiently by centralizing the data and controlling redundant data. A database management system (dbms) is software that permits an organization to centralize data, manage data efficiently, and provide access to the stored data by application programs. Relationship databases represent data as two-dimensional tables called relations: the actual information about a singles supplier that resides in a table is called a row.