Database Normalization Slide Deck

Just uploaded the slideshow these posts will be based on. It is from an exercise I use in my college database classes. See link below...

Database Normalization on SlideShare

--Dan

1st normal form violation

The table violates first normal form's rule that all cell values must be unique. See below.

You cannot have two values in one cell. This would introduce numerous problems. You would not be able to do joins on this column. Nor would grouping on the column work correctly. Sorting would not work and so on.

To resolve this issue you need to update the table to correct this entry. below is the corrected table.

This table now has no issues that violate first normal form but it WILL violate second. We will discuss that in our next post.

---Dan D'Urso

We recently created a short course in using Visio 2016 to create ERD's. Visio 2016 does not have a lot of traditional database design tool capabilities such as forward engineering to create scripts but it is simple and rather elegant. And it is already widely installed. Below is the slide deck for the class.

VIS201d Visio Database Diagramming from Dan D'Urso