Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

enter image description here

I am confused with the lossy decomposition and natural join. Natural join(with common attribute): only respective common attribute for the resultant table is formed. Lossy: Natural join on tables with common attribute results formation of spurious table. the problem is, both have common attribute but showing 2 different solutions.one is showing original tuple other a spurious tuple.

Please Help.

I've seen these articles:

http://stackoverflow.com/questions/12671362/lossy-decomposition http://stackoverflow.com/questions/14548543/natural-join-if-no-common-attrubute http://en.wikipedia.org/wiki/Relational_algebra#Natural_join_.28.E2.8B.88.29

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.