Database Design

[Rio]

I am designing a budget database. The budget data is
captured per week for the year. Two of the tables in my
database are designed as shown below.


Table 1: Budget table
BudgetID – Autonumber (PK)
Project Name
Department
Accounting General Ledger Code
Year


Table 2: Budget details table
ID – Autonumber (PK)
BudgetID – from Budget table
WeekNo
Amount


Is this a good design or should I make any changes? Any
comments are appreciated. Thanks for your help!

 

[Terri Pecora]

As a suggestion, I would move Year into the Budget details
table. This way you can store multiple years in the
detail table with only 1 entry in the Budget Table.

Thanks
Terri