Database ApplicationsTutorial #1

Microsoft Access

Trial

Buy

MySQL

MySQL Community Server

MySQL Workbench GUI

Oracle

SQL Server

IBM DB2

Tables

Fields

Datatypes

Relationships

Queries & SQL

Forms

Reports

Sample Application - Northwind

One to Many

One to One

Many to Many

Data Anomalies

Deletion anomalies

Insertion anomolies

Update anomalies

Design does not meet actual needs

Solution to ensure design meet actual needs: Good Quality Analysis & Design

Use Cases

Introduction to Use Cases

Template

Entity Relationship Diagram

Data Modeling

Solution to Data Anomalies: Normalization

Normalization Example #1 Microsoft

Normalization Example #2 by Couson