-
3.
: .
: 230103 ( ).
: . .
: .
:
- . .
: , .
: 2 .
: , .
:
1. ?
2. ?
3. ?
:
1. .
2. .
3. .
: .
: , .
: 4 .
: .
:
1. .., .., .. : . .: : -, 2003. 352 .: . ( ).
2. .. .: , 2002. 376 ., . + - .
.
3.
.
, Paradox 7, .
:
1. Post ()
| CodeP | Short | * | ||
| NameP | Alpha |
2. Grps ( )
| CodeGr | Short | * | ||
| NameGr | Alpha |
3. Tov ()
| Code | Short | * | ||
| CodeGr | Short | |||
| Model | Alpha | |||
| OptCena | Money |
4. Zak ()
| CodeZ | Short | * | ||
| Code | Short | |||
| CodeP | Short | |||
| (%) | TorgNadb | Number | ||
| StDost | Money | |||
| () | SrokDost | Short | ||
| () | SrokGar | Number | ||
| Qty | Short |
|
|
|
:
1. , .
2. , 20. , , , .
3. , () , , , Cost ( ). .
4. , 1.5 . - AvgCost, .
5. ( ) 400, 500, .. 400, 500. AvgCost1 , .
6. , MaxCost1, MinCost1 ( ) , .
:
I
1. Postavkil, .
2. Database Desktop. :\..\Postavki. 1 Post, Grps, Tov, Zak .
3. :
| Grps | Tov | CodeGr |
| Post | Zak | CodeP |
| Tov | Zak | CodeT |
:
3.1. (Tov) Database Desktop Table/Restructure.
3.2. Table properties Referential Integrity. Define.
3.3. Referential Integrity CodeGr →
3.4. Grps ←.
3.5. Cascade Strict Referential Integrity. OK.
3.6. (GT). .
.
4. , :
Post
| CodeP | NameP |
| - | |
Grps
| CodeGr | NameGr |
Tov
| Code | CodeGr | Model | OptCena |
| C110GLS | 990.00 | ||
| C200GLS | 1430.00 | ||
| C300GLS | 2470.00 | ||
| C310GLS | 2965.00 | ||
| C400GLS | 4270.00 | ||
| C450GLS | 5124.00 | ||
| C500GLS | 7378.00 | ||
| F100G | 1608.00 | ||
| F150G | 1840.00 | ||
| F200G | 1930.00 | ||
| F250G | 2076.00 | ||
| F300G | 2551.00 | ||
| F400G | 3513.00 | ||
| F450G | 3815.00 | ||
| F500G | 4878.00 | ||
| F600G | 6210.00 |
Zak
|
|
|
| CodeZ | Code | CodeP | TorgNadb | StDost | SrokDost | SrokGar | Qty |
| 4.0 | |||||||
| 3.9 | 1.5 | ||||||
| 3.5 | 1.5 | ||||||
| 3.5 | |||||||
| 3.6 | |||||||
| 2.8 | |||||||
| 3.8 | |||||||
| 4.9 | |||||||
| 4.7 | |||||||
| 4.2 | 1.5 | ||||||
| 3.1 | 2.5 | ||||||
| 3.9 | |||||||
| 4.5 | |||||||
| 3.7 | 2.5 | ||||||
| 4.1 | |||||||
| 4.2 | 1.5 | ||||||
| 3.6 | |||||||
| 4.5 |
