Database ApplicationsTutorial #1
Ensuring Quality Design
Solution to Data Anomalies: Normalization
Normalization Example #2 by Couson
Normalization Example #1 Microsoft
Solution to ensure design meet actual needs: Good Quality Analysis & Design
Data Modeling
Entity Relationship Diagram
Use Cases
Template
Introduction to Use Cases
What can go wrong?
Design does not meet actual needs
Data Anomalies
Update anomalies
Insertion anomolies
Deletion anomalies
Many to Many
One to One
One to Many
Queries
Basic Database Elements
Sample Application - Northwind
Reports
Forms
Queries & SQL
Tables
Relationships
Datatypes
Fields
Examples of DBMS?
IBM DB2
SQL Server
Oracle
MySQL
MySQL Workbench GUI
MySQL Community Server
Microsoft Access
Buy
Trial
What is a Database?
