ADM 1370 Study Guide - Quiz Guide: Database, Records Management, Data Redundancy

• School: University of Ottawa
• Department: Administration
• Course: ADM 1370
• Professor: Craig Kuziemsky

Document Summary

Covers module 3: unit 1 of the required course pack. Covers all class discussions and lectures as well as powerpoints. Students will not be tested on technical aspects of access. Winter 2016 included questions regarding mainly: information system, relational dbms, database management systems, data analytics, centralized/decentralized systems, data mining, big data, olap, hadoop, electronic records management, e-discovery. Data: raw facts that describe characteristics of an event. Information: data converted into meaningful and useful content. Database: collection of data organized to serve many applications efficiently by centralizing data and controlling redundant data. Problems with traditional file organization: data redundancy (multiple files all over), data inconsistency (same attribute with different values), lack of flexibility (not much you can do with data). Poor security, lack of data availability (information cannot flow freely across the organization) Some sources of low quality information: customers intentionally enter false information, call centres enter abbreviated or erroneous information by accident or to save time, different entry standards.