Results 1 to 3 of 3
  1. #1
    Join Date
    May 2014
    Posts
    1

    Critique database design

    Hello all, I am new to the forums as well as to a job as a clerk. My first hurdle is to bring a little order to our files. I want to create a database to help us locate documents in the office. The database also has to help us keep track of when we legally have to destroy them and when they have been destroyed. The design I have come up with is only to the 2NF I believe. I am very new to database design.

    I have a "Document" table which consists of DocCode, DocName and DocType. I have a second "Destruction" table which consists of DocCode, DestroyDate and DateDestroyed. As I type this I think I will need a third table for storage of permanent documents - DocCode, StorageDate and DateStored seems to be simple.

    I would appreciate any suggestions! Thank you so much for your time!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    If your tables serve your needs, then use them as they are. Nth normal form is a worthy goal but rarely a requirement in business.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jul 2012
    Posts
    40

    A Data Model for you

    Quote Originally Posted by ebr250 View Post
    Hello all, I am new to the forums as well as to a job as a clerk. My first hurdle is to bring a little order to our files. I want to create a database to help us locate documents in the office. The database also has to help us keep track of when we legally have to destroy them and when they have been destroyed. The design I have come up with is only to the 2NF I believe. I am very new to database design.

    I have a "Document" table which consists of DocCode, DocName and DocType. I have a second "Destruction" table which consists of DocCode, DestroyDate and DateDestroyed. As I type this I think I will need a third table for storage of permanent documents - DocCode, StorageDate and DateStored seems to be simple.

    I would appreciate any suggestions! Thank you so much for your time!
    I have drafted a Data Model for you on my Database Answers Web Site :-
    Document Tracking Data Model

    Pls take a look and let me have your thoughts.

    HTH

    Barry in London

Tags for this Thread

Posting Permissions

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