| Welcome to WebmasterWorld Guest from 18.104.22.168 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
I have 2 tables in mysql:
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
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
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?
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved