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].