bank
Tables (6)
account
- account_number (Key) — Primary key — NOT NULL
- branch_name (Key2) — Foreign key → branch.branch_name — NOT NULL
- balance (Field2)
borrower
- loan-number (Key2) — Foreign key → loan.loan-number — NOT NULL
- branch_name (Key3) — Foreign key → loan.branch_name — NOT NULL
- customer_name (Key4) — Foreign key → customer.customer_name — NOT NULL
branch
- branch_name (Key) — Primary key — NOT NULL
- branch_city (Field)
- assets (Field2)
customer
- customer_name (Key) — Primary key — NOT NULL
- customer_street (Field)
- customer_city (Field2)
depositor
- customer_name (Key2) — Foreign key → customer.customer_name — NOT NULL
- account_number (Key) — Foreign key → account.account_number — NOT NULL
- branch_name (Key22) — Foreign key → account.branch_name — NOT NULL
- balance (Field2)
loan
- loan-number (Key) — Primary key — NOT NULL
- branch_name (Key3) — Foreign key → branch.branch_name — NOT NULL
- amount (Field2)