Databases

Introduction by example

a fishy database

Introduction by geekgirl

Databases from scratch I: Introduction
Databases from scratch II: Simple Database Design
Databasics III: Data entry design

Introduction of the process

The Entity-Relationship Model
Normalization
SQL
Server-side with PHP
Client-side with Wed SQL or IndexedDB

Database cartoons

SQL injection
Mauve
Build a database
Complex relational model
Dilbert query results

Try it out

One running example of Stanford’s on-line database course is a database to keep up with cliques and crushes of high school students. (I am not making this up.)

In addition to knowing who likes whom, we need to keep up with some personal information about these students. Otherwise, it would just be a table.