Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    10

    Unanswered: Basic database design question

    Hello all -

    so in a few months I am about to become Oracle Certified, and the only experience I've ever had with designing and creating 'tables' was in a DBA class in college years ago. However, I have over 10 years experience in system admin and basic database admin on HP, IBM, and SQL servers.

    So here are my questions: What is the best way to practice database design?How do you determine the tables and fields that are necessary for those tables? What methods do you use to normalize the data?

    I have all the experience doing backup/recovery, replication, re-indexing, performance issues, but I lack the logical knowledge of database design.

    I greatly appreciate all input thanks very much!

    G8KYPR

  2. #2
    Join Date
    Oct 2004
    Location
    Oklahoma City OK -
    Posts
    122
    Oracle offers Database Design / data modeling courses, 'Designer 2000'
    the short answer is:

    Identify entities

    Identify attributes of those entities

    Identify relationships between thos entities

    Normalize to reduce data redundancy ,


    also here is one of many web sites.

    http://www.datamodel.org/NormalizationRules.html

  3. #3
    Join Date
    Nov 2004
    Posts
    10
    Quote Originally Posted by wrwelden
    Oracle offers Database Design / data modeling courses, 'Designer 2000'
    the short answer is:

    Identify entities

    Identify attributes of those entities

    Identify relationships between thos entities

    Normalize to reduce data redundancy ,


    also here is one of many web sites.

    http://www.datamodel.org/NormalizationRules.html
    Thanks for the information, wrwelden. Greatly appreciated.

Posting Permissions

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