DELPHI
2
2012
6.080400 .
.
__ 20__ . ( _)
.............................................................................................. 2
1. ................. 4
2. FlameRobin......... 7
3. ................ 10
4. ..................... 19
1. :........... 22
Delphi , .
- Firebird, BDE Delphi , .
, , . :
1. :
| 1 | ||||
| : | ||||
| 10.02.2002 | "" | . , . , 25, . 68-77-86 | ||
| , | ||||
| , 500. | 4,78 | |||
| 3,15 | ||||
| 1,40 | ||||
| - | , 0,5 | 1,67 | ||
| 5,15 | ||||
| 1891 |
2. , :
| . | . . | |||
| , 500. | 4,78 | |||
| 3,15 | ||||
| 1,40 | ||||
| - | , 0,5 | 1,67 | ||
| 5,15 | ||||
| , 400. | 3,78 | |||
| 3,25 | ||||
| 3,42 | ||||
| 8,75 | ||||
| , 0,5 | 1,80 | |||
| - | , 0,5 | 1,75 |
|
|
|
3. , ( 10.02.02):
| : | . | , . | |
| "" | . , . , 25 | 68-77-86 | |
| "" | . , . ,35. | 23-71-63 | |
| "" | . , . , 45 | 46-87-883 |
ER . . :
1. " " Firebird.
2. Torgovl Firebird.
3. - Delphi Torgovl, :
:
1. - . : , . :
a) ;
b) ( , );
c) .
2. - . :
a) , ;
b) ;
c) , 1000 . .
3. - . :
a) , ;
b) , ;
c) ;
d) , +100 .;
e) , .
ADO, IBX (Interbase Express) dbExpress, Delphi. [3], III.
ZeosDBO, ZeosLib Development Group, http://zeos.firmos.at, - http://www.sourceforge.net/projects/zeoslib
1. .
.
| 123 | ||||
| : | ||||
| 10.02.2002 | "" | . , . , 25, . 68-77-86 | ||
| . | ||||
| 4,78 | 478 | |||
| 3,15 | 630 | |||
| 1,40 | 140 | |||
| - | 1,67 | 334 | ||
| 5,15 | 309 | |||
| 1891 |
- 1:
1.
| --- |
| - |
|
|
|
-
→ , .
→ , ,
(, ) →
(, ) → ( )
( , ) → -
(-, ) →
- . :
( , , )
(., , )
( , , . ). , , .
, 1. , , . 2.
2.
| --- | |
| (PK) | |
| - | |
| ( * ) |
2 , (PK).
2 (2 ), :
3
| -- | ||||
| (FK) | (PK) | (PK) | ||
| (FK) | (AK) | |||
| (FK) | (FK) | |||
| - | ||||
| ( * ) |
| (PK) | (PK) | |||
| (FK) | ||||
| . | ||||
. (3 ), :
4
| (PK) | |
| . | |
, . , , :
5
| 
| ||||
| (PK) | (PK) | (PK) | |||
| () | 
| ||||
| (FK) |
| --- | |||
| (FK) |  (PK)
| (PK) | |
| (FK) | |||
| - | |||
| = - * | (FK) |
1. , 5 ERStudio , DDL.
ERStudio (. 1):
1.
DDL :
/* TABLE: Nakl */
CREATE TABLE Nakl(NaklNom INTEGER NOT NULL, IdPokup INTEGER NOT NULL,
NaklDate DATE NOT NULL, CONSTRAINT NaklPK PRIMARY KEY (NaklNom));
/* TABLE: Otpusk */
CREATE TABLE Otpusk(IdTov INTEGER NOT NULL, NaklNom INTEGER NOT NULL,
Kvo INTEGER DEFAULT 1 NOT NULL, CONSTRAINT OtpuskPK PRIMARY KEY (IdTov,NaklNom));
/* TABLE: Pokup */
CREATE TABLE Pokup(IdPokup INTEGER NOT NULL, PokupName VARCHAR(30),
Kredit FLOAT DEFAULT 0 NOT NULL, City VARCHAR(20) NOT NULL,
TelNom CHAR(12) NOT NULL, CONSTRAINT PokupPK PRIMARY KEY (IdPokup));
|
|
|
/* TABLE: Tel */
CREATE TABLE Tel(City VARCHAR(20) NOT NULL, TelNom CHAR(12) NOT NULL,
Address VARCHAR(50) NOT NULL, CONSTRAINT TelPK PRIMARY KEY (City,TelNom));
/* TABLE: Tovar */
CREATE TABLE Tovar(IdTov INTEGER NOT NULL, TovName VARCHAR(40) NOT NULL,
EdIzm VARCHAR(14) NOT NULL, Cena FLOAT NOT NULL, TovGroup VARCHAR(30),
CONSTRAINT TovarPK PRIMARY KEY (IdTov));
/* TABLE: Nakl */
ALTER TABLE Nakl ADD CONSTRAINT NaklPokFK FOREIGN KEY(IdPokup) REFERENCES Pokup(IdPokup);
/* TABLE: Otpusk */
ALTER TABLE Otpusk ADD CONSTRAINT OtpTovarFK FOREIGN KEY(IdTov) REFERENCES Tovar(IdTov);
ALTER TABLE Otpusk ADD CONSTRAINT OtpNaklFK FOREIGN KEY(NaklNom) REFERENCES Nakl(NaklNom);
/* TABLE: Pokup */
ALTER TABLE Pokup ADD CONSTRAINT PokTelFK FOREIGN KEY(City,TelNom) REFERENCES Tel(City,TelNom);
ERStudio [1].
