Category: MySQL
-
ER-Diagram Symbols
Above you see the atomic building blocks of the ER-Diagram: Entity Attribute Relation Carninalities (Crow’s feet notation) one, zero-or-one, zero-or-many, one-or-many,…
-
Adminer – a lightweight alternative to PhpMyAdmin
PhpMyAdmin is powerfull but the GUI is messy. Adminer is a lightweight alternative. You have to download the files and place…
-
SQL count()
This post contiues the SQL tutorial on the Shire Bakery. Here we’ll So how do yo find the most popular cake…
-
SQL: Many-to-Many and One-to-Many
Here’s a short tutorial on how to solve some basic SQL cardinalities. First have a look at the ER-diagram for the…