Fichier de rejeu Close

Indication Close

A propos de... Close

Commentaire Close

Systèmes d'Information

Présentation

Films

Repas

Repas

Index

Téléchargements

Crédits

Aide

Menu	Contenu
	Sommaire, Téléchargements
	Aide sur les outils

Chevron	Action
	Aller en haut de la page courante
	Aller en bas de la page courante
	Passer à la page précédente
	Passer à la page suivante

Recherches sur plusieurs tables

L’objectif de ces exercices est de savoir représenter sous forme d’arbre de requêtes une requête sur une plusieurs tables de la base de données « Aux pays des bières ».

2/2 Aux pays des bières : INNER, NATURAL, OUTER

Produit cartésien et restriction

Construire un arbre de requêtes répondant à la question :

\(Q_1\) : « récupérer les bars qui servent de la bière ».

Votre réponse :

Arbre de requêtes : graph72.json


Tables Opérateurs unaires Opérateurs binaires

Vue d'ensemble
	CREATE TABLE bars ( id_bar INTEGER NOT NULL PRIMARY KEY, bar VARCHAR(20), pays VARCHAR(20) ); CREATE TABLE bieres ( id_biere INTEGER NOT NULL PRIMARY KEY, biere VARCHAR(20), couleur VARCHAR(10), origine VARCHAR(20) ); CREATE TABLE services ( id_bar INTEGER NOT NULL, id_biere INTEGER NOT NULL, stock SMALLINT, PRIMARY KEY (id_bar, id_biere), FOREIGN KEY (id_bar) REFERENCES bars, FOREIGN KEY (id_biere) REFERENCES bieres); INSERT INTO bars VALUES (1, 'Bar du Coin', 'France'); INSERT INTO bars VALUES (2, 'Corners Pub', 'USA'); INSERT INTO bars VALUES (3, 'Cafe der Ecke','Allemagne'); INSERT INTO bars VALUES (4, 'Cafe des Amis', 'France'); INSERT INTO bieres VALUES (1, 'Kronenbourg', 'Blonde', 'France'); INSERT INTO bieres VALUES (2, 'Guinness', 'Brune', 'Irlande'); INSERT INTO bieres VALUES (3, 'Heineken', 'Blonde', 'Hollande'); INSERT INTO bieres VALUES (4, 'Newcastle', 'Rousse', 'UK'); INSERT INTO bieres VALUES (5, 'Spaten', 'Blonde', 'Allemagne'); INSERT INTO bieres VALUES (6, 'Bush', 'Blonde', 'USA'); INSERT INTO bieres VALUES (7, 'Kanterbrau', 'Blonde', 'France'); INSERT INTO bieres VALUES (8, 'Kronenbourg', 'Brune', 'France'); INSERT INTO services VALUES (1,1,1000); INSERT INTO services VALUES (1,2, 250); INSERT INTO services VALUES (1,3, 50); INSERT INTO services VALUES (1,4, 10); INSERT INTO services VALUES (1,5, 10); INSERT INTO services VALUES (1,6, 10); INSERT INTO services VALUES (1,7, 20); INSERT INTO services VALUES (1,8, 20); INSERT INTO services VALUES (2,1, 100); INSERT INTO services VALUES (2,6, 1500); INSERT INTO services VALUES (3,5, 5000);

Vue d'ensemble

CREATE TABLE bars ( id_bar INTEGER NOT NULL PRIMARY KEY,
                    bar    VARCHAR(20),
                    pays   VARCHAR(20) );

CREATE TABLE bieres ( id_biere  INTEGER NOT NULL PRIMARY KEY,
                      biere     VARCHAR(20),
                      couleur   VARCHAR(10),
                      origine   VARCHAR(20) );

CREATE TABLE services  ( id_bar   INTEGER NOT NULL,
                         id_biere INTEGER NOT NULL,
                         stock    SMALLINT,
                         PRIMARY KEY (id_bar, id_biere),
                         FOREIGN KEY (id_bar)   REFERENCES bars,
                         FOREIGN KEY (id_biere) REFERENCES bieres);

