Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is a subjective question, hence you have to write your answer in the Text - Field given below. Assume that the relational R with

This is a subjective question, hence you have to write your answer in the Text-Field given below.
Assume that the relational R with schema R(A,B,C,D,E,F), with the following set (F) of
functional dependencies. F={ABC;CD;DEF}. If R is decomposed into three relations-
R1(A,B,E),R2(A,B,C,F),R3(A,B,D), do the following.
(a) Check if the above decomposition is lossless or not.
Use matrix approach discussed in the lectures/textbook. You are required to give the
initial matrix, mention the possible modifications to the matrix, and give the final
answer).
[3Marks]
(b) Give the projection of F on R1,R2 and R3(i.e.,R1(F),R2(F) and {:R3(F)).
[2 Marks]
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Information And Database Systems Asian Conference Aciids 2012 Kaohsiung Taiwan March 2012 Proceedings Part 2 Lnai 7197

Authors: Jeng-Shyang Pan ,Shyi-Ming Chen ,Ngoc-Thanh Nguyen

2012th Edition

3642284892, 978-3642284892

More Books

Students also viewed these Databases questions