ACC 406 Study Guide - Quiz Guide: Data Redundancy, Database Model, Transaction Processing

• School: University of Miami
• Department: Accounting Business Administration
• Course: ACC 406
• Professor: Friedman

Document Summary

Approach where there was virtually no integration across application areas: Approach where a integrated set of application systems is used: Involves creating a set of files, as needed, for each transaction processing application such as sales or purchases. In the file-oriented approach a set of ________ programs and data files are created to satisfy the information needs of each application. List 3 of the drawbacks of the file oriented approach: List 3 of the drawbacks of the database approach: A ______ is created for every entity and every event of interest that needs to be represented in the database. Every field in a data set other than a primary key is referred to as: Explain at least 2 drawbacks of the database approach. Give 2 examples of data contained in within the data dictionary. M:m relationship between_______ and ________ is implemented by creating a new___________table. A crucial building block of database models and database systems.