Re: 1NF to 3NF

albrrat wrote:
>
> ORIGINAL STARTING FORM
>
>
> AC_NUM = aircraft number
> MODEL = model of the plane
> MANUF = manufacturer of plane
> TYPE = type of plane (single engine etc..)
> AC_CHARGE = aircraft charge per hour
> DATE = date flown
> TYPE = type of instruction
> HOURS= hours flown
> INSTR = flight instructor
> I_Charge = instructor charge
> TTAF = total time on air frame
> TTEL = total time on left engine
> TTER = total time on right engine
> CUST = customer number
>
> given this information I neet to convert from first normal form to third
> normal form. I am having trouble understanding partial and transitive
> dependancies. How do I break this down when the composite primary key is
> CUST, HRS, DATE and AC_NUM?

That depends on the functional dependencies that you think hold. Can you give a complete list?

-- 
  Jan Hidders