INSERT INTO bars VALUES (1, 'Bar du Coin', 'France');
INSERT INTO bars VALUES (2, 'Corners Pub',  'USA');
INSERT INTO bars VALUES (3, 'Cafe der Ecke','Allemagne');  
INSERT INTO bars VALUES (4, 'Cafe des Amis', 'France');

INSERT INTO bieres  VALUES (1, 'Kronenbourg', 'Blonde', 'France');  
INSERT INTO bieres  VALUES (2, 'Guinness', 'Brune', 'Irlande');  
INSERT INTO bieres  VALUES (3, 'Heineken', 'Blonde', 'Hollande');  
INSERT INTO bieres  VALUES (4, 'Newcastle', 'Rousse', 'UK');  
INSERT INTO bieres  VALUES (5, 'Spaten', 'Blonde', 'Allemagne');  
INSERT INTO bieres  VALUES (6, 'Bush', 'Blonde', 'USA');  
INSERT INTO bieres  VALUES (7, 'Kanterbrau', 'Blonde', 'France');  
INSERT INTO bieres  VALUES (8, 'Kronenbourg', 'Brune', 'France');

INSERT INTO services VALUES (1,1,1000);
INSERT INTO services VALUES (1,2, 250);
INSERT INTO services VALUES (1,3, 50);
INSERT INTO services VALUES (1,4, 10);
INSERT INTO services VALUES (1,5, 10);
INSERT INTO services VALUES (1,6, 10);
INSERT INTO services VALUES (1,7, 20);
INSERT INTO services VALUES (1,8, 20);
INSERT INTO services VALUES (2,1, 100);
INSERT INTO services VALUES (2,6, 1500);
INSERT INTO services VALUES (3,5, 5000);

id_biere	biere	couleur	origine	id_bar	bar	pays	stock
1	Kronenbourg	Blonde	France	1	Bar du Coin	France	1000
2	Guinness	Brune	Irlande	1	Bar du Coin	France	250
3	Heineken	Blonde	Hollande	1	Bar du Coin	France	50
4	Newcastle	Rousse	UK	1	Bar du Coin	France	10
5	Spaten	Blonde	Allemagne	1	Bar du Coin	France	10
6	Bush	Blonde	USA	1	Bar du Coin	France	10
7	Kanterbrau	Blonde	France	1	Bar du Coin	France	20
8	Kronenbourg	Brune	France	1	Bar du Coin	France	20
1	Kronenbourg	Blonde	France	2	Corners Pub	USA	100
6	Bush	Blonde	USA	2	Corners Pub	USA	1500
5	Spaten	Blonde	Allemagne	3	Cafe der Ecke	Allemagne	5000

Une solution possible :

On utilise ici l’opération de jointure naturelle \(\Join_{[]}\) entre deux tables (\(S,T\)) :

\(\Join_{[]}(S,T)\).

On réalise une première jointure naturelle (\(NJ_1\)) entre les tables bars,services :

\(NJ_1=\Join_{[]}(bars,services)\)

suivi d’une deuxième jointure (\(NJ_2\)) entre le résultat précédent et la table des bieres :

\(NJ_2=\Join_{[]}(NJ_1,bieres)\)

Ecriture en algèbre relationnelle :

\(Q_1 = \Join_{[]}(\Join_{[]}(bars,services),bieres)\)

Qu’obtient-on avec les arbres de requêtes suivants :

\(Q_2 = \Join_{[]}(\Join_{[]}(bieres,services),bars)\)

\(Q_3 = \Join_{[]}(\Join_{[]}(bars,bieres),services)\)

Arbre de requêtes : bars-6.json


Tables Opérateurs unaires Opérateurs binaires

