230103
()
һ MS OFFICE.
: (.. )
() (...)
:(.. )
() (...)
: ()
() (...)
2011 / 2012
.
:
|
|
|
|
|
: |
230103 () һ MS OFFICE.
: (.. ) () (...) :(.. ) () (...) : () () (...)
2011 / 2012
.
|
, , . , , . MS ACCESS. , .
. .
, . .
һ. . .
52 ., 9, 1, 36 5 .
:
, SQL. , SELECT 3 , SELECT, SELECT, SELECT. , SQL, , .
SELECT , . SELECT, " ".
SELECT. . ( , . .), . .
. ORDER BY SELECT , . SQL, , . , , ASC ( Ascending ) ORDER BY. , DESC ( Descending ).
|
|
|
:
( , ) :
, .. .
. , , .
, , . , , .
1. R (2NF) , 1NF R. . ( , )
2. , , 2NF , , .
3. . , .
4. . , . , , .
3:
- R () ;
- R ( ) R. , . , , .
. , . . , , .. [ ] . , .
, , . , , . , , . . . , .
|
|
|
, , , , , , . .
. , , , , , . , , , , .. . . -> -> . : , , . , , . , , , , . . . , .
. . , . . , . . , . . , .
|
|
|
|
|
|
: 2016-12-17; !; : 480 |
:
| 1444 - 