SitePoint Sponsor

User Tag List

Results 1 to 8 of 8

Thread: Help with 3NF

Threaded View

  1. #1
    SitePoint Member
    Join Date
    Nov 2008
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help with 3NF

    Hi there i have been asked to normalise this problem to 3NF:

    Cooking( rID, rname, (ingredientID, ingredientName, amount), cookID, cookName, cookPhNumber);

    These are the functional dependencies:

    cookID -> cookName
    cookID -> cookPhNumber
    rID -> rname
    rID -> cookID
    ingredientID -> ingredientName


    The solution that i have come up with is as follows:

    Cooking( rID, rname)
    Cooks(cookID, cookName, cookPhNumber)
    Ingredients(ingredientID, ingredientName, amount)

    Im just wondering if this is correct?
    Thanks
    Last edited by xtrrr; Nov 27, 2008 at 11:10.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •