DB For Inventory Control

[blueraincoat]

Hi All, recently i'm working on a database for inventory control for a repair shop.


The main purposes of this database is to provide a report of the parts replaced to repair a unit, check if the stock level is enough for further repair, and check how much is our inventory value.
I made the tables of this inventory, but i don't if it would work fine. The relationship is attached please help check and give some suggestion. Any comment is appreciated. Thanks in advance.

[orange]

There is a data model here that may be of use to you.
http://www.databaseanswers.org/data_...pair/index.htm

[blueraincoat]

Thank you orange
One thing I'm worried about is if i should add an autonumber and make it the PK in the tables, what do you think ?

[orange]

Thank you orange
One thing I'm worried about is if i should add an autonumber and make it the PK in the tables, what do you think ?

Yes, and the autonumber PK is for the physical database. It shouldn't mean anything special to you.

Good luck with your project

[blueraincoat]

OK I see,thank you.