Solution : alternative design
Decomposition
Decompose lending-schema into branch-customer-schema(bcs) and customer-loan-schema(cls)
bcs(bname, bcity, assets, cname)
cls(cname, loanNo, amt)
Is this decomposition correct? Lossless?
Previous slide
Next slide
Back to first slide
View graphic version