Software Inventory Database Design

[andy1970]

I am having a problem designing the tables for this database where there are fields that aren't empty or records duplicated.

I have a software table

tbl_Software_Product

Software_info_ID PK
Manufacture
Product
Type

Here is my problem now: a software product may or may not have a size and may or may not have a version --example data:

Manufacture: Microsoft
Product: Windows XP
Version: Pro SP2
Size: 32 Bit

Manufacture: Adobe
Product: Reader


Version: 10.1

Manufacture: Creative Labs
Product: SoundBlaster X-Fi

I want to create the tables so that I don't have duplicate data and avoid having empty fields or nulls
and suggestions would be great.

[ssanfu]

Maybe this structure?
Attachment 8210


The field "SpecDesc" in table tbl_SpecTypes would have:

Version
Size