Results 1 to 3 of 3

Thread: Tips to design table in SQL 2005

  1. #1
    Join Date
    Nov 2009
    Posts
    351

    Tips to design table in SQL 2005

    I am learning to work with the SQL database. Currently I am trying to work on SQL 2005. My instructor has said that for developing good software you have to design the correct database table, because table are the basic keys while developing the software or the database design. So I am really in need to know the tips for making the tables in database of SQL 2005. I do not want to make a mess of my table in the database or not I want to change the table design in future.

  2. #2
    Join Date
    Apr 2008
    Posts
    439

    Re: Tips to design table in SQL 2005

    There are many tips for designing a good table design in the SQL 2005. I will like to mention some of these.
    1. You must normalize your table in SQL this will help you to get rid of entering the same data at different places.
    2. Do not forget to enter the primary key in each and every table you create in the database
    3. Now if you are creating primary key for your table then it will be better to choose the numeric primary key for your table. Using the non-numeric primary key will definitely lead to problem in future.
    4. This does not mean that you cannot keep the primary key for your table. For example if you want to create the primary key for the countries then it is better option you do not have to create a separate number for the countries. The countries names are not going to be repeated.

  3. #3
    Join Date
    Apr 2008
    Posts
    586

    Re: Tips to design table in SQL 2005

    According to me tips mentioned in the above replies are the basic level tips. Do not forget to use these tips but also consider the tips given below.
    1. Design you table in such a way that they can participate in the relationships. Relationships can be of one is to one or it can be one is to many. Creating the relationship will definitely help to remove the irrelevant data in the database.
    2. Try to choose the best data type and the size for your field in your table. Choosing the correct data type will definitely help you to improve the performance of queries you are going to use.

Similar Threads

  1. Missing table tool design tab in Excel
    By Lanka Boy in forum Windows Software
    Replies: 2
    Last Post: 06-01-2012, 07:56 PM
  2. Replies: 5
    Last Post: 27-08-2011, 10:53 AM
  3. Link a Table to another Table to Drop Down In Main Table
    By himeshRES in forum Windows Software
    Replies: 6
    Last Post: 11-12-2010, 02:01 PM
  4. Design view table in Microsoft access 2007
    By Balamohan in forum Windows Software
    Replies: 5
    Last Post: 08-01-2010, 04:41 AM
  5. Brochure Design Tips
    By MILFORD in forum Tips & Tweaks
    Replies: 1
    Last Post: 27-12-2009, 06:24 AM

Tags for this Thread

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
  •  
Page generated in 1,708,838,427.22242 seconds with 17 queries