Required Create a business process level REA model (in

Document Sample
Required Create a business process level REA model (in Powered By Docstoc
					        Required: Create a business process level REA model (in either grammar or
        diagram format) for Quandrax Computers’ sales/collection process. Be sure to
        include all relevant entities, relationships, attributes, and participation cardinalities.



             Quandrax Revenue Cycle Suggested REA Model in Diagram Format

                                            SC-ID
                                       Sc-date             Sales Call               (1,1)         parti-     (0,N)
                                                                                                 cipate1



                                                                  (0,1)             (1,1)
                            Prop sp (1,N)                    fulfill-                         parti-   (0,N)
                       (0,N)                                 ment1                           cipate2
                                propo-
                                sition                            (0,N)
                                                                                                                      Salesperson
                                         SO-ID
                                                          Sale Order
                                      SO-date                                (1,1)               (0,N)
                                                                                        parti-
                                                                                       cipate3
                                Ord sp (1,N)
                                                         (0,N)
                                       reser-                fulfill-
                            (0,N)      vation1               ment2                                                    (0,N)
                                                         (1,N)
  Cat-ID        Computer               ShipID                                         (1,1)         parti-    (0,N)      assign-
                                                                                                   cipate5                ment
Cat-desc        Category              Sale-amt
                                                         Sale/
List-price                           Ship-date           Shipment                                                     (0,1)            (1,1)
                                                                                      parti-
                       (0,N)                                                         cipate6                                            parti-
                  Typifi-                                                  (1,1)                                                       cipate4
                  cation
                                             (1,N)                                            (0,N)                                (0,N)
                       (1,1)                                                                                 Customer
                                    (0,1)
CompuID                                     stock                  (0,1)
               Finished                     flow1
Assemb         Computer
  date
                                                             duality1                    (0,N)
 ActSP
                                                                  (0,N)              parti-            Cust-ID Cust- Cust-
                                                                                    cipate7                    name ship
             Acct# Ca-Loc AcctBal                                           (0,1)                                                                Employee
                                                          Cash                                             Cashier
               Cash                      stock                                      parti-
                                         flow2            Receipt                  cipate8
                                    (1,N)        (1,1)                      (1,1)             (0,N)
                                                                                                                                             Emp-ID   Emp- Emp-
                                                                                                                                                      name type
                                                     CR-ID Date CrAmt Cr-Chk#