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