B ITM 215 Information- Final Exam Guide - Comprehensive Notes for the exam ( 48 pages long!)

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

Document Summary

Itm 215 - lecture 2 - database concepts. Database: a structured collection of similar data, data organized and stored on a computer that can be searched and retrieved, dynamic site: real time updates, store and retrieve large quantities of information. Advantages of using databases: enable information sharing, provide data centralization, promote data integrity, allow for flexible use of data. Database contains files, file contains records, record contains fields, fields contains data. Primary key: a field value unique to a record. Field: combination of one or more characters. Maintaining data: users modify a record to correct inaccurate data or update old data, when a record no longer is needed, a user deletes it from a file. 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.