MIS 111 Lecture Notes - Lecture 9: Database, Data Security, Edgar F. Codd
![MIS 111 Full Course Notes](https://new-docs-thumbs.oneclass.com/doc_thumbnails/list_view/2241060-class-notes-us-u-of-arizona-mis-111-lecture34.jpg)
41
MIS 111 Full Course Notes
Verified Note
41 documents
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.