CIS 1200 Chapter Notes - Chapter 11: Data Cube, Expert System, Information System

• School: University of Guelph
• Department: Computing and Information Science
• Course: CIS 1200
• Professor: John Saville

Document Summary

Chapter 11: behind the scenes: databases and information systems. Facebook) (cid:120) no, simple lists can be created on word processing or spreadsheet software, a spreadsheet in microsoft excel, or table in word. 2 (cid:120) data integrity means that the data contained in the database is accurate and reliable (cid:120) data centralization is having all your data in one central location. Is the max number of characters or numbers that a field can hold. If numeric field has a size of 5 it can hold a number as large as 99999 (cid:120) a record is a group of related fields (cid:120) a table is a group of related records. What is meant by a field size? (cid:120) (cid:120) Database types (cid:120) yes, two students may have the same last name (cid:120) a primary field or key field is one field that has a value unique to that similar record (cid:120) numbers: relational, object-oriented, multidimensional.