has ACCOUNT Key Data AccountID PK 1 NonKey

has ACCOUNT Key Data Account-ID [PK 1] Non-Key Data Customer-ID [FK] Account-Origination-Date Account-Status CUSTOMER Key Data Customer-ID [PK 1] Non-Key Data Customer-Name Customer-Address Customer-Telephone-No SSN SAVINGS ACCOUNT Non-Key Data Savings-Interest-Rate Savings-Minimum-Balance-LImit Savings-Current-Balance Savings-YTD-Deposit-Amount Savings-YTD-Withdrawl-Amount Savings-YTD-Accum-Interest CHECKING ACCOUNT Non-Key Data Checking-minimum-balance Checking-YTD-Deposits Checking-YTD-Withdrawals Checking-Current-Balance ACCOUNT TRANSACTION Key Data Transaction-ID [PK 1] Account-ID [PK 2] [FK] Customer-ID [PK 3] [FK] Non-Key Data Transaction-Date Transaction-Time executes DEPOSIT Key Data Transaction-ID [PK 1] [FK] Account-ID [PK 2] [FK] Non-Key Data Deposit-Amount WITHDRAWAL Key Data Transaction-ID [PK 1] [FK] Account-ID [PK 2] [FK] Non-Key Data Withdrawal-Amount LOAN ACCOUNT Non-Key Data Original-Loan-Amount Loan-Length Loan-Interest-Rate Principle-Amount-Due Payment-Due YTD-Interest-Paid is involved with PAYMENT Key Data Transaction-ID [PK 1] [FK] Account-ID [PK 2] [FK] Non-Key Data Payment-Amount

Non Member Order & Application Order Verify Membership Members Member Verified Member Order Verify Order Items Ordered items Order Fulfillment Invoice & Process Shipping List Order Data Daily Orders