Consider
the relation Construction (Company, Material, Type, Cost) along with the Functional
Dependencies:

FD1:
Company - Material

FD2:
Material -Type

FD3: Type
- Cost

The
relation is decomposed into the following:

Construction1(Company,
Type, Cost)

Construction2(Material,
Type)

Which of the following is true about the
decomposition?

Question

Consider
the relation Construction (Company, Material, Type, Cost) along with the Functional
Dependencies:

FD1:
Company -> Material

FD2:
Material ->Type

FD3: Type
-> Cost

The
relation is decomposed into the following:

Construction1(Company,
Type, Cost)

Construction2(Material,
Type)

Which of the following is true about the
decomposition?

Answer

Lossless but not decomposition preserving.

Answer

Neither lossless nor decomposition preserving.

Answer

Both lossless and decomposition preserving

Crowdly