Results 1 to 5 of 5
  1. #1

    Calling All DBAs / Those Who Love Normalization

    I am in the midst of building a quick database, but I want to get it off on the right foot.

    It going to be essentially modelling a tree structure:

    Code:
    parent
    =======> child(psedu-parent)
    	========> child
    	========> child
    	========> child
    	========> child
    	========> child (psedu-parent)
    		  ======> child
    each entity, either a parent or a child, is similar in that they have the same attributes. However, the only way of denoting a parent is that it has children underneath it. A parent may also have a parent, but it may not if it is the top line item.

    Any recommendations on table structure? Trying to minimize data duplication.

    first thoughts:
    --table1--
    relationID pk unique
    parentName
    itemName fk REFERENCES table2(itemName)
    relationalAttribute1
    relationalAttribute2

    --table2--
    UID pk unique
    itemName
    itemProperty1
    itemProperty2

  2. #2
    Join Date
    May 2007
    Posts
    315
    Data duplication does not exist in any properly designed database schema. I would recommend obtaining a book on database theory. What you seem to be referring to are key relationships between tables. However, you are not using the correct terminology, thus intelligent answers are unlikely to follow. Google also has many hits relevant to introductory database design.
    How to spot a hosting reseller:
    a. ping "web-hosting-company".com. Search that IP at arin.net.

    b. the company displayed by arin.net has full network and likely server control and is the real provider
    A 99.999% SLA means nothing when 90% of the service continuince is beyond the control of the reseller.
    RapidVPS - Intelligent and Reliable VPS Hosting since 2004

  3. #3
    Correct, I am trying to reduce duplication as the db tables in place are riddled with it.

    The only duplication I have mentioned above is a foreign key reference, nothing to worry about really.

  4. #4
    Join Date
    May 2007
    Posts
    315
    How to spot a hosting reseller:
    a. ping "web-hosting-company".com. Search that IP at arin.net.

    b. the company displayed by arin.net has full network and likely server control and is the real provider
    A 99.999% SLA means nothing when 90% of the service continuince is beyond the control of the reseller.
    RapidVPS - Intelligent and Reliable VPS Hosting since 2004

  5. #5
    Thank you sir, will take a look!

Similar Threads

  1. Shell scripting experts - question on IP address normalization
    By pmabraham in forum Programming Discussion
    Replies: 8
    Last Post: 07-30-2008, 04:56 PM
  2. PHP / MySQL Database Normalization.
    By php4ever in forum Programming Discussion
    Replies: 2
    Last Post: 04-14-2007, 07:14 AM
  3. Mysql ENUM and normalization
    By innova in forum Programming Discussion
    Replies: 8
    Last Post: 07-20-2005, 11:05 AM
  4. DBAs and LLCs
    By neonlexx in forum Running a Web Hosting Business
    Replies: 11
    Last Post: 07-20-2003, 01:17 PM
  5. DBAs and LLCs
    By neonlexx in forum Running a Web Hosting Business
    Replies: 6
    Last Post: 03-24-2003, 04:26 PM

Posting Permissions

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