"Sica, Bill" wrote:
> For instance, say the book price is
> $19.44. You also have a base cost of $18, and 8% tax. You can always write a
> query to find out the total cost of any book, and get rid of anything to do
> with the total cost in your tables.
For all the people who've never designed lo
I just got done figuring out how to --100%-- normalize a database to
make it very flexible. Methinks that Oracle has done this in some
fashion, as they claim to be able to make an intersection from any row
in any table to any other.
A note: Objects, Actors, and Attributes use the names of the ta
),
which I use where I work.
cost:
cost_id
book_id
curCost_base
intCost_tax_rate
curCost_total
-Original Message-
From: René Tegel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 2:45 AM
To: Jeff Holzfaster; General MySQL List
Subject: Re: Database Planning
well, start with
well, start with reading a book about designing databases, especially about
the subject 'normalisation'.
normalisation is a way to split up data ('entities') in a way that every
piece of data only occurs once in your database. (although sometimes for
practical reasons you may decide otherwise, but
