, :
- ;
- ;
- ;
- , ;
- ' .
, .
1 , :
- / ;
- , , ' ;
- ;
- - . (, ..), , , , , .
1 , , , , ..
2 , , .. , .
3 , , , , .
4 , .
5 , , , ..
ֲ
1 - ., ., . . .: . . - .: "³", 2004. - 1088 .
2 . . .:. . - 6- . - .: ij, 1998. - 784 .
3 .. CASE-㳿. -. - 3- . - .: -,2002. - 320 .
4 .. : , , . - .: , 2001. - 304 .
5 .. . - .: Գ , 2002. - 800 .
6 ., ., . : , . ., 2- .: . . - .: ³, 2001. - 1120 .
7 . . 9- . - .: , 2005. - 859 .
8 .. BPWin ERWin. CASE- . - 2- ., . . - .: -, 2001. - 304 .
|
|
|
9 .. AllFusion Modeling Suite. - .: -, 2003. - 432 .
10 ., . : , . - 5- ., . .: . . - .: -,
2004. - 1040 .
11 .., .. : .-. . . . . - .: , 2005. - 264 .
1
()
1)
2) , :
, (), . , 2 : . () ... .. ..
2
) () ()
1. , : , .
2. , : 1-4 , , .
3. , :
4. - , ,
5. ..
) , :
-
- ,
- ,
- ,
- , , :
, , ..
3
EER
4
( IDEF1X)
5.1 - ()
5.2 - ()
5
SQL
REATE TABLE Devise(ID_device INTEGER NULL, /* Devise ID_device */
ID_kind INTEGER NOT NULL /* ID_kind*/
name_device VARCHAR(20) NULL, /* name_device*/
Features VARCHAR(20) NULL, /* Features*/
Item_number INTEGER NULL, /* Item_number */
warranty DATE NULL /* warranty*/
class INTEGER NULL); /* class*/
|
|
|
ALTER TABLE Devise ADD PRIMARY KEY (ID_device,ID_kind); /* Devise ID_kind */
CREATE TABLE Devise___Supplier /* Devise___Supplier */
(ID_device INTEGER NOT NULL, /* ID_device */
ID_Supplier INTEGER NOT NULL, /* ID_Supplier */
date_of_purchase DATE NULL, /* date_of_purchase*/
cost INTEGER NULL, /* cost */
ID_kind INTEGER NOT NULL); /* ID_kind */
ALTER TABLE Devise___Supplier
ADD PRIMARY KEY (ID_device,ID_Supplier,ID_kind); /* Devise___Supplier ID_kind */
CREATE TABLE Kind_device /* Kind_device */
(ID_kind INTEGER NULL, /* ID_kind */
name_kind VARCHAR(20) NULL); /* name_kind */
ALTER TABLE Kind_device ADD PRIMARY KEY (ID_kind); /* Kind_device ID_kind */
CREATE TABLE Supplier /* Supplier */
(ID_Supplier INTEGER NULL, /* ID_Supplier */
name_supplier VARCHAR(20) NULL, /* name_supplier */
adress VARCHAR(20) NULL); /* adress */
ALTER TABLE Supplier
ADD PRIMARY KEY (ID_Supplier); /* Supplier ID_Supplier */
6
. , .1.
6.1 -
, . , .2.
6.2 -
7
, '
.
SELECT & & left(,1) & .
& left(,1) as , ,
FROM , ,
WHERE . = ._
and ._ = ._
and in (,)
ORDER BY & & left(,1) & .
& left(,1);
(
2) 1 2 3?
SELECT DISTINCT , ,
FROM , ,
WHERE . = ._
and ._ = ._
and ._ in (1,2,3)
,
?
SELECT DISTINCT _,
FROM , t1, t2
WHERE . = t1._
and = 5
and t2._ = t1._
and EXISTS(
SELECT *
FROM ,
WHERE ._ = ._
and _ = t1._
and <> t2.);
8
˲
// ------------- --------------------------------
1 .., .. (). .: BHV, 2006.
2 . . : , . . , 2001. (2003)
3 .., .., .. . - , , 2002. (2003)
4 .. : . - .:- , 2003
5 Batini, C., Ceri, S., Navathe, Sh. Conceptual Database Design. Benjamin / Cummings Publishing Company, Inc., 1992, - 496 p.p. (it is available at the ASU- Dept library).
6 , . UML. - .: , 2002.
|
|
|
// ---------------- ----------------------
7 .. . - ., , 2002.
8 , - / .., .., .., .. : Ȼ, 2005.
9 .. . - ., , 2000.
10 .. BpWin ErWin: CASE- . .: -Ȼ, 2000.
