Creating Database

[Warren]

I am trying to design a database that includes a few
different aspects. 1. Tables for weekly sales in different
departments, ie: Sales Table and Sales Category Tables.
The reports to be generated would include Weekly Sales,
Percentage of Total Sales for each Department, and a
Report that would produce a commutative total for all
data; ie: commutative sales, commutative percent of sales,
and etc. I would also like to have tables that would hold
total weekly wage data as to each department. The reports
would include Total wages per department, percentage of
wages as to each department.
The tricky part is how to build the relationships between
the tables when the sales tables (Weekly Sales and Weekly
Sales Detail) and the wage tables (Weekly Wages and Wage
Detail) have no discernable relationship. How can I create
a relationship between the tables or would be better to
create to databases (Weekly Sales and Weekly Wages) and
LINK the tables together to generate the reports?

Thank you in advance

 

[Duane Hookom]

I think you might have a basic misconception about sql databases. There is
generally no reason to create tables for "weekly" usage. You can always
create queries to summarize your data by week or any other date/time
increment. All records should be stored only in their most detailed level.