Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon. Entire thread

Database Design

Name: Anonymous 2011-05-22 11:50

Can anyone give me a hand, i know it will be pretty basically and i've been to stack overflow already. But im pretty noob at database design/relations etc.All I need is to calculate the closure for A+ and E+

G = {A, B, C, D, E, F, G}

with the following FD's
1) B -> ACDE
2) E -> FG

Any help would be appreciated.

Name: Anonymous 2011-05-22 12:36

>>1
I am not sure how it works on Database Design, but given we are talking about closures, you must take the relations that they give you and expand them until you get a set of elements that cannot be expanded. Something like this, i guess:

{A} -> Cannot be expanded, therefore Closure(A) = {A}
{E} -> {E, F, G} -> Cannot be expanded, therefore Closure(E) = {E, F, G}

Treat this advice carefully since it is a general explanation for closures.

Newer Posts
Don't change these.
Name: Email:
Entire Thread Thread List