Relative Content

Tag Archive for c#databaseentity-frameworkdatabase-design

Database Design: Choosing Between Table Inheritance and Table-Per-Hierarchy for User Types

I am confused about creating a database and I need your help. I want to create a small-scale hospital management system. Here I want to create my users using Microsoft.Identity, but the point I am stuck at is that I will have more than one type of user. For example, doctors, patients, staff and visitors. Here, the users will have different properties and different tables that they will be connected to. How should I create my tables considering these? I have a few methods in mind, but I couldn’t decide which one is the best.