Chapter 5: Database AIS: Revenue Business Processes View 1 of 37ADVANCED SYSTEMS ANALYSIS & DESIGNby: Uday S. Murthy, Ph.D., ACA Database AIS: Revenue Business Processes ViewLearning ObjectivesAfter studying this chapter you should be able to:•use the General Systems Modelto describe an information system for meeting the information needs relative to revenue business processes•identify a comprehensive set of information needsand user requirements for a database driven information system for revenue business processes•develop an extended entity relationship diagramdepicting a data oriented view of revenue business processes•convert an extended entity relationship diagramof revenue business processes to tables for implementation in a relational database system•construct a context diagramand a level 0 data flow diagramdepicting a process oriented view of revenue business processes•identify the tablesand database formsthat would be created to implement the data and process oriented models•indicate how accounting viewssuch as a sales journal and current accounts receivable can be generated in a relational database system•indicate how non-financial information needscan be met in a relational database system for revenue related business processes•identify controlsthat should be implemented in a database system for revenue business processes•indicate how a database system for revenue business processes can be auditedusing the features available in relational database systems•adapt an existing database design to accommodate changesin users' needs and business rulesThe event-oriented database modeling approach (i.e., the REA approach) is aimed at capturing information about significant business events for all information customers. The goal is the construction of an enterprise-wide system that all users can access. The enterprise wide system stores data about business events at the most disaggregated level. Flexible views of financial and non-financial event data can be constructed. Note that the ultimate goal is to build a single integrated repository (i.e., database). In successive chapters we then explored the elements of information systems, the technology of information systems, the elements of database systems, systems analysis and design procedures, logical modeling using extended entity relationship modeling
This preview has intentionally blurred sections.
Sign up to view the full version.