While examining a bank database


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 .

Request for Solution File

Ask an Expert for Answer!!
Database Management System: While examining a bank database
Reference No:- TGS095484

Expected delivery within 24 Hours