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:

  • ProductId
  • Contidion (new, 2nd hand)
  • Price
  • etc

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

  • MemorySlots (either 2, 4, etc)
  • MemoryType (DDR2, DDR3, etc)
  • CpuType (Amd, Intel)
  • etc

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

  • ISBN
  • Authors
  • Title
  • etc


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


Browse other questions tagged or ask your own question.