Results 1 to 9 of 9

Thread: Help!

  1. #1
    Senior Member
    Join Date
    Jan 2002
    Location
    east side
    Posts
    1,937

    Default Help!

    This is a long shot but kinda need help

    Has anyone in this forum ever took Computing Degree?

    Or Does anyone here understand Object Oriented Analysis and Design topic : Normalization?????



    struggling with assignment...was hoping if there might be someone out there who could help

    thanks

  2. #2
    Senior Member
    Join Date
    Mar 2002
    Location
    somewhere near...
    Posts
    2,114

    Default Re: Help!

    Originally posted by eadwine
    This is a long shot but kinda need help

    Has anyone in this forum ever took Computing Degree?

    Or Does anyone here understand Object Oriented Analysis and Design topic : Normalization?????



    struggling with assignment...was hoping if there might be someone out there who could help

    thanks

    It means NEVETS OT YENOM RUOY LLA EVIG.

    Read it backword.
    heh

  3. #3
    Senior Member
    Join Date
    Jan 2002
    Location
    east side
    Posts
    1,937

    Default

    what talking u

  4. #4
    Senior Member
    Join Date
    Mar 2002
    Location
    somewhere near...
    Posts
    2,114

    Default

    Originally posted by eadwine
    what talking u
    read it backword..

  5. #5
    Senior Member
    Join Date
    Jan 2002
    Location
    east side
    Posts
    1,937

    Default

    so what has it got to do with my post?

  6. #6

    Default

    Are you talking about database normalization?

  7. #7
    Senior Member
    Join Date
    Jan 2002
    Location
    east side
    Posts
    1,937

    Default

    Originally posted by maddog
    Are you talking about database normalization?
    YES YES!!!

  8. #8

    Default

    why is it under OOAD? strange.. anyway..

    imagine u got data and want to organise it.. e.g. clubsnap has members. and the members create posts.
    imagine the raw data.

    member post# title1 body1 forum1 title2 body2 forum2
    --------------------------------------------------------------------------------
    eadwine 1439 Help! blah.... banal long way blah.. abstracts


    Notice a lot of repeating groups. So we need to optimize it.
    First step. Remove repeating groups. 1st Normalized form.


    member post# title body forum description
    ----------------------------------------------------------------
    eadwine 1439 Help! blah.... banal anything goes
    eadwine 1439 long way blah.. abstracts unusual forms

    Still not good enough. Eliminate redundancy. 2nd Normalized form.
    Create a member table and a post table.

    Member table
    ==========
    name post#
    --------------------------
    eadwine 1439

    Post table
    =======
    ID Member title body forum description
    ------------------------------------------------------------------
    1 eadwine Help! blah.... banal anything goes
    2 eadwine long way blah.. abstracts unusual forms


    Still room for improvement. Eliminate data not dependent on key. Take out description and store it elsewhere. 3rd Normalized form.

    Forum table
    ========
    name description
    ----------------------------
    banal anything goes
    abstracts unusual forms

  9. #9
    Senior Member
    Join Date
    Jan 2002
    Location
    east side
    Posts
    1,937

    Default

    oops under DBMS sorry hee...blur liao

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
  •