1. 1 ( ) , .
. , :
1) ;
2) .
, , , (), .
. ( ). () ( ) ( ).
. ( ). , () , . ,
, . . .
. , ( null), . ( , ). , .
2. , Ȗ Ȗ. .
3. , , . , .. . . , 1:n .
. , : , .
|
|
|
, . , 1:1. , . .
, . : . , . ( ).
: , ? , ( ) . , . .
( 13):
13
. 1423.
14. (Posts)
| , | |||
| P_ID | N(3) | ||
| P_POST | C(30) | ||
| P_SAL | N(8,2) |
15. (Rooms)
| , | |||
| R_NO | N(3) | ||
| R_TEL | C(10) |
16. (Employees)
| , | |||
| E_ID | N(4) | ||
| E_FNAME | C(20) | ||
| , | E_LNAME | (30) | |
| E_BORN | D | ||
| E_SEX | C(1) | ||
| E_POST | N(3) | ( Posts) | |
| E_ROOM | N(3) | ( Rooms) | |
| E_TEL | C(10) | ||
| E_INN | (12) | ||
| E_PASSP | C(12) | ||
| E_ORG | (30) | ||
| E_PDATE | D | ||
| E_ADDR | C(50) |
17 (Customers)
| , | |||
| C_ID | N(4) | ||
| C_NAME | C(30) | ||
| C_ADDR | C(50) |
18. (Authors)
| , | |||
| A_ID | N(4) | ||
| A_FNAME | C(20) | ||
| , | A_LNAME | (30) | |
| A_INN | (12) | ||
| A_PASSP | C(12) | ||
| A_ORG | (30) | ||
| A_PDATE | D | ||
| A_ADDR | C(50) | ||
| A_TEL | C(30) |
|
|
|
19. (Books)
| , | |||
| B_CONTRACT | N(6) | ||
| B_DATE | D | ||
| B_MAN | N(4) | ( Employees) | |
| B_TITLE | N(40) | ||
| B_PRICE | N(6,2) | ||
| B_ADVANCE | N(10,2) | ||
| B_FEE | N(8,2) | ||
| B_PUBL | D | ||
| B_CIRCUL | N(5) | ||
| B_EDIT | N(4) | ( Employees) | |
| B_REST | N(5) |
20. (Orders)
| , | |||
| O_ID | N(6) | ||
| O_COMPANY | N(4) | ( Customers) | |
| O_DATE | D | ||
| O_READY | D |
21. Ȗ (Titles)
| , | |||
| ( ) | B_ID | N(6) | ( Books) |
| A_ID | N(4) | ( Authors) | |
| A_NO | N(1) | ||
| A_FEE | N(3) |
22. (Items)
| , | |||
| O_ID | N(6) | ( Orders) | |
| ( ) | B_ID | N(6) | ( Books) |
| B_COUNT | N(4) |
23. Ȗ (Editors)
| , | |||
| ( ) | B_ID | N(6) | ( Books) |
| E_ID | N(4) | ( Employees) |
