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-7th Edition 28.10 @Silberschatz,Korth and SudarshanDatabase System Concepts - 7 28.10 ©Silberschatz, Korth and Sudarshan th Edition 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)