ITM 100 Lecture Notes - Data Redundancy, Microsoft Access, Relational Database

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 100
• Professor: Deb Fels

Document Summary

6. 1- organizing data in a traditional file environment. Information systems provides users accurate (free of errors), timely (when its available to decision makers) and relevant (when its useful) information. Each application requires its own file and its own computer programs. Hr has a personnel master file, a payroll file, medical insurance file, a pension file etc . Data redundancy and inconsistency- data redundancy is duplicate data in multiple data files (stored in more than one place). It occurs when different groups of organization collect the same amount of data. Data inconsistency is the same attribute, but may have a different value. Program-data dependence- coupling of data stored in files and specific programs required to update and maintain those files so that changes in programs require changes to the data. Lack of flexibility- file system deliver routine reports after extensive programming efforts, but it cannot deliver ad hoc reports or respond to unanticipated information requirements.