3. The relation employee(ID, name,street, Credit, street,city,salary) is decomposed into
employeel (ID, name)
employee2 (name, street, city, salary)
This type of decomposition is called
a) Lossless decomposition
b) Lossless-join decomposition
c) All of the mentioned
d) None of the mentioned
Answers
Answer:
okk please mark as brainliest
The relation employee(ID, name,street, Credit, street,city,salary) is decomposed into employeel (ID, name) employee2 (name, street, city, salary) This type of decomposition is called
a) Lossless decomposition
b) Lossless-join decomposition
c) All of the mentioned
d) None of the mentioned
The correct answer is :
d) None of the mentioned
Explanation :
None of the given options is correct.
In Lossless decomposition, the normal feature is selected. Common attribute must be candidate key or super key in any relation r1 r2 or both in order to select common attribute.
In the Lossless-join decomposition r1 r2 is a decomposition of the relation r. If a natural join of the relation r1 and r2 is performed, it returns the original relation R. In this way flawless join decomposition can remove the database redundancy while preserving the original data.
#SPJ3
——————————————————————————————————————
Know something more :
https://brainly.in/question/39332112?msp_srt_exp=6
____ is a committee that makes decisions regarding whether or not proposed changes to a software project can be incorporated.
https://brainly.in/question/7038843?msp_srt_exp=5
Generally Current ratio should be ________. (Fill in the blank by choosing correct option)
1) 2:1
2) 1:1
3) 3:1
4) 1:2