CIS 2010 Chapter Notes - Chapter 3: Database, Relational Database, Relational Model

• School: GSU
• Department: Computer Information Systems
• Course: CIS 2010
• Professor: Kurt William Schmitz

Document Summary

Module 11: maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses). Database management system (dbms: creates, reads, updates, and deletes data in a database while controlling access and security. A dbms provides a way to create, update, delete, store, and retrieve data in the database. Numerous elements in a business environment need to store data, and those elements are related to one another in a variety of ways. In fact, a database must contain not only the data but also information about the relationships between those data. Designing a database properly is fundamental to establishing a solid foundation in which to base business decisions. This is done by using a data model, or the logical data structures that detail the relationships among data elements using graphics or pictures. Relational database model: stores information in the form of logically related two-dimensional tables.