MIS 111 Lecture Notes - Lecture 9: Database, Data Security, Edgar F. Codd
azurerhinoceros284 and 2 others unlocked
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.