"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
ommend to go to a (online) bookshop and get a nice book about
developing databases.
gl,
rene
- Original Message -
From: "Jeff Holzfaster" <[EMAIL PROTECTED]>
To: "General MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 4:01 AM
Subject: Dat
I realize this may be a little OT but I'm sure many of us MySQL rookies
would be interested in the responses.
I would be interested in hearing how someone goes about planning the layout
of their database including how they determine what tables, fields, column
types, queries, etc they will need.