CP102 Chapter Notes - Chapter 11: Sql, Object Query Language, Query Language
Document Summary
Chapter 11: behind the scenes databases & informaion systems. Database: collecion of related data that can be stored, sorted, organized, and queried: efecively turn data into informaion, categorizing, soring, iltering are key atributes. Other problems with simple lists include: inappropriate data (is it valid, incomplete data (is it inished) Carefulness can be established with lists but sharing the data with users will increase the probability of errors. Enable informaion sharing: data centralizaion: only one ile is maintained, no need for muliple lists. Becomes a shared source that everyone can access. Increases eiciency because there are no iles to reconcile with each. Promote data integrity other: data integrity: data contained in the database is accurate and reliable. Disadvantages: time consuming and more expensive to set up, helpful to have an experienced database administrator: it professional who is responsible for designing, construcing, and maintaining databases.