ITM 100 Chapter Notes - Chapter 6: Data Definition Language, Database Server, Nosql

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 100
• Professor: Debashish Roy

Document Summary

Banco de credito del peru banks on better data management. Problems with the traditional file environment: data redundancy and inconsistency, program-data dependence, lack of flexibility, poor security, lack of data sharing and availability. Problems with the traditional file environment: data redundancy & 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. Data inconsistency: the same attribute may have different values. Problems with the traditional file environment: 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. Problems with the traditional file environment: lack of flexibility: 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.