Vue d'ensemble
	{ "class": "go.GraphLinksModel", "copiesArrays": true, "copiesArrayObjects": true, "linkFromPortIdProperty": "fromPort", "linkToPortIdProperty": "toPort", "nodeDataArray": [ {"category":"table", "name":"bars", "info":"TABLE", "key":-1, "loc":"125 400"}, {"category":"table", "name":"services", "info":"TABLE", "key":-2, "loc":"325 400"}, {"category":"table", "name":"bieres", "info":"TABLE", "key":-3, "loc":"550 400"}, {"category":"innerjoin", "name":"NJ_2", "info":"INNER JOIN", "key":-5, "loc":"425 150", "condition":"[]"}, {"category":"innerjoin", "name":"NJ_1", "info":"INNER JOIN", "key":-6, "loc":"250 275", "condition":"[]"}, {"category":"query", "name":"Q_1", "info":"QUERY", "key":-7, "loc":"400 25"} ], "linkDataArray": [ {"from":-3, "to":-5, "fromPort":"", "toPort":"R", "points":[550,383.65,550,383.65,550,372,428.19,372,428.19,169.65,428.19,154.65]}, {"from":-1, "to":-6, "fromPort":"", "toPort":"L", "points":[125,383.65,125,383.65,125,339.15,202.81,339.15,202.81,294.65,202.81,279.65]}, {"from":-2, "to":-6, "fromPort":"", "toPort":"R", "points":[325,383.65,325,383.65,325,339.15,253.19,339.15,253.19,294.65,253.19,279.65]}, {"from":-6, "to":-5, "fromPort":"T", "toPort":"L", "points":[228,254.099,228,254.099,228,211.8745,377.81,211.8745,377.81,169.65,377.81,154.65]}, {"from":-5, "to":-7, "fromPort":"T", "toPort":"R", "points":[403,129.099,403,129.099,403,92.7245,400,92.7245,400,56.35000000000001,400,41.35000000000001]} ]} CREATE TABLE bars ( id_bar INTEGER NOT NULL PRIMARY KEY, bar VARCHAR(20), pays VARCHAR(20) ); CREATE TABLE bieres ( id_biere INTEGER NOT NULL PRIMARY KEY, biere VARCHAR(20), couleur VARCHAR(10), origine VARCHAR(20) ); CREATE TABLE services ( id_bar INTEGER NOT NULL, id_biere INTEGER NOT NULL, stock SMALLINT, PRIMARY KEY (id_bar, id_biere), FOREIGN KEY (id_bar) REFERENCES bars, FOREIGN KEY (id_biere) REFERENCES bieres); INSERT INTO bars VALUES (1, 'Bar du Coin', 'France'); INSERT INTO bars VALUES (2, 'Corners Pub', 'USA'); INSERT INTO bars VALUES (3, 'Cafe der Ecke','Allemagne'); INSERT INTO bars VALUES (4, 'Cafe des Amis', 'France'); INSERT INTO bieres VALUES (1, 'Kronenbourg', 'Blonde', 'France'); INSERT INTO bieres VALUES (2, 'Guinness', 'Brune', 'Irlande'); INSERT INTO bieres VALUES (3, 'Heineken', 'Blonde', 'Hollande'); INSERT INTO bieres VALUES (4, 'Newcastle', 'Rousse', 'UK'); INSERT INTO bieres VALUES (5, 'Spaten', 'Blonde', 'Allemagne'); INSERT INTO bieres VALUES (6, 'Bush', 'Blonde', 'USA'); INSERT INTO bieres VALUES (7, 'Kanterbrau', 'Blonde', 'France'); INSERT INTO bieres VALUES (8, 'Kronenbourg', 'Brune', 'France'); INSERT INTO services VALUES (1,1,1000); INSERT INTO services VALUES (1,2, 250); INSERT INTO services VALUES (1,3, 50); INSERT INTO services VALUES (1,4, 10); INSERT INTO services VALUES (1,5, 10); INSERT INTO services VALUES (1,6, 10); INSERT INTO services VALUES (1,7, 20); INSERT INTO services VALUES (1,8, 20); INSERT INTO services VALUES (2,1, 100); INSERT INTO services VALUES (2,6, 1500); INSERT INTO services VALUES (3,5, 5000);

Vue d'ensemble

