MIS 111 Lecture Notes - Lecture 19: Peter Chen, Data Integrity, Data Modeling

• School: University of Arizona
• Department: Management Info Systems Main
• Course: MIS 111
• Professor: ALL

Document Summary

Organize (helps us manage large quantities of information) 2. Analysis and decision making (helps us understand more about our data) 3. Communicate and collaborate (helps us share information with others) Database as a real world model: a database captures real-world relationships between people or objects (i. e. facebook, as an example, allows you to see information related to your friends and their connections with one another) Gives us a structure to do data analysis against. For students real world aspect with first names, last names, etc. Databases eliminates problems: data redundancy (two or three entries into one data input, consistency eliminates multiples of data), data integrity enforces structure of data (i. e. phone numbers) isolation, inconsistency. Databases enhance data value: data security, integrity, and independence. For data modeling, used to use flat filing system, single thing not linked to anything else excel with name, email, etc. Models where tables relate to each other to show links between different lists.