Database Answers Ski slopes in Villars, Switzerland

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Bankrupts
Back to the Data Model.
This page defines the Business Rules that the Data Model must comply with to support an operational Database.
A. What are the Requirements ?
A.1 The Requirement is for a Claims db for Bankruptcy proceedings where creditor
    claims are filed against a debtor.  
A.2 When disbursements are made, the debtor will typically wire the total
    amount to be disbursed and checks will be issued to creditors.  
A.3 From there checks can be stopped, returned, reissued, refunded, etc.  
A.4 Also, there will be multiple accounts as well as the possiblility of wire
    transfers (debit and credit).  
A.5 It is necessary to keep a Ledger.
A.6 Debits and credits must be stored.  
    Perhaps in a single table with a debit/credit attribute or store
    negative and positive values in the same column?
B. What are the Things of Interest ?
B.1 Accounts
B.2 Check
B.3 Claims
B.4 Creditors
B.5 Debtors
B.6 Disbursements
B.7 Financial Transactions
B.8 Ledgers
B.9 Payments
B.10 Wire Transfers
C. How are they Related ?
C.1 
D. What else do we need about them ?


Barry Williams
30th. March 2003
Principal Consultant
Database Answers

 

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map