Ch05-IM7ed - _ Chapter Five Database Management Systems...

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

View Full Document Right Arrow Icon
_________________________________________ Chapter Five Database Management Systems LEARNING OBJECTIVES To describe the limitations of traditional application approaches to managing data. To analyze the advantages gained by using the database approach to managing data. To learn how to create normalized tables in a relational database. To know how entity relationship diagrams are used in database design and implementation. To explain the importance of advanced database applications in decision support and knowledge management. KEY TERMS INTRODUCED IN CHAPTER FIVE Application approach to business event processing Coding Entity-relationship model Data redundancy Sequential coding E-R diagram Database approach to business event processing Serial coding Entity-relationship diagram Database management system (DBMS) Block coding Resources Data independence Significant digit coding Events Schema Hierarchical coding Agents Subschema Mnemonic coding Locations Query language Self-checking digit code Cardinality Data manipulation language (DML) Normal forms Maximum cardinality Hierarchical database model Anomalies Relationship tables Child records Functionally dependent Junction tables Parent records Un-normalized table Decision support systems (DSS) Network database model First normal form (INF) Executive information systems (EIS) Relational database model Update anomalies Executive support systems
Background image of page 1

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

View Full DocumentRight Arrow Icon
(ESS) Object-oriented database model Partial dependency Group support systems (GSS) Object-relational databases Second normal form (2NF) Group decision support systems (GDSS) Tables Non-key attribute Groupware Queries Transitive dependency Expert systems (ES) Forms Third normal form (3NF) Neural networks (NN) Reports Data model Intelligent agent Primary key Entity-relationship modeling Knowledge management Composite primary key Entities Data warehousing Classifying Relationships Data mining CHAPTER SYNOPSIS In this chapter you will learn about the approaches that organizations use to process business event data. These events, as you learned in Chapter 2, include but are not limited to, sales, purchases, cash receipts, and cash disbursements. In this chapter, you will learn how data from business events are recorded and processed using differing accounting systems designs. As business events occur, data are processed and recorded. In a traditional manual accounting system, or in an automated system designed in the format of a manual accounting system, the accounting data are recorded in journals and classified in ledgers. Increasingly, however, accounting systems are built on underlying databases of business event data. In these databases, accounting information (along with other business information) is stored in database tables. Accounting reports, such as financial statements, and traditional accounting records, such as
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/10/2011 for the course ACCT 2102 taught by Professor Mrwang during the Spring '10 term at Central Arizona College.

Page1 / 5

Ch05-IM7ed - _ Chapter Five Database Management Systems...

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

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