MIS 111 Lecture Notes - Lecture 9: Database, Data Security, Edgar F. Codd

• School: University of Arizona
• Department: Management Info Systems Main
• Course: MIS 111
• Professor: Mark Patton, William Neumann

Document Summary

Organize: helps us manage large quantities of information. Analysis and decision making: helps us understand more about our data. Communicate and collaborate: helps us share information with others. A database captures real-world relationships between people or objects. Facebook, as an example, allows you to see information related to your friends and their connections with one another. Enhance data value: data security, data integrity, data independence. Entity relationship diagram as a model of data and relationships: in 1976, peter chen from louisiana state university developed a very effective way of conceptualizing. Entity a specific person, place, thing, or event about which information is maintained. Entity class an abstract representation of all attributes of a particular type of entity. Attribute a characteristic or quality of a particular entity class: students studentid, studentname, studentemail. Relationships connect entities: students enroll courses. We can use the entity relationship diagrams we design to create relationship tables that can be stored in a database.