i d like to pick your brains about something..
Suppose i want to create a database for storing, lets say computer stuff, parts, hardware, peripherals etc....
Which way would be better?
Create a Basictable with all the common fields (like ProductName, Price,Guarantee....)
and then create multiple other tables with each categorie's specific fields and binding those tables with the Basictable with one-to-one relationships..
Create just one table with all possible fields and keep Null values in the fields that are not needed for specific categories..
or maybe a third way.. ?
Thanx in advance..