addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1light-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Data sig: SQL: We Have Normality- Kevin Feasel, Diane Wilson

We Have Normality - Diane Wilson and Kevin Feasel

The relational database architecture stands on solid mathematical footing. Central to the math behind the relational architecture is the concept of normalization.

This presentation goes through each of the major normal forms, describing (with examples each step along the way):
- how to get into each normal form,
- why you want to be in that normal form, and
- how to recognize when you are not in that normal form.

This talk will show you exactly why good normalization technique is vital in relational database design.

In addition, we will work through an example of normalizing a single data model from 0NF through 5NF.


Diane is a senior software engineer with Fujifilm Medical Systems, where she wrestles daily with SQL Server, Oracle, and occasional alligators.

Kevin Feasel is a database engineer at ChannelAdvisor, where he specializes in database design, performance tuning, and pulling rabbits out of hats on demand. He can be found cycling the trails of the Research Triangle whenever the weather's nice enough.

Join or login to comment.

  • Deepak A.

    Awesome presentation.

    1 · August 21, 2014

  • Maria S.

    Thanks for the class. Very informative and interesting. :-)

    1 · August 21, 2014

  • Charles A J.

    Big Data was mentioned as a future topic. I mentioned that there is a talk today (21-Aug-2014) that was sold out which covers Big Data. I'm wrong. 7 tickets available. details... http://www.rtp.org/rtp180 and https://www.eventbrite.com/e/rtp-180-big-data-tickets-12489637843?aff=eorg

    1 · August 21, 2014

  • Kevin F.

    Quick note for all. The slides and code are currently up at http://www.catallaxyservices.com/presentations/We-Have-Normality/ and available for your pre-perusal. If you grab files, make sure to grab the KingCrimson.zip file--that's the set we'll be working from during "lab" time.

    I'd recommend grabbing the files but not going too far into it before the talk. Unlike the MVC series, this is not really a "you can just as easily do this at home" type of presentation; the demos integrate fairly tightly into the presentation itself.

    1 · August 16, 2014

  • Ian C

    A night out with the Boyce, I wish I Codd make it.

    3 · August 15, 2014

    • Leo L.

      You forgot to mention the gals, but if this joke is sexist I can't determinant.

      1 · August 15, 2014

    • Kevin F.

      Your bad puns aren't normal, guys.

      2 · August 16, 2014

Our Sponsors

  • CODE Magazine

    Get your FREE subscription today!

  • JetBrains

    Provides TRINUG free licenses for any product at our Main Meetings!

  • Syncfusion

    Click for the free e-book library, the Succinctly series!

  • Pluralsight

    Thank you!

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy