Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Screen. 1 20 Subject: Time : 1 Hour 45 minutes Note: Q. 1 is compulsory. Q1 (5*3=15) JAM) - SB (a) The following functional dependencies
Screen. 1 20 Subject: Time : 1 Hour 45 minutes Note: Q. 1 is compulsory. Q1 (5*3=15) JAM) - SB (a) The following functional dependencies are given: AB CD, AF D, DE F,C G,F EG A Verify the following and state if true or false. i. {CF}* = {ACDEFG} ii. {AE }* = {ACDEFG} What is a candidate key for the relation R(A, B, C, D, E, F, G) (b) For the relation R(A, B, C, D) and FD set: {A B, ABC, CD, can we derive i. A ii. BD BCD (c) Show that ABis a relationship A:B::N:1
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started