AFM341 Chapter Notes - Chapter 4: Microsoft Access, Relational Algebra, Computer Language

• School: University of Waterloo
• Department: Accounting & Financial Management
• Course: AFM341
• Professor: Jee Hae Lim

Document Summary

Database:is a collection of related data for various uses. Relational data models are the dominant data model form in use today likely because they offer many advantages over other data models, including: As business and informational requirements change, relational data models are able to handle these changes quickly and easily. For this flexibility, the relational data model for databases is the most popular data model today. In fact, most enterprise system packages (e. g. , sap, oracle, Microsoft, etc. ) use the relational data model as their foundation. A relational data model is a relatively simple model that is easy to communicate to both database users and database developers. A relational data model requires each piece of data to be recorded only in one place eliminating the need for information to be stored in multiple places in the organization. This also helps keep the information updated since you only have to update the information once in one database and can avoid data inconsistency.