How to design a database with product-dependent columns?

Asked Apr 25 '19 at 01:37

Active Apr 25 '19 at 01:37

Viewed 24 times

I am very new to database design. I have a task to create an inventory program with asp.net core and entity framework core.

The inventory program will be used to manage various kind of products. Products have some common fields (aka columns) such as:

But each product also has some specific fields. For example, a mother board has

Another product, for example, is a book. It has:

Question

How can I manage the product-specific fields in a database?

asked Apr 25 '19 at 01:37

Display Name