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