PC Builder System - Database Design

[thejman82]

I would like some help on this database design I need to have completed by next week. Here's the specs:

I'm creating a custom PC builder application. I've been getting stuck on trying to create the database for it. I would like to be able to enter customer details then select from drop down menu's each part in each category for a complete computer system.

http://i53.tinypic.com/a0e4o3.png

There is a screenshot of my first shot at designing the database in SQL Server 2008.

I'm a little bit confused as to what to do with the associative table and what to do with primary keys etc. I might be going about this entirely in the wrong way as well so if any database design "experts" can give me some pointers that would be much appreciative.

Thanks

[debasisdas]

Why name and address is stored in Computer table ?

There should be a separate table for customer.

[thejman82]

Why name and address is stored in Computer table ?

There should be a separate table for customer.

Yeah I had originally set that up but my instructor (this is a project for school) had told me that I could put both in the same table under the assumption that customers won't be returning customers as most people do not purchase PC's on a regular basis.

Anyhow the main problem I have is how would I link the components table to computer table. I know I need an associative entity table called ComputerComponents I guess.. But as to to what or how to come up with the primary keys I'm pretty confused and kinda stuck at this point.

[debasisdas]

Why about a separate Orders table.