---
# System prepended metadata

title: HW3
tags: [資料庫系統]

---

---
tags: 資料庫系統
title: HW3
---
# HomeWork 3

branch branch_name,branch_city,assets
account account_number,balance,branch_name
loan loan_number,amount,branch_name
customer customer_id,customer_name,customer_street,customer_city
employee employee_id,dependent_name,employmenf_length,start_date,telephone_number,employee_name
payment payment_number,payment_date,payment_amount

savings_account account_number,balance,interest_rate,branch_name
checking_account account_number,balance,ouverdrft_amount,branch_name


account_branch branch_name,account_number
loan_branch branch_name,loan_number
loan_payment loan_number,payment_number
borrower loan_number,customer_id
cust_bank customer_id,type,employee_id
depositor account_number,access_date,custormer_id
works_for empolyee_id,manger(?)








