User Tools

Site Tools


appunti5s:mysql01
CREATE DATABASE registroauto;
 
CREATE TABLE registroauto.cittadini (
cf CHAR(16) PRIMARY KEY,
nome VARCHAR(30),
cognome VARCHAR(30)
);
CREATE TABLE registroauto.auto (
targa CHAR(7) PRIMARY KEY,
marca VARCHAR(20),
modello VARCHAR(20)
);
CREATE TABLE registroauto.proprieta (
cf CHAR(16),
targa CHAR(7),
FOREIGN KEY (cf) REFERENCES cittadini(cf),
FOREIGN KEY (targa) REFERENCES auto(targa),
PRIMARY KEY (cf,targa)
);
 
INSERT INTO registroauto.cittadini VALUES
('BNC','Luigi','Bianchi'),
('NPL','Giorgio','Napolitano'),
('PRT','Luigi','Proietti');
 
INSERT INTO registroauto.auto VALUES
('2345678','Fiat','Panda'),
('1234567','Opel','Zip'),
('1999NNN','Ferrari','F10');
 
INSERT INTO registroauto.proprieta VALUES
('BNC','1234567'),
('NPL','1234567'),
('NPL','1999NNN');
appunti5s/mysql01.txt · Last modified: 2020/06/08 22:20 by 127.0.0.1