Results 1 to 6 of 6

Thread: I need help!

  1. #1
    Join Date
    Sep 2003
    Posts
    34

    Unanswered: I need help!

    Hi,

    At work we have a very simple database with one table like this:

    Member ID.
    First Name
    Last Name
    Flat/House No.
    Street Name
    Town/City
    Phone No.

    This database has over 2000 records. It works OK, except alot of the people in the database are married to other people in the database, so it seems there is alot of duplicate addresses, is this normal??? Is there a better way???

    Cheers, R

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'm not sure how to answer your question, so I'll take it literally. Yes, if you have a table with rows for people and many of those people are part of a family, then you'll get lots of rows with the same address.

    -PatP

  3. #3
    Join Date
    Sep 2003
    Posts
    34
    Is there a better way???

    Seems like a lot of redundant information!

  4. #4
    Join Date
    Nov 2003
    Posts
    1,487
    Create a field within your table for the Spouses name.

  5. #5
    Join Date
    Sep 2003
    Posts
    34
    Nah, they must stay separate records, the dB is bigger than I have suggested.

  6. #6
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Altough normalization is not violated, if there are a large number of duplicate addresses then you can consider creating a seperate address table.

    Address(id)
    Person(id, address_id)
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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