Kategorier: Alla - relationships - design

av Mary Loftus för 14 årar sedan

639

Database Applications - Tutorial #1

Effective database design is crucial for meeting actual user needs and avoiding common issues like data anomalies. These anomalies, including update, deletion, and insertion anomalies, can disrupt data integrity and reliability.

Database Applications - Tutorial #1

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?