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)
- What you will learn
- How to understand a Database Schema.
- We will cover these Topics :-
- Primary and Foreign Keys.
- One-to-Many and Many-to-Many Relationships
- Inheritance
- "Rabbit's Ears", (Recursive relationships).
- The Scope
- Customers and Orders at Starbucks and at Amazon.com.
- 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.
© DataBaseAnswers.org 2007