ITM 100 Lecture 6: ITM 100 - Chapter 6 Notes

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 100
• Professor: Mahmoud Jahani

Document Summary

Itm 100 chapter 6 databases and information management. 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. Data inconsistency: the same attribute may have different values. 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. A traditional file system can deliver routine scheduled reports after extensive programming efforts, but it cannot deliver ad-hoc reports or respond to unanticipated information requirements in a timely fashion. Poor security: management may have no knowledge of who is accessing or making changes to the organization"s data. Lack of data sharing and availability: information cannot flow freely across different functional areas or different parts of the organization. How a dbms solves the problems of the traditional file environment. Represents data as two-dimensional tables called relations.