{ "class": "go.GraphLinksModel",
  "copiesArrays": true,
  "copiesArrayObjects": true,
  "linkFromPortIdProperty": "fromPort",
  "linkToPortIdProperty": "toPort",
  "nodeDataArray": [ 
{"category":"table", "name":"bars", "info":"TABLE", "key":-1, "loc":"125 400"},
{"category":"table", "name":"services", "info":"TABLE", "key":-2, "loc":"325 400"},
{"category":"table", "name":"bieres", "info":"TABLE", "key":-3, "loc":"550 400"},
{"category":"innerjoin", "name":"NJ_2", "info":"INNER JOIN", "key":-5, "loc":"425 150", "condition":"[]"},
{"category":"innerjoin", "name":"NJ_1", "info":"INNER JOIN", "key":-6, "loc":"250 275", "condition":"[]"},
{"category":"query", "name":"Q_1", "info":"QUERY", "key":-7, "loc":"400 25"}
 ],
  "linkDataArray": [ 
{"from":-3, "to":-5, "fromPort":"", "toPort":"R", "points":[550,383.65,550,383.65,550,372,428.19,372,428.19,169.65,428.19,154.65]},
{"from":-1, "to":-6, "fromPort":"", "toPort":"L", "points":[125,383.65,125,383.65,125,339.15,202.81,339.15,202.81,294.65,202.81,279.65]},
{"from":-2, "to":-6, "fromPort":"", "toPort":"R", "points":[325,383.65,325,383.65,325,339.15,253.19,339.15,253.19,294.65,253.19,279.65]},
{"from":-6, "to":-5, "fromPort":"T", "toPort":"L", "points":[228,254.099,228,254.099,228,211.8745,377.81,211.8745,377.81,169.65,377.81,154.65]},
{"from":-5, "to":-7, "fromPort":"T", "toPort":"R", "points":[403,129.099,403,129.099,403,92.7245,400,92.7245,400,56.35000000000001,400,41.35000000000001]}
 ]}

CREATE TABLE bars ( id_bar INTEGER NOT NULL PRIMARY KEY,
                    bar    VARCHAR(20),
                    pays   VARCHAR(20) );

CREATE TABLE bieres ( id_biere  INTEGER NOT NULL PRIMARY KEY,
                      biere     VARCHAR(20),
                      couleur   VARCHAR(10),
                      origine   VARCHAR(20) );

id_biere	biere	couleur	origine	id_bar	bar	pays	stock
1	Kronenbourg	Blonde	France	1	Bar du Coin	France	1000
2	Guinness	Brune	Irlande	1	Bar du Coin	France	250
3	Heineken	Blonde	Hollande	1	Bar du Coin	France	50
4	Newcastle	Rousse	UK	1	Bar du Coin	France	10
5	Spaten	Blonde	Allemagne	1	Bar du Coin	France	10
6	Bush	Blonde	USA	1	Bar du Coin	France	10
7	Kanterbrau	Blonde	France	1	Bar du Coin	France	20
8	Kronenbourg	Brune	France	1	Bar du Coin	France	20
1	Kronenbourg	Blonde	France	2	Corners Pub	USA	100
6	Bush	Blonde	USA	2	Corners Pub	USA	1500
5	Spaten	Blonde	Allemagne	3	Cafe der Ecke	Allemagne	5000

Création de vue

Construire un arbre de requêtes pour créer une vue (\(barsdumonde\)) sur les informations “métier” (sans les clés id_bar et id_biere) répondant à la question :

« récupérer les bars qui servent de la bière ».

Votre réponse :

Arbre de requêtes : graph79.json


Tables Opérateurs unaires Opérateurs binaires

