COMMERCE 2KA3 Study Guide - Final Guide: Data Redundancy, Data Governance, Sap Hana

• School: McMaster University
• Department: Commerce
• Course: COMMERCE 2KA3
• Professor: Ali Montazemi

Document Summary

Characteristics of high quality information: relevance, accuracy, completeness, timeliness. Potential business effects of low quality information: inability to accurately track customers, difficulty identifying valuable customers, inability to identify selling opportunities, marketing to nonexistent customers. Bit: smallest unit of data a computer can handle. Byte: a single character, which can be a letter, a number or another symbol. Field: a grouping of characters into a word, a group of words, or a complete number. Entity: a person, thing or place or event about which we store and maintain information. Attribute: each characteristic or quality describing a particular entity. (student id) Data redundancy: duplicate data in multiple data files. Data inconsistency: when the same attribute may have different values. Program-data dependency: coupling of data stored in files and the specific prgrams so that changes in programs require changes to the data. Lack of flexibility: routine scheduled reports can be extracted but ad hoc reports are too expensive.