文档介绍：Database System Concepts, 5th Ed . ?Silberschatz, Korth and Sudarshan See for conditions on re-use Chapter 7: Relational Database Chapter 7: Relational Database Design Design ?Silberschatz, Korth and Sudarshan Database System Concepts - 5 th Edition, Oct 5, 2006 Chapter 7: Relational Database Design Chapter 7: Relational Database Design nFeatures of Good Relational Design nAtomic Domains and First Normal Form position Using Functional Dependencies nFunctional Dependency Theory nAlgorithms for Functional Dependencies position Using Multivalued Dependencies nMore Normal Form nDatabase-Design Process nModeling Temporal Data ?Silberschatz, Korth and Sudarshan Database System Concepts - 5 th Edition, Oct 5, 2006 The Banking Schema The Banking Schema nbranch = ( branch_name , branch_city , assets ) ncustomer = ( customer_id , customer_name , customer_street , customer_city ) nloan = ( loan_number , amount ) ount = ( account_number , balance ) nemployee = ( employee_id . employee_name , telephone_number , start_date ) ndependent_name = ( employee_id , dname ) ount_branch = ( account_number , branch_name ) nloan_branch = ( loan_number , branch_name ) nborrower = ( customer_id , loan_number ) ndepositor = ( customer_id , account_number ) ncust_banker = ( customer_id , employee_id , type ) nworks_for = ( worker_employee_id , manager_employee_id ) npayment = ( loan_number , payment_number , payment_date , payment_amount ) ount = ( account_number , interest_rate ) ount = ( account_number , overdraft_amount ) ?Silberschatz, Korth and Sudarshan Database System Concepts - 5 th Edition, Oct 5, bine Schemas? Combine Schemas? nSuppose bine borrower and loan to get bor_loan = ( customer_id , loan_number , amount ) nResult is possible repetition of information (L-100 in example below) ?Silberschatz, Korth and Sudarshan Database System Concepts - 5 th Edition, Oct 5, 2006 bined Schema Without Repetition bined Schema Without Repetit