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.
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.