While examining a Bank Database, one of the relations you find is:
Lending_ Table (CustomerName, LoanNumber, Amount, BranchName, BranchCity, Assets) Primary Key are CustomerName and LoanNumber
You find out that the following additional dependencies hold: BranchName -> BranchCity, Assets LoanNumber -> Amount, BranchName
This Relation, Lending_Table in obviously not in BCNF. Systematically convert it to BCNF, showing your work .
Dear, PFA the... View the full answer