Introduction

Data Modeling

  Overview

  E-R Model

  Database Design

  Data Objects

  Basic Schema

  Refining the E-R

  Primary Keys

  Attributes

  Hierarchies

  Integrity Rules

  Bibliography

Relational Model

  Overview

  Data Structure

  Notation

  Relational Table

  Relationships

  Data Integrity

  Relational Data

  Normalization

  Advanced

Introduction

This document is an informal introduction to data modeling using the Entity-Relationship (ER) approach. It is intended for someone who is familiar with relational databases but who has no experience in data modeling. The basic techniques described are applicable to the development of microcomputer based relational database applications as well as those who use relational database servers such as MS SQL Server or Oracle.

The document is a practical guide, not an academic paper on either relational database design or data modeling. Readers interested in a rigorous treatment of these topics should consult the bibliography .