ITM 100 Lecture Notes - Lecture 6: Software Architecture, Data Redundancy, Data Manipulation Language

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 100
• Professor: Debapriya Sen

Document Summary

Problems with the traditional file environment: data redundancy and inconsistency. Poor security: lack of data sharing and availability, 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. 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. Database management systems: how a dbms solves the problems of the traditional file environment, relational dbms, hierarchical and network dbms, object-oriented dbms. Relational dbms: represents data as two-dimensional tables called relations. Itm100: week 6 lecture notes: relates data across tables based on common data element, examples: access, db2, oracle, ms sql server, what is a relation database and how does it work. Select: creates subset of rows that meet specific criteria.