What is the Normalization Level for this Relation? RRS feed

  • Question

  • Hi dear all,

    Recently, A question regarding Normalization in Relational Databases have been made in my mind, and I haven't achieve the answer yet!

    Consider relation R as below:

    R=(A, B, C, D)

    and also consider Functional Dependencies as below:

    AC -> BDE

    AB -> CDE

    BC -> E

    So I wanna know what is the normalization level for this Relation?

    Also think about the same Relation R with Functional Dependencies varied as below:

    AB -> CD

    AC -> D

    what is the normalization level for the above?

    This question have driven me crazy, So I really really appreciate anybody answering it!

    thank you all.

    Monday, December 27, 2010 3:51 PM