Table design

[PWG]

After months of redesigning a Microsoft template to do what i wanted. With the help of to great people here I found out that the table design was no good and that i would continue to have many problems.
So I have started from scratch.Please find attached my tables and relationships for any suggestions or advise on any issues you can see. All comments would be greatly appreciated.
It will be a purchasing inventory data base.

 

[jdraw]

PWG,

Nobody can comment on your tables and relationships without knowledge of your business. Tables and relationships reflect the business entities and attributes and the rules/facts of the business. It all starts with a clear description of the business processes and related rules.

eg. A Product may be obtained from 1 or Many Suppliers...

Some info on Business rules.

An overview of Business Requirements Modelling.

An approach to database design from Barry Williams' site.

Good luck with your project.

 

[isladogs]

Agree with jdraw though I did advise in your previous thread.

Two general comments.
You have 8 tables with just a primary key and one other field. Some of those tables may well be superfluous.
Your relationships window has too many links and some tables may possibly end up as read only. In general there should only be one route to any table in the relationships window. Many of your tables can be reached in multiple ways.