Welcome to WebmasterWorld Guest from 54.205.75.60

Forum Moderators: open

Message Too Old, No Replies

Normalization

mysql

   
11:47 pm on Feb 12, 2007 (gmt 0)

5+ Year Member



I have 2 tables in mysql:

TABLE Files
file_id model_number file_thumb file_date
1 43 43.jpg 2007-01-01
2 65 65.jpg 2007-01-01
Autoincrement on file_id

TABLE Sales
sale_id file_id total_day_sales sale_date
44 1 12 2007-01-02
45 2 22 2007-01-02
46 1 14 2007-01-03
47 1 10 2007-01-05
Autoincrement on sale_id

Is this normalized as far as it can go. I am concerned that the Sales TABLE will contain duplicate sale_dates even though they may be for different file_id

Thanks

4:44 pm on Feb 21, 2007 (gmt 0)

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member



It's hard to tell without a description of what your sales table is defined as. What does it contain, in plain language? Sales for each item for each day it was sold?