In this course, you will learn all the skills required to design good relational databases. This starts with information gathering: how to find all required information, and how to ask questions without miscommunications. You will learn how to abstract the information gathered into a data model, how to normalize the data model so that your database will be free of anomalies, and how to transform the final, normalized data model into a relational database design – ready to be implemented.
Author Name: Hugo Kornelis
Author Description:
Hugo is co-founder and R&D lead of perFact BV, a Dutch company that strives to improve analysis methods and to develop computer-aided tools that will generate completely functional applications from the analysis deliverable. The chosen platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums; reading and writing books and blogs; and attending and speaking at conferences. Hugo is a SQL Server M… more

Table of Contents

• Introduction
  32mins
• ER Modeling
  51mins
• Gathering Information
  33mins
• Creating The Initial ER Model
  46mins
• Converting to Relational
  65mins
• Basic Normalization – Part 1
  80mins
• Basic Normalization – Part 2
  57mins
• Higher Normal Forms
  53mins
• Other ER Methods
  31mins