B ITM 215 Information Study Guide - Midterm Guide: Data Scrubbing, Cost, Data Redundancy

• School: SUNY Albany
• Department: Information Technology Management
• Course: B ITM 215 Information
• Professor: Ethan Sprissler

Document Summary

Database- collection of data organized in a manner that allows access, retrieval, and use of that data, data- collection of unprocessed items. Table- a group of related records: primary key- identifier used to uniquely identify one instance of an entity. Foreign key- foreign keys reference a related table through the primary key of the related table: record- group of fields. Field size- defines the maximum number of characters a field can contain: data type- specifies kind of data field contains. Adding, changing, deleting records: validation- process of comparing data with a set of rules to find out if data is correct. Reduce data entry errors and enhance data integrity before program writes data on disk: data model- rules and standards that define how database organizes data. Defines how users view organization of data: relational database- stores data in tables that consist of rows and columns. Has a graphical user interface that assists users with retrieving data.