Question: a . Consider the relation R ( L , M , N , O , P , Q ) and a set of functional dependencies

a. Consider the relation R(L,M,N,O,P,Q) and a set of functional dependencies
F ={LNO->M, MN->LOP, N->O, OP->LN}.
[2pt] Can we infer NP -> LM from F ? Show your work
[3pt] Can we infer NQ -> LO from F ? Show your work
b.[10 pt] Consider R (O,P,Q,R,S,T) to be a relation schema, and let
F ={O -> P, Q -> O, PR -> Q, RS -> T} be a set of funconal dependencies (FDs).
Infer at least five new FDs by using Armstrongs axioms and their derived
inference rules. You must use a different rule per answer

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!