Results 1 to 6 of 6
  1. #1
    Join Date
    May 2008
    Posts
    9

    Question Regarding first 3 Normal Form

    Pls see the attach file and Explain the Answer
    Attached Files Attached Files

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    So - the message has still not got through that you won't get your homework done for you here huh? Demonstrate a modicom of effort on your part or stop posting your assignments.
    http://www.dbforums.com/showthread.php?t=1630730
    http://www.dbforums.com/showthread.php?t=1630702

  3. #3
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Dear dbconcept

    To save you doing any work perhaps you should just give us the email address of your lecturer and we’ll send our answers directly to him.

    Mike

    PS What name should we sign it?

  4. #4
    Join Date
    May 2008
    Posts
    9
    Ok
    Here is my effort

    First Normal Form

    Yes the Student_Credithours is in first Normal Form

    2ND Normal Form

    No it is not in 2NF. we will split the table into three Tables i.e.
    Student (StdId , StuName,age) PK stdid
    Discipline ( Disciplineid, Disciplinename,totalCreditHr) PK Disciplineid
    Student_Credithour (StdId, Disciplineid, EaranedCredithr) FK StdId, Disciplineid

    Pls correct if i am wrong and for 3rd NF pls help me out pootle flump

  5. #5
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Disciplineid, Disciplinename,totalCreditHr are not part of the question. There is no requirement to invent new attributes.

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by dportas
    Disciplineid, Disciplinename,totalCreditHr are not part of the question. There is no requirement to invent new attributes.
    he hasn't copy/pasted the entire assignment

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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