Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Database Theory - Keys and functional dependencies?

Database Theory - Keys and functional dependencies?

From: Christian Hoecht <choecht_at_web.de>
Date: Tue, 12 Feb 2002 13:04:14 +0100
Message-ID: <a4b0c1$tmo$1@news.online.de>


Hello,

I want to solve these exercises:

EXCERCISE:
Find out all Keys (Primary/Foreign) for the following Relation-Types and the kind of Normalization (1NF, 2NF, 3NF, BCNF):

  1. R1 (A,B,C,D) A -> B B -> A AC -> D
  2. R2 (A,B,C,D,E) ABC -> D B -> E A -> C
  3. R3 (A,B,C,D,E,F) A -> B D -> B CE -> AD A -> F

Thank you for your support!

Christian Hoecht Received on Tue Feb 12 2002 - 06:04:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US