3,4
().
: () , . , , .
I. ( ).
II. , . .
III. ER .
IV. . :
1. .
2. .
3. .
4. ER .
5. .
I. .
:
, . :
1. : ; ; ; , ( ).
:
× , .
× ;
× ;
2. : ; ; .
3. : , , , ; ; ; ; , .
:
, ;
.
:
:
| _ |
| _ |
:
|
|
|
1. , , _, _, _ .
2. -- . _ _, _ _.
:
| _ |
| _ |
| _ |
| _ |
| _ |
| _ |
| _ |
| _ |
| _ |
II. .
(3).
1. Empl (), :
Empl:
| e_id | e_name | job | skill | department | |
| d_id | d_name | ||||
| Drovko | Administrator DB | MySQL, Linux, Java, UML | Projecting department | ||
| Ivanov | System admin | Windows, Linux, Java, NT | Administrative department | ||
| Konov | Programs | Linux, Java, NT, C++, Peri | Testing department | ||
| Kornienko | Programs | NT, C++, Peri | Testing department | ||
| Koval | Programs | Java, NT, C++, Peri | Realization department | ||
| Palkin | Programs | C++, MySQL, UML | Testing department | ||
| Petrov | Programs | Linux, Java, NT, C++, Peri | Realization department | ||
| Sidorov | Administrator DB | MySQL, Linux, Java, NT | Projecting department | ||
| Turov | System admin | Linux, Java, NT, UML | Administrative department | ||
| Vertko | Programs | Java, C++, Peri, UML | Realization department |
:
e_id ;
e_name ;
job ;
skill ;
department ( - d_id - d_name)
