Tag Info

Hot answers tagged

1

When i did a systems analysis module in my years at university, i was doing my computer science degree. One thing our lecture told us all at the time was something we couldn't comprehend. "Strictly speaking, there is no wrong or right way to approach DBs" As computer scientists this is hard to swallow. lets look at your example: Ok, so you have ...


1

Note, that I assume C# (since this language is present in tags) and Entity Framework. Both approaches assumes, that entity types are inherited from abstract, non-persistent base entity type, which accumulates 75% of fields, so the code base discussion is not relevant. Pros of Table-Per-Hierarchy (all descendants are stored in single table): database ...



Only top voted, non community-wiki answers of a minimum length are eligible