BM.PM.05.01
nbh:
Trang 1
ThiÕt kÕ phÇn mÒm chi tiÕt
Môc lôc
1. ThiÕt kÕ chøc n¨ng ....................................................................
1.1 S¬ ®å khèi m« t¶ c¸c chøc n¨ng ........................................
1.2 M« t¶ chi tiÕt c¸c chøc n¨ng ...............................................
2. ThiÕt kÕ c¬ së d÷ liÖu .................................................................
2.1 ThiÕt kÕ lu
tr÷........................................................................................
2.2 ThiÕt kÕ ph©n
quyÒn...............................................................................
2.3 ThiÕt kÕ c¸c ®èi tîng cña
CSDL...........................................................
3. ThiÕt kÕ c¸c hµm, thñ tôc, biÕn dïng chung .............................
3.1 Danh s¸ch ...........................................................................
3.2 M« t¶ chi tiÕt ........................................................................
4. C¸c tiÖn Ých cÇn thiÕt ..................................................................
4.1 Danh s¸ch ...........................................................................
4.2 M« t¶ c¸ch sö dông ............................................................
5. ThiÕt kÕ giao diÖn
5.1 Yªu cÇu chung ®èi víi giao diÖn ..........................................
5.2 CÊu tróc giao diÖn ..............................................................
5.3 M« t¶ chi tiÕt giao diÖn ........................................................
6. ThiÕt kÕ report ...........................................................................
6.1 Danh s¸ch reports ...............................................................
6.2 M« t¶ chi tiÕt ........................................................................
7. KÕ ho¹ch ®¸nh gi¸ vµ ch¹y thö ................................................
7.1 KiÓm tra menu ...................................................................
7.2 KiÓm tra giao diÖn ..............................................................
7.3 KiÓm tra c¸c b¸o c¸o .........................................................
7.4 KiÓm tra code....................................................................
7.5 §a ra c¸c ph¬ng ¸n d÷ liÖu ®Ó test lçi ..........................
BM.PM.05.01
nbh:
Trang 2
1. ThiÕt kÕ chøc n¨ng
(Híng dÉn tham kh¶o ë tµi liÖu HD.PM.05.02, môc 1)
1.1 S¬ ®å khèi m« t¶ chøc n¨ng
(VÏ s¬ ®å khèi )
1.2 M« t¶ chi tiÕt chøc n¨ng
B¶ng 1 : M« t¶ quan hÖ gi÷a c¸c chøc n¨ng
ST
T
Chøc n¨ng b¾t
®Çu
Chøc n¨ng tiÕp
theo
Sù kiÖn M« t¶
2. ThiÕt kÕ c¬ së d÷ liÖu
2.1 ThiÕt kÕ lu tr÷:
§èi víi c¸c hÖ qu¶n trÞ CSDL DB2, Foxpro, Access:
ChØ ra ®êng dÉn vµ th môc lu tr÷
§èi víi c¸c hÖ qu¶n trÞ CSDL Oracle, SQL,....
B¶ng 2 : Danh s¸ch c¸c datafiles
STT
Tªn
datafiles
Path
Tªn
tablespace
th¸i(online/offline)
KÝch
thíc
BM.PM.05.01
nbh:
Trang 3
B¶ng 3 : Danh s¸ch c¸c tablespaces:
Name
Status
Initial
size
Next
size
Increase
size
Minimum
Maximum
B¶ng 4 : Danh s¸ch c¸c Rollback segment:
Name
Tablespac
e
Lo¹i
Status
Initial
size
Next
size
Minimu
m
Maximum
2.2 ThiÕt kÕ ph©n quyÒn
2.2.1 QuyÒn hÖ thèng
B¶ng : Danh s¸ch c¸c quyÒn hÖ thèng
System privileges name
2.2.2 QuyÒn ®èi tîng
B¶ng : Danh s¸ch
Object
name
Privileges
Exec
Alter
Select
Insert
Update
2.2.3 QuyÒn ngêi sö dông
(§iÒn néi dung vµo BM.PM.05.07)
BM.PM.05.01
nbh:
Trang 4
2.3 ThiÕt kÕ c¸c ®èi tîng cña CSDL:
2.3.1 Clusters:
Name
Tablespac
e
Siz
e
Type
Tabl
e
Colum
n
Initial
size
next
size
Increas
e size
Option
2.3.2 Database Links:
Name
User name
Service name
2.3.3 Functions, procedures
2.3.3.1 Danh s¸ch
B¶ng : Danh s¸ch c¸c functions, procedures
STT
Tªn
Sè hiÖu tµi liÖu
2.3.3.2 M« t¶ chi tiÕt
(§iÒn néi dung vµo BM.PM.05.08)
2.3.4 Indexes
B¶ng : Danh s¸ch c¸c Index
Index
name
Table
name
Column
names
N
ext
size
Increas
e
Spac
e
usag
e
Number of
transaction
Parallel
BM.PM.05.01
nbh:
Trang 5
2.3.5 Packages:
2.3.5.1 Danh s¸ch
STT
Tªn
Sè hiÖu tµi liÖu
2.3.5.2 M« t¶ chi tiÕt
(§iÒn néi dung vµo BM.PM.05.09)
2.3.6 Sequences:
B¶ng : danh s¸ch
Name
Minimum
value
Maximum
value
Increment
value
Initial value
Cicle/nocicl
e
2.3.7 Synonyms:
STT
Name
Table name
2.3.8 Tables:
2.3.8.1 Danh s¸ch tables
Name
Tablespac
e
Initial
size
Next
size
Increase
size
Option
Sè
hiÖu
tµi