"Company of Harware" ERD ..... ideas ?!

[Hany Freedom]

is anyone have any ideas about what the ERD of Company sell computer Hardware should be ?

 

[georgedwilkinson]

It is very similar to an auto parts or retail model. However, unlike (most) auto parts, you'll need to track serial numbers for some of your items. That may mean that each of some "parts" has its own row in a related table.

 

[Hany Freedom]

thanks georgedwilkinson for your answer......... but I need real examples for the ERD of Company sell computer Hardware , photos or access files ....... still waiting for any answers ..........

 

[Hany Freedom]

I found ERD like that :-

I want to understand , what exactly he mean by staff members table ?!

 

[Rabbie]

I found ERD like that :-

I want to understand , what exactly he mean by staff members table ?!

The Staff members table is there so you can record which member of staf was responsible for each transaction.

 

[georgedwilkinson]

This ERD is not sufficient for what you are doing. It is obviously just a training device, not a template.

 

[Hany Freedom]

thanks georgedwilkinson very much .
I hope if there any suggests help me to make a full ERD for " Hardware Sales Company "