Database Design

R

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top