CIS 1000 Chapter 11: CIS chapter 11.doc

• School: University of Guelph
• Department: Computing and Information Science
• Course: CIS 1000
• Professor: Jing Yu Zhu

Document Summary

Chapter 11: behind the scenes: databases and information systems. Database is a collection of related data that can be easily stored, sorted, organized, and queried. A key attribute of databases is that information can be filtered so that you can only see the info you really want (ex. No, simple lists can be created on word processing or spreadsheet software, a spreadsheet in microsoft excel, or table in word. If complex information needs to be organized or more than one needs access to it, a list is not an efficient solution. A great deal of duplicated data between the two lists. Data redundancy is when the same data exists in more than one place in a database. Each time the information in the list changes, multiple lists must be updated (data inconsistency) With a list, anything can be entered in a row or column, even if that information is incorrect.