Welcome to WebmasterWorld Guest from 50.19.53.104

Forum Moderators: open

Message Too Old, No Replies

Normalization

mysql

     

frozenpeas

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

coopster

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?
 

Featured Threads

Hot Threads This Week

Hot Threads This Month