1: 1NF
(, , , .(_, , _)).
2: , 2NF
__(_, _, _, _, _)
: _, _
: _ _; _ _; _ _; _, _ _
3: , 3NF
_(_, _, _)
: _
: _ _; _ _; _ _
4: , BCNF
_ (_, _, _, _)
: _, _
: _ _; _ _; _ _; _ _; _, _ _; _, _ _
5: , 4NF
(_, _, _)
: _, _, _
: _ _; _ _
6: , 5NF
__(_, _, _)
: _, _
: *(, , ), ={ _, _},
={ _, _}, ={ _, _}
7: :
SELECT * FROM ;
8: :
SELECT , .*
FROM INNER JOIN
ON ._ = ._;
9: (_, , _, , _, ___, ) :
SELECT TOP 5
FROM
WHERE ___ = 2002
ORDER BY DESC;
10: (_, , _, , _, ___, ) :
SELECT TOP PERCENT 10
FROM
WHERE ___ = 2002
ORDER BY ASC;
11: (_, ) (_, _, )
:
SELECT . _, , _,
FROM ,
WHERE . _ = . _
AND _ = 1;
12: (_, , _, , _, ___, ) :
SELECT ., []*0,5 As
FROM ;
|
|
13: (_, , _, , _, ___, ), _(_, _) (_, _) :
SELECT ., . _
FROM INNER JOIN ( INNER JOIN
_ ON ,_ = _,_)
ON ._ = _. _;
14: (_, , _, , _, ___, ), _(_, _) (_, _) , :
_1:
SELECT _. _, . _
FROM _ INNER JOIN
ON _,_ = ,_;
SELECT ., _1. _
FROM INNER JOIN _1
ON ._ = _1. _;
15: (_, , _, , _, ___, ) :
SELECT ., ._
FROM
WHERE (((._)<#2/23/1956#));
16: (_, , _, , _, ___, , ) :
SELECT ,
FROM
WHERE LIKE **;
17: (_, , _, , _, ___, , ) :
SELECT ,
FROM
WHERE Between 1000 AND 2000;]
18: (_, , _, , _, ___, , ) :
SELECT ,
FROM
WHERE LIKE *?;
19: (, , , ) :
SELECT ., .
FROM
WHERE (((.[])=317 Or (.[])=311));
20: (, _, ), (, _, , , , )
:
SELECT . _, ., .
FROM INNER JOIN ON . _ = ._
WHERE .="";
20: (, _, ), (, , , ) :
SELECT . , . _, ., .
FROM INNER JOIN ON .=.
WHERE .="";
21: (, , , ) :
SELECT ., .
FROM
WHERE (((.)=#4/10/2004#));
|
|
22: (, ) :
SELECT .*
FROM
WHERE (((.)=" "));