ITM 102 Chapter Notes - Chapter 5: Database Administrator, Business Intelligence, Apache Hadoop
Document Summary
Effective information is: accurate (free of error), and relevant (useful and appropriate for type of work/decision that require it) timely (available when needed), Ex. student id, course, date, and grade are attributes of the entity course . Specific values that these attributes can have are found in the fields of the record describing the entity course . Data redundancy and inconsistency: data redundancy: the presence of duplicate data in multiple data files so that the same data are stored in more than one place or location. Occurs when different groups in an organization independently collect the same piece of data and store it independently of each other. Data redundancy wastes storage resources and also leads to data inconsistency: data inconsistency: the same attribute may have different values. Program data dependence: program-data dependence: the coupling of data stored in files and the specific programs required to update and maintain those files such that changes in programs require changes to the data.