, . 1423.
:
1) 0 ( null, ).
2) Sex EMPLOYEES '' ''.
3) ROOMS , (R_no, Tel) .
4) TITLES , 1.
5) TITLES 100.
(4,5) . ( ).
():
1) : ( ), . .
2) : POSTS, ROOMS EMPLOYEES.
3) : , POSTS. AUTHORS, CUSTOMERS, BOOKS, EDITORS, TITLES, ORDERS, ITEMS.
4) : :
AUTHORS, A_passp, A_org, A_pdate, A_INN ( ).
BOOKS, B_advance, B_fee ( ).
EDITORS.
TITLES.
5) , : CUSTOMERS, ORDERS, ITEMS B_title, B_circul, B_price B_rest BOOKS (, , , ).
Transact-SQL.
.
, , , .
SQL , , , , , , , .
SELECT . :
SELECT < 1>, < 2>,...
FROM < >
[WHERE <>]
SELECT - , , . , .
< 1>,... - , . , , . , , , - .
|
|
FROM - , . , - , .
WHERE - , , .
, , ( ). . , . SQL-, . .
SELECT (*) , , :
SELECT * FROM < >
, , , , , .
, .
: , :
SELECT E_ID,E_NAME, E_BORN FROM Employees