Tag Archives: database design

ER Modeling

Posted on September 11, 2015 by way0utwest

I saw someone recently note that an Entity-Relationship model is important for your database development project. That UML is important, and the model should be actively maintained. I agree. However, I’ve usually not seen this done. Typically when I’ve seen … Continue reading →

Posted in Editorial | Tagged , | Comments Off on ER Modeling

No More Foreign Keys?

Posted on August 31, 2015 by way0utwest

I struggle with removing FKs as a general idea. It’s presented in a piece from a developer. It appears to me that if you do this, you are merely moving the problem, and potentially causing other issues. Apart from Grant’s response … Continue reading →

Posted in Editorial | Tagged , | Comments Off on No More Foreign Keys?

Making Guesses

Posted on August 11, 2015 by way0utwest

I was reading a bit about the design and planning stage for a new database that will support some random application. The piece isn’t important, but I did notice one thing. The guidelines are generic, encompassing most of the things … Continue reading →

Posted in Editorial | Tagged | Comments Off on Making Guesses

Defining Foreign Keys at Table Create Time

Posted on July 2, 2015 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. How many of you can define a foreign key when you create the table? Probably a few of you, … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments