MIS 3305 Chapter Notes - Chapter 7: Relational Database Management System, Database, Data Integrity

• School: Baylor University
• Department: Management Information Systems
• Course: MIS 3305
• Professor: Esserman

Document Summary

An entity refers to storing information about a person, place, thing, transaction, or event. Fields, attributes, and columns represent the data elements associated with an entity. Integrations allow separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems. A relational database management system allows users to create, read, update, and delete data in a relational database. Data models are logical data structures that detail the relationships among data elements using graphics or pictures. Four functions that a database management system can perform on data in a database: delete data, create data, read data, update data. A database maintains information about various types of objects (inventory_, events (transactions), people (employees), and places (warehouses). A relational database model stores information in the form of logically related two-dimensional tables. Data elements and data fields are the smallest or basic unit of information.