Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2012
    Posts
    2

    DB design for Work Order

    I'm designing a relational database to get rid of our current system of manual excel sheet input as we're going paperless.

    Tho I've never made a relational DB before as i've only ever needed one table or such for past experiences.

    Attached I have what I've done so far in terms of planning. From what I've read I need a super key to relate my DB together.
    Since my database keeps track of daily work orders and work done I'd assume any table that will be updated daily will need a Date column.
    Than any other column that needs information from another table will be connected aswell(foreign key)

    Please point out any flaw in my logic (like am i using the right keys?)as im not 100% sure this is how you make a relational database.
    Thanks.
    Attached Thumbnails Attached Thumbnails RDB.JPG  

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    "If need more info each unique id can have a table where it has more info on them."
    Well, there's a problem with your design right there.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Aug 2012
    Posts
    2
    Quote Originally Posted by blindman View Post
    "If need more info each unique id can have a table where it has more info on them."
    Well, there's a problem with your design right there.
    sorry, thats just a memo for me if i needed more information on the employee I'd have another table referencing their id with more information(address etc).

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    ...which is absolutely the wrong thing to do.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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