kc第讲数据库规范化理论.pptVIP

The Banking Schema - 根据ER图获得的 branch = (branch_name, branch_city, assets) customer = (customer_id, customer_name, customer_street, customer_city) loan = (loan_number, amount) account = (account_number, balance) employee = (employee_id. employee_name, telephone_number, start_date) dependent_name = (employee_id, dname) - - - account_branch = (account_number, branch_name) loan_branch = (loan_number, branch_name) borrower = (customer_id, loan_number) depositor = (customer_id, account_number, access_date) cust_banker = (customer_id, employee_id, type) works_for = (worker_employee_id, manager_emplo