Vue d'ensemble
	CREATE TABLE bars ( id_bar INTEGER NOT NULL PRIMARY KEY, bar VARCHAR(20), pays VARCHAR(20) ); CREATE TABLE bieres ( id_biere INTEGER NOT NULL PRIMARY KEY, biere VARCHAR(20), couleur VARCHAR(10), origine VARCHAR(20) ); CREATE TABLE services ( id_bar INTEGER NOT NULL, id_biere INTEGER NOT NULL, stock SMALLINT, PRIMARY KEY (id_bar, id_biere), FOREIGN KEY (id_bar) REFERENCES bars, FOREIGN KEY (id_biere) REFERENCES bieres); INSERT INTO bars VALUES (1, 'Bar du Coin', 'France'); INSERT INTO bars VALUES (2, 'Corners Pub', 'USA'); INSERT INTO bars VALUES (3, 'Cafe der Ecke','Allemagne'); INSERT INTO bars VALUES (4, 'Cafe des Amis', 'France'); INSERT INTO bieres VALUES (1, 'Kronenbourg', 'Blonde', 'France'); INSERT INTO bieres VALUES (2, 'Guinness', 'Brune', 'Irlande'); INSERT INTO bieres VALUES (3, 'Heineken', 'Blonde', 'Hollande'); INSERT INTO bieres VALUES (4, 'Newcastle', 'Rousse', 'UK'); INSERT INTO bieres VALUES (5, 'Spaten', 'Blonde', 'Allemagne'); INSERT INTO bieres VALUES (6, 'Bush', 'Blonde', 'USA'); INSERT INTO bieres VALUES (7, 'Kanterbrau', 'Blonde', 'France'); INSERT INTO bieres VALUES (8, 'Kronenbourg', 'Brune', 'France'); INSERT INTO services VALUES (1,1,1000); INSERT INTO services VALUES (1,2, 250); INSERT INTO services VALUES (1,3, 50); INSERT INTO services VALUES (1,4, 10); INSERT INTO services VALUES (1,5, 10); INSERT INTO services VALUES (1,6, 10); INSERT INTO services VALUES (1,7, 20); INSERT INTO services VALUES (1,8, 20); INSERT INTO services VALUES (2,1, 100); INSERT INTO services VALUES (2,6, 1500); INSERT INTO services VALUES (3,5, 5000);

Vue d'ensemble

CREATE TABLE bars ( id_bar INTEGER NOT NULL PRIMARY KEY,
                    bar    VARCHAR(20),
                    pays   VARCHAR(20) );

CREATE TABLE bieres ( id_biere  INTEGER NOT NULL PRIMARY KEY,
                      biere     VARCHAR(20),
                      couleur   VARCHAR(10),
                      origine   VARCHAR(20) );

bar	pays	stock	biere	couleur	origine
Bar du Coin	France	1000	Kronenbourg	Blonde	France
Bar du Coin	France	250	Guinness	Brune	Irlande
Bar du Coin	France	50	Heineken	Blonde	Hollande
Bar du Coin	France	10	Newcastle	Rousse	UK
Bar du Coin	France	10	Spaten	Blonde	Allemagne
Bar du Coin	France	10	Bush	Blonde	USA
Bar du Coin	France	20	Kanterbrau	Blonde	France
Bar du Coin	France	20	Kronenbourg	Brune	France
Corners Pub	USA	100	Kronenbourg	Blonde	France
Corners Pub	USA	1500	Bush	Blonde	USA
Cafe der Ecke	Allemagne	5000	Spaten	Blonde	Allemagne

Une solution possible :

On utilise ici l’opération de jointure naturelle \(\Join_{[]}\) entre deux tables (\(S,T\)) :

\(\Join_{[]}(S,T)\).

On réalise une première jointure naturelle (\(NJ_1\)) entre les tables bars,services :

\(NJ_1=\Join_{[]}(bars,services)\)

suivi d’une deuxième jointure (\(NJ_2\)) entre le résultat précédent et la table des bieres :

\(NJ_2=\Join_{[]}(NJ_1,bieres)\)

Le résultat final (\(barsdumonde\)) s’exprimera en appliquant une projection sur les informations “métier” issues de la jointure précédente :

\(barsdumonde=\Pi_{(bar,pays,stock,biere,couleur,origine)}(NJ_2)\)

Ecriture en algèbre relationnelle :

\(Q_1=barsdumonde=\Pi_{(bar,pays,stock,biere,couleur,origine)}(\Join_{[]}(\Join_{[]}(bars,services),bieres))\)

Arbre de requêtes : bars-7.json


Tables Opérateurs unaires Opérateurs binaires

