Example Consider Loan-info-schema =(branch-name,customer-name,loan-number. amount). Each loan has one or more customers,is in one or more branches and has a loan amount;these relationships are independent,hence we have the join dependency *(=(loan-number,branch-name),(loan-number,customer-name),(loan- number,amount)) Loan-info-schema is not in PJNF with respect to the set of dependencies containing the above join dependency.To put Loan-info-schema into PJNF, we must decompose it into the three schemas specified by the join dependency: (loan-number,branch-name) (loan-number,customer-name) (loan-number,amount) Database System Concepts,5th Ed. c.9 ©Silberschat乜，Korth and SudarshanDatabase System Concepts, 5 C.9 ©Silberschatz, Korth and Sudarshan th Ed. Example Consider Loan-info-schema = (branch-name, customer-name, loan-number, amount). Each loan has one or more customers, is in one or more branches and has a loan amount; these relationships are independent, hence we have the join dependency *(=(loan-number, branch-name), (loan-number, customer-name), (loan￾number, amount)) Loan-info-schema is not in PJNF with respect to the set of dependencies containing the above join dependency. To put Loan-info-schema into PJNF, we must decompose it into the three schemas specified by the join dependency: (loan-number, branch-name) (loan-number, customer-name) (loan-number, amount)