Welcome to WebmasterWorld Guest from 54.158.212.93

Forum Moderators: open

Message Too Old, No Replies

Normalization

mysql

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

Junior Member

10+ Year Member

joined:May 18, 2006
posts:68
votes: 0


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)

Administrator

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

joined:July 31, 2003
posts:12548
votes: 2


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?
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members