Computer Science Engineering (CSE) Exam  >  Computer Science Engineering (CSE) Questions  >  The relation employee(ID,name,street,Credit,s... Start Learning for Free
The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into
employee1 (ID, name)
employee2 (name, street, city, salary)
Q. This type of decomposition is called
  • a)
    Lossless decomposition
  • b)
    Lossless-join decomposition
  • c)
    All of the mentioned
  • d)
    None of the mentioned
Correct answer is option 'D'. Can you explain this answer?
Most Upvoted Answer
The relation employee(ID,name,street,Credit,street,city,salary) is dec...
Lossless decomposition:
Lossless decomposition is a property of database decomposition in which no information is lost when a relation is decomposed into smaller relations. This means that we should be able to reconstruct the original relation by joining the smaller relations together.

Explanation:
- The decomposition of the relation employee(ID, name, street, Credit, street, city, salary) into employee1 (ID, name) and employee2 (name, street, city, salary) does not maintain the property of lossless decomposition.
- This is because the attribute "street" appears in both the original relation and the decomposed relations. When we join the decomposed relations back together, we may end up with duplicate entries or lose some information.
- Therefore, this type of decomposition is not lossless and does not preserve all the information present in the original relation.

Conclusion:
- The decomposition described in the question is not a lossless decomposition. It does not guarantee that we can reconstruct the original relation by joining the decomposed relations together without losing any information.
- Hence, the correct answer is option 'D' - None of the mentioned.
Community Answer
The relation employee(ID,name,street,Credit,street,city,salary) is dec...
Lossy-join decomposition is the decomposition used here.
Explore Courses for Computer Science Engineering (CSE) exam

Top Courses for Computer Science Engineering (CSE)

Question Description
The relation employee(ID,name,street,Credit,street,city,salary) is decomposed intoemployee1 (ID, name)employee2 (name, street, city, salary)Q.This type of decomposition is calleda)Lossless decompositionb)Lossless-join decompositionc)All of the mentionedd)None of the mentionedCorrect answer is option 'D'. Can you explain this answer? for Computer Science Engineering (CSE) 2025 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about The relation employee(ID,name,street,Credit,street,city,salary) is decomposed intoemployee1 (ID, name)employee2 (name, street, city, salary)Q.This type of decomposition is calleda)Lossless decompositionb)Lossless-join decompositionc)All of the mentionedd)None of the mentionedCorrect answer is option 'D'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2025 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for The relation employee(ID,name,street,Credit,street,city,salary) is decomposed intoemployee1 (ID, name)employee2 (name, street, city, salary)Q.This type of decomposition is calleda)Lossless decompositionb)Lossless-join decompositionc)All of the mentionedd)None of the mentionedCorrect answer is option 'D'. Can you explain this answer?.
Solutions for The relation employee(ID,name,street,Credit,street,city,salary) is decomposed intoemployee1 (ID, name)employee2 (name, street, city, salary)Q.This type of decomposition is calleda)Lossless decompositionb)Lossless-join decompositionc)All of the mentionedd)None of the mentionedCorrect answer is option 'D'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE). Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.
Here you can find the meaning of The relation employee(ID,name,street,Credit,street,city,salary) is decomposed intoemployee1 (ID, name)employee2 (name, street, city, salary)Q.This type of decomposition is calleda)Lossless decompositionb)Lossless-join decompositionc)All of the mentionedd)None of the mentionedCorrect answer is option 'D'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of The relation employee(ID,name,street,Credit,street,city,salary) is decomposed intoemployee1 (ID, name)employee2 (name, street, city, salary)Q.This type of decomposition is calleda)Lossless decompositionb)Lossless-join decompositionc)All of the mentionedd)None of the mentionedCorrect answer is option 'D'. Can you explain this answer?, a detailed solution for The relation employee(ID,name,street,Credit,street,city,salary) is decomposed intoemployee1 (ID, name)employee2 (name, street, city, salary)Q.This type of decomposition is calleda)Lossless decompositionb)Lossless-join decompositionc)All of the mentionedd)None of the mentionedCorrect answer is option 'D'. Can you explain this answer? has been provided alongside types of The relation employee(ID,name,street,Credit,street,city,salary) is decomposed intoemployee1 (ID, name)employee2 (name, street, city, salary)Q.This type of decomposition is calleda)Lossless decompositionb)Lossless-join decompositionc)All of the mentionedd)None of the mentionedCorrect answer is option 'D'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice The relation employee(ID,name,street,Credit,street,city,salary) is decomposed intoemployee1 (ID, name)employee2 (name, street, city, salary)Q.This type of decomposition is calleda)Lossless decompositionb)Lossless-join decompositionc)All of the mentionedd)None of the mentionedCorrect answer is option 'D'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.
Explore Courses for Computer Science Engineering (CSE) exam

Top Courses for Computer Science Engineering (CSE)

Explore Courses
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev