So, this is kind of a compound question, but they go together, and definitely wouldn't make sense split up into separate questions.
I've been working on a new database for what will end up being a programmer's blog/portfolio, with the occasional tutorial or demonstration, written in ASP.NET MVC 5 and Entity Framework 6. About halfway into designing the database schema, I noticed almost all of the tables contained the same 5 basic columns: ID, Title, Description, DatePosted, and URLStub. While not necessarily redundant, as most of the data would be unique, except maybe where an article is linked to a Demo, it looks wrong or sloppy.
This is the model I initially set out making:
I swear I auto-arranged/auto-sized those tables
And this is what I ended up shifting towards, but I still feel like I'm doing something stupid:
- Is the new model even plausible with entity framework?
- Is it an improvement (more normal) over the first one?
- Should I have even worried about the first one?
- Can anyone see anything inherently stupid with the new model?
Thank you in advance for any input, and also sorry in advance if this is going to "create too much discussion" or is "primarily based on opinion".. I don't really know a better place to ask this, and get knowledgeable answers.