This Tutorial has been provided at the request of Microsoft by Barry Williams, Principal Consultant with Database Answers.
It is featured on the Microsoft SQL Server Web Site

Tutorial on "How to Understand a Database Schema" - Slide 1 - Introduction

Back   Next Slide

Here's my Complete Tutorial on Video.
Play the Video | Download the Video (25 Mb)
  1. What you will learn
    • How to understand a Database Schema.

  2. We will cover these Topics :-
      1. Primary and Foreign Keys.
      2. One-to-Many and Many-to-Many Relationships
      3. Inheritance
      4. "Rabbit's Ears", (Recursive relationships).

  3. The Scope
    • Customers and Orders at Starbucks and at

  4. The Diagrams
    • Diagrams in this Tutorial follow common conventions in Data Modelling.
    • They are produced by a Data Modelling Tool called Dezign.

Click here to begin.

I would be very happy to hear your comments.

© 2007