Vue d'ensemble
	{ "class": "go.GraphLinksModel", "copiesArrays": true, "copiesArrayObjects": true, "linkFromPortIdProperty": "fromPort", "linkToPortIdProperty": "toPort", "nodeDataArray": [ {"category":"table", "name":"bars", "info":"TABLE", "key":-1, "loc":"125 400"}, {"category":"table", "name":"services", "info":"TABLE", "key":-2, "loc":"325 400"}, {"category":"table", "name":"bieres", "info":"TABLE", "key":-3, "loc":"550 400"}, {"category":"innerjoin", "name":"NJ_2", "info":"INNER JOIN", "key":-5, "loc":"425 225", "condition":"[]"}, {"category":"innerjoin", "name":"NJ_1", "info":"INNER JOIN", "key":-6, "loc":"250 275", "condition":"[]"}, {"category":"project", "name":"barsdumonde", "info":"PROJECTION", "key":-8, "loc":"400 75", "attributes":"(bar, pays, stock, biere, couleur, origine)"}, {"category":"table", "name":"barsdumonde", "info":"TABLE", "key":-7, "loc":"725 400"}, {"category":"query", "name":"Q_1", "info":"QUERY", "key":-9, "loc":"725 175"} ], "linkDataArray": [ {"from":-3, "to":-5, "fromPort":"", "toPort":"R", "points":[550,383.65,550,383.65,550,314.15,428.19000000000005,314.15,428.19000000000005,244.65,428.19000000000005,229.65]}, {"from":-1, "to":-6, "fromPort":"", "toPort":"L", "points":[125,383.65,125,383.65,125,339.15,202.81,339.15,202.81,294.65,202.81,279.65]}, {"from":-2, "to":-6, "fromPort":"", "toPort":"R", "points":[325,383.65,325,383.65,325,339.15,253.19,339.15,253.19,294.65,253.19,279.65]}, {"from":-6, "to":-5, "fromPort":"T", "toPort":"L", "points":[228,254.099,228,254.099,228,252,228,252,228,220,308,220,308,284,377.81000000000006,284,377.81000000000006,244.65,377.81000000000006,229.65]}, {"from":-5, "to":-8, "fromPort":"T", "toPort":"B", "points":[403,204.099,403,204.099,400,204.099,400,204.099,400,136.35,400,121.35]}, {"from":-7, "to":-9, "fromPort":"", "toPort":"R", "points":[725,383.65,725,383.65,725,383.65,725,383.65,725,206.35000000000002,725,191.35000000000002]} ]} CREATE TABLE bars ( id_bar INTEGER NOT NULL PRIMARY KEY, bar VARCHAR(20), pays VARCHAR(20) ); CREATE TABLE bieres ( id_biere INTEGER NOT NULL PRIMARY KEY, biere VARCHAR(20), couleur VARCHAR(10), origine VARCHAR(20) ); CREATE TABLE services ( id_bar INTEGER NOT NULL, id_biere INTEGER NOT NULL, stock SMALLINT, PRIMARY KEY (id_bar, id_biere), FOREIGN KEY (id_bar) REFERENCES bars, FOREIGN KEY (id_biere) REFERENCES bieres); INSERT INTO bars VALUES (1, 'Bar du Coin', 'France'); INSERT INTO bars VALUES (2, 'Corners Pub', 'USA'); INSERT INTO bars VALUES (3, 'Cafe der Ecke','Allemagne'); INSERT INTO bars VALUES (4, 'Cafe des Amis', 'France'); INSERT INTO bieres VALUES (1, 'Kronenbourg', 'Blonde', 'France'); INSERT INTO bieres VALUES (2, 'Guinness', 'Brune', 'Irlande'); INSERT INTO bieres VALUES (3, 'Heineken', 'Blonde', 'Hollande'); INSERT INTO bieres VALUES (4, 'Newcastle', 'Rousse', 'UK'); INSERT INTO bieres VALUES (5, 'Spaten', 'Blonde', 'Allemagne'); INSERT INTO bieres VALUES (6, 'Bush', 'Blonde', 'USA'); INSERT INTO bieres VALUES (7, 'Kanterbrau', 'Blonde', 'France'); INSERT INTO bieres VALUES (8, 'Kronenbourg', 'Brune', 'France'); INSERT INTO services VALUES (1,1,1000); INSERT INTO services VALUES (1,2, 250); INSERT INTO services VALUES (1,3, 50); INSERT INTO services VALUES (1,4, 10); INSERT INTO services VALUES (1,5, 10); INSERT INTO services VALUES (1,6, 10); INSERT INTO services VALUES (1,7, 20); INSERT INTO services VALUES (1,8, 20); INSERT INTO services VALUES (2,1, 100); INSERT INTO services VALUES (2,6, 1500); INSERT INTO services VALUES (3,5, 5000);

Vue d'ensemble

