Ch06-IM7ed - _ Chapter Six Relational Databases and SQL...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
_________________________________________ Chapter Six Relational Databases and SQL LEARNING OBJECTIVES Understand the techniques used to model complex accounting phenomena in an entity- relationship diagram. Develop entity-relationship diagrams that model effective accounting database structures using the ( approach. Recognize the components of relational tables and the keys to effective relational database design. Understand the use of SQL commands to create relational tables during implementation of the model. Manipulate relational tables to extract the necessary data during decision making. KEY TERMS INTRODUCED IN CHAPTER FIVE semantics instance attribute composite attributes key attribute recursive relationship participation constraint legacy systems relation tuple candidate keys null non-null referential integrity CHAPTER SYNOPSIS In this chapter we describe the REA (Resources, Events, Agents) approach for developing models of accounting databases and using those models to build relational databases. We also describe SQL, a database query language used to construct and manipulate relational databases. You will learn to develop more complex entity-relationship diagrams, integrate the REA concepts with E-R diagrams, as well as create and manipulate relational databases with the SQL query language. These advanced database techniques provide the foundation for understanding
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Ch06-IM7ed - _ Chapter Six Relational Databases and SQL...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online