projects
/
hacks
/
simpleWebSlides.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
6eb80d0
)
fix typo.
author
Kim Nguyễn
<kn@lri.fr>
Mon, 8 Sep 2014 22:13:17 +0000
(
00:13
+0200)
committer
Kim Nguyễn
<kn@lri.fr>
Mon, 8 Sep 2014 22:13:17 +0000
(
00:13
+0200)
bd/bd05.xhtml
patch
|
blob
|
history
diff --git
a/bd/bd05.xhtml
b/bd/bd05.xhtml
index
9d7e4bf
..
7b0692e
100644
(file)
--- a/
bd/bd05.xhtml
+++ b/
bd/bd05.xhtml
@@
-81,7
+81,7
@@
</div>
<div class="sws-slide">
<h1>Exemple pour la suite du cours</h1>
</div>
<div class="sws-slide">
<h1>Exemple pour la suite du cours</h1>
-<code> Sailors(<u>
m
id: integer</u>, sname: string, rating: integer, age: real);
+<code> Sailors(<u>
s
id: integer</u>, sname: string, rating: integer, age: real);
Reserves(<u>sid: integer, bid: integer, day: date</u>, rname: string);
Boats(<u>bid: integer</u>, bname: string, capacity: integer);
</code>
Reserves(<u>sid: integer, bid: integer, day: date</u>, rname: string);
Boats(<u>bid: integer</u>, bname: string, capacity: integer);
</code>
@@
-321,7
+321,7
@@
Une projection commute avec une selection qui utilise uniquement
<div class="sws-slide">
<h1>Exemple de calcul de coût</h1>
<code> SELECT S.sid FROM Sailors S WHERE S.rating = 8; </code>
<div class="sws-slide">
<h1>Exemple de calcul de coût</h1>
<code> SELECT S.sid FROM Sailors S WHERE S.rating = 8; </code>
-<code> π<sub>sid</sub>(σ<sub>rating = 8</sub>(
R
))</code>
+<code> π<sub>sid</sub>(σ<sub>rating = 8</sub>(
S
))</code>
<ul>
<li>Avec un index sur <tt>rating</tt>:
<ul>
<ul>
<li>Avec un index sur <tt>rating</tt>:
<ul>