L5.41| GATE-2002: Lossless and Lossy Decomposition in DBMS | Whether decomposition is Lossless

preview_player
Показать описание
GATE-2002: Lossless and Lossy Decomposition
Your Queries:
Is lossless decomposition and lossless join decomposition same?
What is the lossless join property of a decomposition?
What is lossy join decomposition in DBMS?
Is it always possible to get lossless join decomposition for a given relation?
What is meant by lossy decomposition?
What is meant by lossless decomposition?
How do you check whether a decomposition is lossy or lossless?
difference between lossless and lossy decomposition in dbms

#gate #computerscience #dbms
Рекомендации по теме
Комментарии
Автор

Hi sir,
lectures 5.37 to 5.41 discusses regarding method 3 (matrix method), for determining lossy or lossless
But while using this method we have to take into account only those FDs which are preserved during decomposition.

Is my understanding correct sir?

pratikkumar