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:
Contidion(new, 2nd hand)
But each product also has some specific fields. For example, a mother board has
MemorySlots(either 2, 4, etc)
MemoryType(DDR2, DDR3, etc)
Another product, for example, is a book. It has:
How can I manage the product-specific fields in a database?