Lec 58: GATE 2024 Preparation | GATE 2021 PYQ By Jayesh Umre
Consider the relation R(P, Q, S, T, X, Y, Z, W) with the following functional dependencies.
PQ → X; P → YX; Q → Y; Y → ZW
Consider the decomposition of the relation R into the constituent relations according to the following two decomposition schemes.
D1 : R = [(P, Q, S, T); (P, T, X); (Q, Y); (Y, Z, W)]
D2 : R = [(P, Q, S); (T, X); (Q, Y); (Y, Z, W)]
Which one of the following options is correct?
1. D1 is a lossy decomposition, but D2 is a lossless decomposition.
2. Both D1 and D2 are lossless decompositions.
3. Both D1 and D2 are lossy decompositions.
4. D1 is a lossless decomposition, but D2 is a lossy decomposition.
WebSite: www.EasyExamNotes.com
Our FB page: / easyexamnotesdotcom
Lectures Library:
1) Analysis & Design of Algorithm: • Video
2) Data Structure Lectures: • Video
3) Computer Organization Architecture: • Computer Organization Architecture
4) Operating System Lectures: • Fragmentation (Hindi) | OS | Jayesh Umre
5) Theory Of Computation Lectures: • Lec-4 Draw a DFA accepting strings starti...
6) DBMS Lectures: • RDBMS (Hindi) | Jayesh Umre
7) Principles Of Programming Languages: • Language Evaluation Criteria | PPL | Jayes...
8) Internet Of Things: • IOT Conceptual Framework in Hindi | Jayesh...
9) Discrete Structures: • Prove set G= {1, 2, 3, 4, 5, 6} is abelian...
10) Cloud Computing Lectures: • RAID-Redundant Array of Independent Disks(...
11) Software Engineering: • RAD model | SDLC | Jayesh Umre
12) Digital Circuits: • Half Adder | Jayesh Umre
13) Number System: • 10's Complement | Jayesh Umre
14) GATE Mathematics: • GATE | Adjoint of a Matrix | Jayesh Umre
15) Management Information System: • MIS in Hindi
16) Computer Network: • Computer Networks in Hindi
====================================================