Over the last few blog posts, I’ve been talking about keys – both primary and foreign. Now, we can use these to get a great ERD for all of our users. First, let’s open up our ERD tool. In this case, we’re going to use the SQL Database Modeler – a tool I talked about…… Continue reading Reverse Engineer an ERD – How to
Tag: ERD
Foreign Keys – Are they worth it?
Last time, we learned about Primary Keys and some of the goodness that they give you. If you missed that, remember to go back and read that here. This time, though, we want to focus on the close kin of primary keys – the foreign key. Foreign Keys are truly columns that point to the…… Continue reading Foreign Keys – Are they worth it?