BD in Access ---> SQL + WinForm in -Net - Is It Possible??

C

cientocienreg

Hi, sorry for my english, I have a problem of conceptual design of my
database, i hope you can help me.

This is a shop with a variety of articles (Posters, mobiles,
decorative objects among others), which have different
characteristics,

Plates: size, author, image, ...
Moviles: brand, size, weight ....
Flashlight: Power, material, color, ...
.........
.........

I decided to make a table tblCategoria and another tblArticulo:
TblCategoria: id, name, description, picture
TblArticulo: id, category, images, prices

And here i have the problem, I would like how to save every property
of the article depending of the category, if is a lamina then the
article must have all their characteristics (size, author,
image .... ), but if it's a mobile should have (weight, brand,
dimensions ...)

Thanks
 
Top