CIS 1000 Lecture Notes - Lecture 11: Enterprise Resource Planning, Compound Key, Foreign Key

• School: University of Guelph
• Department: Computing and Information Science
• Course: CIS 1000
• Professor: Zoe Zhu

Document Summary

Database: related collection of data stored in such a way that it can be organized and retrieved in an efficient manner. They are typically modeled on real world domains, such as medical offices, retail businesses, and libraries. As opposed to lists, databases are designed to have very little redundancy, making full use out of all available space. They are also designed to have very little inconsistency, by not repeating data over and over again, and allowing for empty values (such as a person that doesn"t have a middle name) Can manage and organize large amounts of complex data efficiently. 1: provide data centralization, which reduces redundancies and inconsistences, allow data to be shared on a network to those that need access to it, through data centralization, they help ensure data integrity. All databases require some form of organization. Without organizational methods in place, individuals would be unable to acquire large amounts of data in an orderly fashion.