1. 1 ( ) , .
. , ) ; ) .
, , , ; (), .
. ( ). ( ) ( ) ( ).
. ( ). , () , . , , . . .
. , ( null), . ( , ). , .
2. , Ȗ Ȗ. .
3. , , . , .. . . , 1:n .
. , : , .
|
|
|
, . , 1:1. , .
. 3, , 4, .. .
. . .
, . : . , . ( ).
: , ? , ( ) . , . .
(. 7):
.7.
. 817.
8. (Posts)
| , | |||
| P_ID | N(3) | ||
| P_POST | C(30) | ||
| P_SAL | N(8,2) |
9. (Rooms)
| , | |||
| R_NO | N(3) | ||
| R_TEL | C(10) |
10. (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) |
11. (Customers)
| , | |||
| C_ID | N(4) | ||
| C_NAME | C(30) | ||
| C_ADDR | C(50) |
|
|
|
12. (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) |
13. (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) |
14. (Orders)
| , | |||
| O_ID | N(6) | ||
| O_COMPANY | N(4) | ( Customers) | |
| O_DATE | D | ||
| O_READY | D |
15. Ȗ (Titles)
| , | |||
| ( ) | B_ID | N(6) | ( Books) |
| A_ID | N(4) | ( Authors) | |
| A_NO | N(1) | ||
| A_FEE | N(3) |
16. (Items)
| , | |||
| O_ID | N(6) | ( Orders) | |
| ( ) | B_ID | N(6) | ( Books) |
| B_COUNT | N(4) |
17. Ȗ (Editors)
| , | |||
| ( ) | B_ID | N(6) | ( Books) |
| E_ID | N(4) | ( Employees) |
