Using SQL statement to find a Candidate Key when given the functional dependencies

Hey guys....I am completely lost on this and was hoping to get some
input....I need to use an SQL statement to find a candidate when i'm
given this set of functional dependencies CD->E, CD->F, A->B, B->F, A-
>C.

I know the CK is AD but i have no clue where to even start....any help
would be GREATLY appreciated!

On Apr 15, 4:52 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> rana.ja...@gmail.com wrote:
> > Hey guys....I am completely lost on this and was hoping to get some
> > input....I need to use an SQL statement to find a candidate when i'm
> > given this set of functional dependencies CD->E, CD->F, A->B, B->F, A-
> >> C.
>
> > I know the CK is AD but i have no clue where to even start....any help
> > would be GREATLY appreciated!
>
> OK, I have no idea what you're trying to get across. How about showing
> us what you're really trying to do?
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================

Given that set of functional dependencies, i need to create an sql
statement that will show what the candidate key is, those were
instructions handed down

rana.jaber@gmail.com wrote:
> Hey guys....I am completely lost on this and was hoping to get some
> input....I need to use an SQL statement to find a candidate when i'm
> given this set of functional dependencies CD->E, CD->F, A->B, B->F, A-
>> C.
>
> I know the CK is AD but i have no clue where to even start....any help
> would be GREATLY appreciated!
>

OK, I have no idea what you're trying to get across. How about showing
us what you're really trying to do?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

rana.jaber@gmail.com wrote:
> On Apr 15, 4:52 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> rana.ja...@gmail.com wrote:
>>> Hey guys....I am completely lost on this and was hoping to get some
>>> input....I need to use an SQL statement to find a candidate when i'm
>>> given this set of functional dependencies CD->E, CD->F, A->B, B->F, A-
>>>> C.
>>> I know the CK is AD but i have no clue where to even start....any help
>>> would be GREATLY appreciated!
>> OK, I have no idea what you're trying to get across. How about showing
>> us what you're really trying to do?
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstuck...@attglobal.net
>> ==================
>
> Given that set of functional dependencies, i need to create an sql
> statement that will show what the candidate key is, those were
> instructions handed down
>

I still have no idea what you're doing. Probably because you haven't
explained the context used, the database schema and a lot of other things.

As I said - show us what you're really trying to do, not explain in some
abstract terms.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Peter H. Coffin wrote:
> On Sun, 15 Apr 2007 18:08:16 -0500, Jerry Stuckle wrote:
>> rana.jaber@gmail.com wrote:
>>> Given that set of functional dependencies, i need to create an sql
>>> statement that will show what the candidate key is, those were
>>> instructions handed down
>>>
>> I still have no idea what you're doing. Probably because you haven't
>> explained the context used, the database schema and a lot of other things.
>>
>> As I said - show us what you're really trying to do, not explain in some
>> abstract terms.
>
> I don't think I've ever heard anyone ask a question like that outside of
> an academic setting....
>

That very well could be. But I still have absolutely no idea what he's
trying to do.

I'm willing to help, but he needs to present it in a way people can
understand. I haven't been on college for well over 30 years.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================