DB-SQL-PHP

Examples of databases design, SQL & PHP code for students 5AIN & 5BIN.

Prerequisites

• HTML, CSS & JavaScript

Useful resources & tools

• DB theory: Database Systems - Concepts, Languages and Architectures (Paolo Atzeni, Stefano Ceri, Stefano Paraboschi and Riccardo Torlone)
• Entity-Relationship modeling tools like:
  • ERDPlus
• SQL language, DBMS documentation & more:
  • MariaDB Server Documentation
  • MySQL Documentation
• PHP development (?!!) environment like:
  • Uniform Server
• Editing tools like Visual studio code and its extensions like:
  • SQLTools
  • SQLTools MySQL/MariaDB
  • PHP Extension Pack
  • Live Share Extension Pack
• DB administration tools like:
  • MySQL Workbench
• Random test data generator like:
  • Mockaroo

List of examples

Here you will find all the examples provided during the course. Feel absolutely free to make them part of your work.

Example	Topic
Select	Istruzione SELECT di base
Joins	Joins
Grouping	Funzioni di aggregazione
Constraints	Vincoli
DB_schema	Esempio script creazione DB
Ristrutturazione	Osservazioni sulla ristrutturazione di schemi E/R
Traduzione	Osservazioni sulla traduzione di schemi E/R (ed esempio)
Views	Views, scopi ed esempi
Subqueries	Subqueries
Triggers	Triggers, scopi ed esempi
PHP
intro	Introduzione

List of exercises

Here you will find some of the exercises assigned during the course and probably their solutions.

Exercise	Solution
27 pag. A76	ERDPlus diagram
28 pag. A76	ERDPlus diagram
2024-10-07	here
30 pag. A77	ERDPlus diagram
Traduzioni	Traduzioni (parziale) yet

List of lab tests

Here you will find some of the lab tests assigned during the course and probably their solutions.

Exercise	Solution
next test	Here