1.
. .
. , , , ( , , ).
:
1. .
2. .
3. .
4. . , ( 6 ).
5. .
.
:
1. .
2. .
3. .
4. .
5. .
, , :
, , .
:
.
 | |||
| |||
|
|
 |
|
 | |||
 |
 |
 | ||||
 | ||||
. ER .
 | |||||||||
 | |||||||||
 | |||||||||
| |||||||||
|
.
:
Specialty .
Diseases .
CostOfService .
Percents .
Salary .
Medicalhistory .
Ktime .
Ntime .
().
:
1. .
2. .
3. .
4. . , ( 6 ).
5. .
().
, , , :
|
|
|
1. >=0.
2. .
: (), .
1. () ER-.
2. (1-12).
3. (), .
4. .
1.
|
|
:
 | | ||||||
 | |||||||
 | |||||||
7:
Patient (SP, )
Doctor (vNom, )
2.
3. :
|
 | | ||||||||
 | |||||||||
 | |||||||||
 | |||||||||
|
6:
Patient (SP, )
Contract (Nom, )
.
 |
1.
|
2. Doctor (vNom, )
3. 
Patient (SP, )
4. Contract (Nom, )
5. Contract (Nom, )
.
 | |||
 |
.
Paradox.
.
| Patient | SP FIO RDate Pol Oplata MH | Alpha Alpha Date Alpha Alpha Alpha | ###-########## , . . . | ||
| Doctor | vNom FIO RDate Pol Specialty Ntime Ktime Salary | Autoincrement Alpha Date Alpha Alpha time time Money | >=0 | , | |
| Contract | Nom SP vNom Diseases Time CostOfService Date | Autoincrement Alpha Long Integer Alpha Time Money Date | >=0 | ###-########## |
MS SQL Server SSMS.
. 1
