{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1040{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} {\colortbl ;\red118\green118\blue118;\red0\green0\blue0;} {\*\generator Riched20 10.0.22000}\viewkind4\uc1 \pard\f0\fs28\lang16 CREATE TABLE automobile (\par prov char(2),\par numero char (6),\par proprietario char(12),\par Primary key (prov, numero)\par );\par \par CREATE TABLE vigile (\par matricola int primary key,\par nome char(25) not null,\par cognome char(25) not null,\par Unique (nome, cognome)\par );\par \par CREATE TABLE infrazione (\par codice int primary key,\par data date not null,\par vigile int,\par prov char(2),\par numero char (6),\par Foreign key (prov, numero)\par references automobile(prov, numero)\par on delete set null on update cascade, \par foreign key (vigile) references vigile(matricola)\par on delete set null on update cascade\par );\par \par insert into vigile values (343, 'Rossi', 'Luca'), (476, 'Neri', 'Pino'), (548, 'Nicolosia', 'Gino');\par \par insert into automobile values ('MI', '3K9886', 'Nestore'), ('MI', '6D5563', 'Nestore'), ('RM', '7C5567', 'Mancini'), ('RM', '1A6673', 'Mussone'), ('MI', '5E7653', 'Marchi');\par \par insert into infrazione values (65524, '1997-09-03', 343, 'MI', '5E7653'), (87635, '1997-12-04', 476,'MI', '3k9886'), (82236, '1997-12-04', 343, 'RM', '7C5567'), (35632, '1997-12-04', 476, 'RM', '7C5567'), (76543,\par '1998-03-05', 548, 'VE', null);\par \par \cf1\par \cf2 update automobile set prov='TE' where proprietario='Nestore';\par \par select * from automobile;\par select * from infrazione;\par \par update vigile set matricola=549 where matricola=548;\par select * from infrazione;\par \par CREATE TABLE prova (\par codice int primary key,\par codice1 int unique\par \pard\sa200\sl276\slmult1 );\cf0\par }