In: Business and Management

Submitted By Kcilla
Words 2046
Pages 9
AC571_relational_database_005-019 Male

Page 1 of 5

AC571_relational_database_005 Welcome to this refresher on relational database concepts. Understanding relational database concepts is a key to mastering a key theme, REA modeling. As we progress through this refresher, please pay close attention to the objectives being covered as you see on the screen. The objectives are as follows: problems inherent in the flat file approach to data management that gave rise to the relational database concept, relationships among the defining elements of the relational database environment, stages in database design, entity identification, data modeling, constructing the physical database, and preparing user views, features of distributive databases and issues to consider in deciding on a particular database configuration. These objectives will serve as the foundation for understanding relational database concepts and REA modeling. AC571_relational_database_006 Before we can get into the heart of relational database concepts one must understand the differences between two common database environments, flat file and relational databases. As you know, computer systems process data. This processing involves two key components, data and instructions, or programs. This occurs no matter what database environment you have. In order to process the data you need an interface. Conceptually there are two methods for designing the interface between program instructions and data. File oriented processing, in which a specific data file was created for each application, and data oriented processing, in which you create a single data repository to support numerous applications. While many firms still rely on file oriented processing, there are some major disadvantages to this model, including redundant data and programs and varying formats for storing the redundant data.…...

Similar Documents