( ) . ( ). , , , .
: , (, ) ( ).
. , . A_id. : . , , , . , , . .
.
. 6-12. , . : N , C , D ( , , ).
6. (Employees)
| , | |||
| E_ID | N(4) | ||
| , , | E_NAME | C(50) | |
| E_BORN | D | ||
| E_SEX | C(1) | ||
| E_PASSP | C(50) | ||
| E_INN | N(12) | ||
| E_POST | C(30) | ||
| E_SALARY | N(8,2) | ||
| E_ADDR | C(50) | ||
| E_TEL | C(30) |
7. (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) |
8. (Authors)
| , | |||
| A_ID | N(4) | ||
| , , | A_NAME | C(50) | |
| A_PASSP | C(50) | ||
| A_INN | N(12) | ||
| A_ADDR | C(50) | ||
| A_TEL | C(30) |
9. (Orders)
|
|
|
| , | |||
| O_ID | N(6) | ||
| O_COMPANY | (40) | ||
| O_DATE | D | ||
| O_ADDR | C(50) | ||
| O_READY | D |
10. Ȗ (Titles)
| , | |||
| ( ) | B_ID | N(6) | ( Books) |
| A_ID | N(4) | ( Authors) | |
| A_NO | N(1) | ||
| A_FEE | N(3) |
11. Ȗ (Editors)
| , | |||
| ( ) | B_ID | N(6) | ( Books) |
| E_ID | N(4) | ( Employees) |
12. (Items)
| , | |||
| O_ID | N(6) | ( Orders) | |
| ( ) | B_ID | N(6) | ( Books) |
| B_COUNT | N(4) |
