ITM 102 Lecture Notes - Lecture 6: Database, Relational Database Management System, Data Redundancy

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 102
• Professor: Carmen Branje

Document Summary

6. 1 organizing data in a traditional file environment. Problem with the traditional file environment: data redundancy and inconsistency. Data redundancy: presence of duplicate data in multiple data files. Cannot deliver ad hoc report or respond to anticipated information requirements in timely fashion: poor security. Out of control; did not know who is accessing or making changes to data: lack of data sharing and availability. Information cannot flow freely across different functional areas or different parts of organization. Database: a collection of data organized to serve application efficiently by centralizing and controlling redundant data. Software that permits an organization to centralize data, manage efficiently and provide access to stored data by application programs. Logical views: data would be perceived by end users or business specialists. Physical views: how data organize and structured on physical storage media. How a dbms solves the problems of traditional file environment.