SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2004
    Location
    Spencer, IN USA
    Posts
    36
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    creating a software catalog DB

    I am working on a software catalog for my company. Within the program table we have various program info such as PID (program ID primary key)program name, created date, etc.

    I am trying to put a 'calls' table in place in which I would be able to show which programs a certain PID calls.

    Problem is, you have one PID referencing another PID within the same table. So all I end up with is a table containing two PIDs!

    Can anyone tell me the best way to handle this?

    thanks!
    Former atheist turned Believer in Jesus Christ on 02-23-00.
    (and NO it wasn't "Ten Easy Steps!")

    Join the PHP community!

  2. #2
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    normalization
    Read up on this

    Atomicity


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
  •