{ "class": "go.GraphLinksModel",
  "copiesArrays": true,
  "copiesArrayObjects": true,
  "linkFromPortIdProperty": "fromPort",
  "linkToPortIdProperty": "toPort",
  "nodeDataArray": [ 
{"category":"table", "name":"bars", "info":"TABLE", "key":-1, "loc":"125 400"},
{"category":"table", "name":"services", "info":"TABLE", "key":-2, "loc":"325 400"},
{"category":"table", "name":"bieres", "info":"TABLE", "key":-3, "loc":"550 400"},
{"category":"innerjoin", "name":"NJ_2", "info":"INNER JOIN", "key":-5, "loc":"425 225", "condition":"[]"},
{"category":"innerjoin", "name":"NJ_1", "info":"INNER JOIN", "key":-6, "loc":"250 275", "condition":"[]"},
{"category":"project", "name":"barsdumonde", "info":"PROJECTION", "key":-8, "loc":"400 75", "attributes":"(bar, pays, stock, biere, couleur, origine)"},
{"category":"table", "name":"barsdumonde", "info":"TABLE", "key":-7, "loc":"725 400"},
{"category":"query", "name":"Q_1", "info":"QUERY", "key":-9, "loc":"725 175"}
 ],
  "linkDataArray": [ 
{"from":-3, "to":-5, "fromPort":"", "toPort":"R", "points":[550,383.65,550,383.65,550,314.15,428.19000000000005,314.15,428.19000000000005,244.65,428.19000000000005,229.65]},
{"from":-1, "to":-6, "fromPort":"", "toPort":"L", "points":[125,383.65,125,383.65,125,339.15,202.81,339.15,202.81,294.65,202.81,279.65]},
{"from":-2, "to":-6, "fromPort":"", "toPort":"R", "points":[325,383.65,325,383.65,325,339.15,253.19,339.15,253.19,294.65,253.19,279.65]},
{"from":-6, "to":-5, "fromPort":"T", "toPort":"L", "points":[228,254.099,228,254.099,228,252,228,252,228,220,308,220,308,284,377.81000000000006,284,377.81000000000006,244.65,377.81000000000006,229.65]},
{"from":-5, "to":-8, "fromPort":"T", "toPort":"B", "points":[403,204.099,403,204.099,400,204.099,400,204.099,400,136.35,400,121.35]},
{"from":-7, "to":-9, "fromPort":"", "toPort":"R", "points":[725,383.65,725,383.65,725,383.65,725,383.65,725,206.35000000000002,725,191.35000000000002]}
 ]}

CREATE TABLE bars ( id_bar INTEGER NOT NULL PRIMARY KEY,
                    bar    VARCHAR(20),
                    pays   VARCHAR(20) );

CREATE TABLE bieres ( id_biere  INTEGER NOT NULL PRIMARY KEY,
                      biere     VARCHAR(20),
                      couleur   VARCHAR(10),
                      origine   VARCHAR(20) );

bar	pays	stock	biere	couleur	origine
Bar du Coin	France	1000	Kronenbourg	Blonde	France
Bar du Coin	France	250	Guinness	Brune	Irlande
Bar du Coin	France	50	Heineken	Blonde	Hollande
Bar du Coin	France	10	Newcastle	Rousse	UK
Bar du Coin	France	10	Spaten	Blonde	Allemagne
Bar du Coin	France	10	Bush	Blonde	USA
Bar du Coin	France	20	Kanterbrau	Blonde	France
Bar du Coin	France	20	Kronenbourg	Brune	France
Corners Pub	USA	100	Kronenbourg	Blonde	France
Corners Pub	USA	1500	Bush	Blonde	USA
Cafe der Ecke	Allemagne	5000	Spaten	Blonde	Allemagne

Fichier de rejeu Close

Indication Close

A propos de... Close

Commentaire Close

Systèmes d'Information

Téléchargements

Aide

En-tête

Pied de page

Recherches sur plusieurs tables

Votre réponse :

Tables

Opérateurs unaires

Opérateurs binaires

Une solution possible :

Tables

Opérateurs unaires

Opérateurs binaires

Votre réponse :

Tables

Opérateurs unaires

Opérateurs binaires

Une solution possible :

Tables

Opérateurs unaires

Opérateurs binaires