, CSP, .
( .1) :
- ( .2);
- ( .4);
- ( .6);
- ( .8);
- ( .10);
- ( .12);
- ( .14).
, ( .16) , ( .17). ( .3, .5, .7, .9, .11, .13, .15) .
- , , Cache CSP.
1 .. SADT / .. , . - .: -, 1993. - 243 .
2 IDEF0, IDEF1X, IDEF3. - URL: http://www.idef.com/.
3 .. AllFusion Process Modeler 4.1. ? ? ? - .: -, 2004. - 464 .
4 .. AllFusion Modeling Suite. - .: -, 2005. - 432 .
5 . Caché 5. - / . , . , . , . - .: -, 2005. - 416 .
.1 -0
.2 0
.3 1
.4 2
.5 3
.1
.2
:
CREATE TABLE CLIENT
(
ClienNo INTEGER NOT NULL,
Name VARCHAR(50) NULL,
Address_obj VARCHAR(50) NULL,
Telephone VARCHAR(20) NULL,
Pasport INTEGER NULL
);
ALTER TABLE CLIENT
ADD PRIMARY KEY (ClienNo);
CREATE TABLE CONT_EST
(
EstimateNo INTEGER NOT NULL,
Work_volume VARCHAR(20) NULL,
ServiceNo INTEGER NOT NULL
);
ALTER TABLE CONT_EST
ADD PRIMARY KEY (EstimateNo,ServiceNo);
CREATE TABLE CONTRACT
(
ContractNo INTEGER NOT NULL,
Signing_date DATE NULL,
ClienNo INTEGER NOT NULL,
Address_obj VARCHAR(50) NULL,
Cost INTEGER NULL,
Start_date DATE NULL,
End_date DATE NULL,
Payment_deadline DATE NULL
);
|
|
ALTER TABLE CONTRACT
ADD PRIMARY KEY (ContractNo);
CREATE TABLE ESTIMATE
(
ContractNo INTEGER NOT NULL,
Total_cost INTEGER NULL,
EstimateNo INTEGER NOT NULL
);
ALTER TABLE ESTIMATE
ADD PRIMARY KEY (EstimateNo);
CREATE TABLE ORDER
(
OrderNo INTEGER NOT NULL,
ClienNo INTEGER NOT NULL,
Registration_date DATE NULL
);
ALTER TABLE ORDER
ADD PRIMARY KEY (OrderNo);
CREATE TABLE SERVICE
(
ServiceNo INTEGER NOT NULL,
Name VARCHAR(50) NULL,
Work_unit VARCHAR(20) NULL,
Price_of_workunit INTEGER NULL
);
ALTER TABLE SERVICE
ADD PRIMARY KEY (ServiceNo);
CREATE TABLE WISH
(
WishNo INTEGER NOT NULL,
ServiceNo INTEGER NOT NULL,
OrderNo INTEGER NOT NULL
);
ALTER TABLE WISH
ADD PRIMARY KEY (WishNo,OrderNo);
ALTER TABLE CONT_EST
ADD CONSTRAINT R_8 FOREIGN KEY (EstimateNo) REFERENCES ESTIMATE (EstimateNo)
ON DELETE CASCADE;
ALTER TABLE CONT_EST
ADD CONSTRAINT R_16 FOREIGN KEY (ServiceNo) REFERENCES SERVICE (ServiceNo)
ON DELETE CASCADE;
ALTER TABLE CONTRACT
ADD CONSTRAINT R_1 FOREIGN KEY (ClienNo) REFERENCES CLIENT (ClienNo)
ON DELETE CASCADE;
ALTER TABLE ESTIMATE
ADD CONSTRAINT R_6 FOREIGN KEY (ContractNo) REFERENCES CONTRACT (ContractNo)
ON DELETE CASCADE;
ALTER TABLE ORDER
ADD CONSTRAINT R_14 FOREIGN KEY (ClienNo) REFERENCES CLIENT (ClienNo)
ON DELETE CASCADE;
ALTER TABLE WISH
ADD CONSTRAINT R_10 FOREIGN KEY (ServiceNo) REFERENCES SERVICE (ServiceNo)
ON DELETE CASCADE;
ALTER TABLE WISH
ADD CONSTRAINT R_15 FOREIGN KEY (OrderNo) REFERENCES ORDER (OrderNo)
ON DELETE CASCADE;
.1 Web- MAIN.csp
.2 Web- CLIENT.csp
.3 Web- CLIENTEdit.csp
.4 Web- CONTRACT.csp
.5 Web- CONTRACTEdit.csp
.6 Web- WISH.csp
.7 Web- WISHEdit.csp
.8 Web- ORDER.csp
.9 Web- ORDEREdit.csp
.10 Web- SERVICE.csp
.11 Web- SERVICEEdit.csp
.12 Web- ESTIMATE.csp
.13 Web- ESTIMATEEdt.csp
.14 Web- CONTEST.csp
.15 Web- CONTESTEdit.csp
.16 Web- CONTRACTFind.csp
.17 Web- ESTIMATEFind.csp