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
.