DB assignment#1
Tables (12)
Account
- Key (account_number) — Varchar(20) — Primary key — NOT NULL
- Field (balance) — Int(10)
Customer
- customer_id — Varchar(3) — Primary key — NOT NULL
- customer_name — Varchar(100)
- cutomer_street — Varchar(100)
- custormer_city — Varchar(100)
Loan
- Key (loan_number) — Varchar(20) — Primary key — NOT NULL
- Field (amount) — Int(10)
Untitled (Employee)
- Key (employee_id) — Varchar(4) — Primary key — NOT NULL
- Field (employee_name) — Varchar(100)
- Field (telephone_number) — Varchar(11)
- Field (employee_length) — Int(10)
- Field (start_date) — Date(8)
Untitled (Employee_Dependent)
- Key (employee_id) — Varchar(4) — Foreign key → Untitled.Key — NOT NULL
- Field (dependent_name) — Varchar(100)
Untitled (Branch)
- Key (branch_name) — Varchar(100) — Primary key — NOT NULL
- Field (branch_city) — Varchar(100)
- Field (assets) — Int(10)
Untitled (Payment)
- Key (payment_number) — Int(10) — Primary key — NOT NULL
- Field (payment_amount) — Int(10)
- Field (payment_date) — Date(8)
- Key (loan_number) — Varchar(20) — Foreign key → Loan.Key — NOT NULL
Untitled (Borrower)
- Key (loan_number) — Varchar(20) — Foreign key → Loan.Key — NOT NULL
- customer_id — Varchar(3) — Foreign key → Customer.customer_id — NOT NULL
Untitled (Depositor)
- customer_id — Varchar(3) — Foreign key → Customer.customer_id — NOT NULL
- Key (account_number) — Varchar(20) — Foreign key → Account.Key — NOT NULL
Untitled (Loan_Branch)
- Key (branch_name) — Varchar(100) — Foreign key → Untitled.Key — NOT NULL
- Key (loan_number) — Varchar(20) — Foreign key → Loan.Key — NOT NULL
Untitled (Customer_Banker)
- Key (employee_id) — Varchar(4) — Foreign key → Untitled.Key — NOT NULL
- customer_id — Varchar(3) — Foreign key → Customer.customer_id — NOT NULL
Untitled (Manager_Worker)
- Key (employee_manage) — Varchar(20) — Primary key — NOT NULL
- Field (employee_worker) — Varchar(20)
- Key (employee_id) — Varchar(4) — Foreign key → Untitled.Key — NOT NULL