CIS 1200 Chapter Notes - Chapter 11: Query Language, Data Validation, Data Cube

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

Document Summary

Chapter 11: databases, its advantages and disadvantages. Database: a collection of information that is organized so that it can easily be accessed, managed, and updated: e. g. Field: where a category of information in a database is stored: displayed in columns and identified by field names. Also have different characteristics such as field data type and size. Records and tables: record: a group of data for one item across related fields. Primary key: one field in each record that has a value unique to that record: makes it impossible to duplicate records. 20: input field names, field names must be unique within a table, the caption property in ms access lets you display a field name of your choice that might be more meaningful. 23. field unless the user enters another value: useful for field data that is frequently the same. Each field should describe a unique category of data. Each field should not combine two separate pieces of data: e. g.