Database Reference
In-Depth Information
If you feel the validators and users for this conceptual data model would prefer not to see a
diagram, we can present the model as a series of business assertions:
Each Customer may own one or many Accounts .
Each Account must be owned by one or many Customers .
Each Customer may be an Applicant , Active Customer , or Inactive Customer .
Each Applicant is a Customer .
Each Active Customer is a Customer .
Each Inactive Customer is a Customer .
Each Account may be a Checking Account or Savings Account .
Checking Account is an Account .
Savings Account is an Account .
Each Branch may contain one or many Accounts .
Each Account must belong to one Branch .
Each Account may incur one or many Withdrawal Debits .
Each Withdrawal Debit must be charged to one Account .
Each Account may incur one or many Deposit Credits .
Each Deposit Credit must be credited to one Account .
Each Account may incur one or many Monthly Statement Fees .
Each Monthly Statement Fee must be charged to one Account .
Each Account may generate one or many Bank Account Statements .
Each Bank Account Statement must be generated by one or many Accounts .
Each Checking Account may incur one or many Check Debits .
Each Check Debit must be charged to one Checking Account .
Each Check may lead to one Check Debit .
Each Check Debit must be the result of one Check .
Each Savings Account may incur one or many Interest Credits .
Each Interest Credit must be credited to one Savings Account .
Each Deposit Slip may record one or many Deposit Credits .
Each Deposit Credit must be recorded by one Deposit Slip .
Search WWH ::




Custom Search