create table CAGES (
nocage INTEGER PRIMARY KEY, type TEXT);
create table EMPLOYES (
nomemp TEXT PRIMARY KEY, adresse TEXT, poste TEXT, salaire TEXT);
create table ANIMAUX(
    nomanimal TEXT PRIMARY KEY, espece TEXT, sexe TEXT, pays TEXT, nocage INTEGER,
    FOREIGN KEY (nocage) REFERENCES CAGES(nocage));
create table SURVEILLANCES (
nomemp TEXT,nocage INTEGER,
    PRIMARY KEY (nomemp, nocage),
    FOREIGN KEY (nomemp) REFERENCES EMPLOYES (nomemp),
    FOREIGN KEY (nocage) REFERENCES CAGES (nocage));
create table MALADIES (
    mal TEXT PRIMARY KEY);
create table MALADIES_ANIMAUX(
 nomanimal TEXT, mal TEXT,   
    PRIMARY KEY(nomanimal, mal),
    FOREIGN KEY (nomanimal) REFERENCES ANIMAUX(nomanimal),
    FOREIGN KEY (mal) REFERENCES MALADIES(mal));

INSERT INTO cages (nocage,type) VALUES (1,'S');
INSERT INTO cages (nocage,type) VALUES (2,'S');
INSERT INTO cages (nocage,type) VALUES (3,'S');
INSERT INTO cages (nocage,type) VALUES (4,'S');
INSERT INTO cages (nocage,type) VALUES (5,'D');
INSERT INTO cages (nocage,type) VALUES (6,'D');
INSERT INTO animaux (nomanimal,espece,sexe,pays,nocage) values ('Bibou','chat','M','FRANCE',1);
INSERT INTO animaux (nomanimal,espece,sexe,pays,nocage) values ('Micheline','chien','F','ESPAGNE',2);
INSERT INTO animaux (nomanimal,espece,sexe,pays,nocage) values ('Bob','cayman','M','USA',3);
INSERT INTO animaux (nomanimal,espece,sexe,pays,nocage) values ('Mirette','chevre','F','FRANCE',4);
INSERT INTO animaux (nomanimal,espece,sexe,pays,nocage) values ('Franklin Delano','tortue','M','MAROC',5);
INSERT INTO animaux (nomanimal,espece,sexe,pays,nocage) values ('Jimmy','chien','M','FRANCE',6);

INSERT INTO employes (nomemp,adresse,poste,salaire) VALUES ('Maurice','42 rue de la loose 69100 villeurbanne','agent entretien',21000);
INSERT INTO employes (nomemp,adresse,poste,salaire) VALUES ('Roussel','1 rue de la victoire lyon 01','veterinaire en chef',110000);
INSERT INTO employes (nomemp,adresse,poste,salaire) VALUES ('Martin','1450 route de genas 69245 bidonville','assistant ',21000);

INSERT INTO surveillances (nomemp,nocage) VALUES ('Maurice',1);
INSERT INTO surveillances (nomemp,nocage) VALUES ('Martin',2);
INSERT INTO surveillances (nomemp,nocage) VALUES ('Martin',3);
INSERT INTO surveillances (nomemp,nocage) VALUES ('Roussel',4);
INSERT INTO surveillances (nomemp,nocage) VALUES ('Roussel',6);
INSERT INTO surveillances (nomemp,nocage) VALUES ('Martin',6);

INSERT INTO maladies (mal) VALUES ('Blessure');
INSERT INTO maladies (mal) VALUES ('fractures');
INSERT INTO maladies (mal) VALUES ('Maladies grave');
INSERT INTO maladies (mal) VALUES ('Maladies inquietantes');

INSERT INTO maladies_animaux (nomanimal,mal) VALUES ('Mirette','Blessure');
INSERT INTO maladies_animaux (nomanimal,mal) VALUES ('Bibou','fractures');
INSERT INTO maladies_animaux (nomanimal,mal) VALUES ('Micheline','Maladies grave');
INSERT INTO maladies_animaux (nomanimal,mal) VALUES ('Bob','Maladies inquietantes');
INSERT INTO maladies_animaux (nomanimal,mal) VALUES ('Franklin Delano','Maladies inquietantes');
INSERT INTO maladies_animaux (nomanimal,mal) VALUES ('Jimmy','fractures');

select * from cages ;
select * from animaux ;
select * from employes ;
select * from surveillances;
select *from maladies ;
select * from maladies_animaux;