Results 1 to 4 of 4

Designing a growing database

  1. #1
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    399

    Designing a growing database

    Hello,

    Could someone provide me advice on what is the best way to design a growing database.
    Should I create Index on every table.

    And what is your advice on some of the best practice and standard to go by ? For example after I design it and create it, how does an expert know or not know if someone good or expert has design it. What would be the tell tale signs and how do I avoid those pitfalls ?


    I want to create this on SQL server.

    And does anyone have any good documentation on 1st to 3rd Normal form ?
    Please advise ! Thx

  2. #2
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,205
    Quote Originally Posted by johnseito View Post
    And does anyone have any good documentation on 1st to 3rd Normal form ?
    This should get you started on normalization concepts.....

    Normalization Terms and Concepts http://www.utteraccess.com/wiki/Norm...s_and_Concepts
    Normalization http://www.utteraccess.com/wiki/Normalization


    What is Normalization?
    =======================
    What Is Normalization, Part I: Why Normalization? http://rogersaccessblog.blogspot.com...on-part-i.html
    What Is Normalization, Part II: Break it up. http://rogersaccessblog.blogspot.com...n-part-ii.html
    What Is Normalization: Part III: Putting It Back Together http://rogersaccessblog.blogspot.com...-part-iii.html
    What is Normalization: Part IV: More Relationships http://rogersaccessblog.blogspot.com...n-part-iv.html
    What Is Normalization: Part V: Many-to-Many Relationships http://rogersaccessblog.blogspot.com...on-part-v.html

    The Normal Forms
    =========================
    The Normal Forms: Introduction http://rogersaccessblog.blogspot.com...roduction.html
    The Normal Forms: First Normal Form (1NF) http://rogersaccessblog.blogspot.com...-form-1nf.html
    The Normal Forms: Second Normal Form (2NF) http://rogersaccessblog.blogspot.com...nd-normal-form.
    The Normal Forms: Third Normal Form (3NF) http://rogersaccessblog.blogspot.com...rmal-form.html
    The Normal Forms: In a Nutshell http://rogersaccessblog.blogspot.com...-nutshell.html



    Entity-Relationship Diagramming
    ==============================
    Entity-Relationship Diagramming: Part I http://rogersaccessblog.blogspot.com...ng-part-i.html
    Entity-Relationship Diagramming: Part II http://rogersaccessblog.blogspot.com...g-part-ii.html
    Entity-Relationship Diagramming: Part III http://rogersaccessblog.blogspot.com...ming-part.html
    Entity-Relationship Diagramming: Part IV http://rogersaccessblog.blogspot.com...-i-ii-and.html



    Microsoft Access and SQL Server Database Normalization Tips http://www.fmsinc.com/tpapers/genacc...abasenorm.html
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  3. #3
    Western_Neil is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2016
    Location
    Calgary, AB
    Posts
    121
    A good design comes from : knowing your data, understanding the output required, understandable tables and fields, and protecting the integrity of the data. The last one comes from using code, procedures, authorization, and data masks to insure integrity of the data.

    Follow Steve’s hints and remember DB is not a spreadsheet, it will not be easy to read without using a queries.
    and From Orange look at http://www.accessforums.net/showthread.php?t=65220&p=352133#post35213

    and http://www.accessforums.net/showthread.php?t=76397
    Western_Neil

  4. #4
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    399
    Thank you for the valuable information.
    I am going to look more into it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Designing a database
    By kwelch in forum Database Design
    Replies: 4
    Last Post: 10-23-2016, 10:34 AM
  2. Need help designing a database
    By docpanderson in forum Programming
    Replies: 4
    Last Post: 07-01-2014, 02:03 PM
  3. Replies: 2
    Last Post: 01-14-2013, 10:27 PM
  4. Designing a database for a log
    By neo651 in forum Database Design
    Replies: 3
    Last Post: 10-31-2011, 10:45 AM
  5. Help with designing database
    By nimalp in forum Access
    Replies: 6
    Last Post: 09-15-2010, 09:34 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums