资源简介

(共13张PPT)
Chapter 18Implementing an REA Model in a Relational Database18-Learning ObjectivesIntegrate separate REA diagrams for individual business cycles into a single, comprehensive organization-wide REA diagram.Build a set of tables to implement an REA model of an AIS in a relational database.Explain how to write queries to retrieve information from an AIS relational database built according to the REA data model.18-REA Diagram—Revenue Cycle18-REA Diagram—Expenditure Cycle18-REA Diagram—Payroll Cycle18-REA RedundanciesSeparate REA for an organization will have redundant entitiesResourceEach resource entity must be connected to:The resource entity is linked to event entities in one business cycleand to event entities in the other cycleOne event that increases the resource and,One event that decreases the resourceNo effect on cardinalityEventsAlters the minimum cardinalities associated with the other events that are related to the merged eventMay be linked toeither an event that is part of one business cycle or to an event that is part of another cycle but cannot be linked to both eventsThe minimum cardinality associated with the other eventsmust be 0 in the integrated REA diagram18-Integrated REA Diagram18-Revenue CycleExpenditure CyclePayroll CycleCardinality Effect of Merging Resources18-Cardinalities between resource and entities remain the same.Cardinality Effect of Merging Events18-The cardinality between Disburse Cash and Supplier and Employee (as payee) is now 0 to 1, that is, a disbursement can be made to the supplierorthe employee but notboth!Rules for Creating Integrated REA DiagramEvery event must be linked to at least one resource.Every event must be linked to two agents who participate in that event.Every event that involves the disposition of a resource must be linked to an event that involves the acquisition of a resource.Every resource must be linked to at least one event that increments that resource and to at least one event that decrements that resource.If event A can be linked to more than one other event, but cannot be linked simultaneously to all of those other events, then the REA diagram should show that event A is linked to a minimum of 0 of each of those other events.18-Using REA Diagram to Create Relational DatabaseAdvantage:Ensures the elimination of anomalies:UpdateInsertDelete18-REA to Database StepsCreate a table for each distinct entity in the diagram and for each many-to-many relationship.Assign attributes to appropriate tables.Identify primary keys:Attributes that uniquely identifies each record.For M:N relationships the primary key consists of two attributes that represent the primary keys of each entity linked in that relationship.Identify remaining attributes for table.Use foreign keys to implement one-to-one and one-to-many relationships.An attribute of one entity that is itself the primary key of another entity.18-Retrieving Information from REA DatabaseJournalsInformation contained in event tablesLedgersInformation contained in resource tablesFinancial statementsInformation contained in resources andInformation on imbalancesAccounts receivableSales transactions for which customer payments have not yet been receivedAccounts payablePurchases from suppliers that have not yet been paid for18-

展开更多......

收起↑