Database ApplicationsTutorial #1
What is a Database?
Examples of DBMS?
Microsoft Access
Trial
Buy
MySQL
MySQL Community Server
MySQL Workbench GUI
Oracle
SQL Server
IBM DB2
Basic Database Elements
Tables
Fields
Datatypes
Relationships
Queries & SQL
Forms
Reports
Sample Application - Northwind
Forms
Queries
Reports
Relationships
One to Many
One to One
Many to Many
What can go wrong?
Data Anomalies
Deletion anomalies
Insertion anomolies
Update anomalies
Design does not meet actual needs
Ensuring Quality Design
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