Prețuri Autentificați-vă Înregistrați-vă

Categorii: Tot - relationships - design

realizată de Mary Loftus 15 ani în urmă

751

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.

Mai multe ca aceasta

Library Stakeholders Project

după Liz Sikes

The directors of a property company are looking at whether they shouldconstruct a new office building. The economy is doing well, and the amount ofvacant office space is reducing sharply. As part of their decision they decide to use the 6 Thinking Hats te

după Serik Ayazhan

Of Mice and Men

după Charlotte Lacy

They both die at the end (characters)

după Justi Molina Imbaud

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?