homepage Welcome to WebmasterWorld Guest from 54.204.94.228
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Normalization
mysql
frozenpeas

5+ Year Member



 
Msg#: 3250643 posted 11:47 pm on Feb 12, 2007 (gmt 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

 

coopster

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



 
Msg#: 3250643 posted 4:44 pm on Feb 21, 2007 (gmt 0)

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?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved