Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    San Diego

    Transitive Dependence et al

    Any recommendations for any Windows and/or Linux tools to help
    normalize a database? It's essentially a combination of several
    existing databases (that have some related information) into a single

    Also, recommendations for books on the theory of database design,
    especially a temporal relational database, would be appreciated.

    Finally, say you have a piece of info that's a direct consequence
    of other pieces of info (>1) in a table, but that is quite computationally
    intensive to calculate. Would putting it into the table violate
    3NF and the transitive dependence condition? I'm gathering that this
    isn't the case. I'm uncertain, however, how best to document that
    it's a function of other information in the table. A separate table,
    with a concatenation of the functional dependencies being the
    primary key?


  2. #2
    Join Date
    Dec 2003
    DBDesigner (google it) is a very powerful modeling tool available in XP and Linux. It's free.

  3. #3
    Join Date
    Apr 2002
    Toronto, Canada
    computationally expensive? store it

    if you don't keep any documentation outside the database itself, then i would recommend giving it a column name that makes it clear

    create table dilbert
    ( id integer not null primary key
    , name varchar(30)
    , foo integer
    , bar float
    , qux decimal(10,2)
    , calculation_results_based_on_values_of_foo_bar_and _qux integer
    ) | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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