LAMPIRAN
Rich Picture Bagian
Connector Document
Actor
Contoh Simbol Rich Picture
Class Diagram
Contoh Simbol Class Diagram
Object Diagram
Contoh Simbol Object Diagram
L-I
StateChart Diagram
Contoh Simbol StateChart Diagram
Sequence Diagram
Contoh Simbol Sequence Diagram
Deployment Diagram
Contoh Simbol Deployment Diagram
Component Diagram
L-II
Contoh Simbol Component Diagram
Use Case Diagram
Contoh Simbol Use Case Diagram
Navigation Diagram
(Window)
C o n n e c to r
Contoh Simbol Navigation Diagram
L-III
Spesifikasi File
1. Table
: MsJabatan
Primary Key
: Jabatan
Foreign Key
:-
Field Name
Type
Size
Jabatan
VarChar
30
Field Name
Type
Size
1
KdKaryawan
Char
10
2
NmKaryawan
VarChar
30
3
TmpLahir
VarChar
15
4
TglLahir
SmallDateTime 4
5
JnsKelamin
Char
1
6
Alamat
VarChar
100
7
Kota
VarChar
15
8
Telp
VarChar
15
9
Jabatan
VarChar
30
VarChar
6
Field Name
Type
Size
JenisBarang
VarChar
30
1
2. Table
: MsKaryawan
Primary Key
: KdKaryawan
Foreign Key
: Jabatan
10 Pass
3. Table
: MsJenisBarang
Primary Key
: JenisBarang
Foreign Key
:-
1
L-IV
4. Table
: MsBarang
Primary Key
: KdBarang
Foreign Key
: JenisBarang
Field Name
Type
Size
1
KdBarang
Char
10
2
NmBarang
VarChar
30
3
Merk
VarChar
30
4
JenisBarang
VarChar
30
5
Satuan
VarChar
30
6
Harga
Int
4
7
Stock
SmallInt
2
Field Name
Type
Size
JenisJasa
VarChar
30
Field Name
Type
Size
1
KdJasa
Char
10
2
NmJasa
VarChar
30
3
JnsJasa
VarChar
30
4
Harga
Int
4
5. Table
: MsJenisJasa
Primary Key
: JenisJasa
Foreign Key
:-
1
6. Table
: MsJasa
Primary Key
: KdJasa
Foreign Key
: JenisJasa
7. Table
: MsJenisPelanggan
Primary Key
: JenisPelanggan
Foreign Key
:-
L-V
Field Name
Type
Size
JenisPelanggan
VarChar
30
Field Name
Type
Size
1
KdPelanggan
Char
10
2
NmKaryawan
VarChar
30
3
TglBergabung
SmallDateTime 4
4
Alamat
VarChar
100
5
Kota
VarChar
15
6
Telepon
VarChar
15
7
JenisPelanggan
VarChar
30
8
TglCutOff
TinyInt
1
9
KreditLimit
Int
4
1
8. Table
: MsPelanggan
Primary Key
: KdPelanggan
Foreign Key
: JenisPelanggan
9. Table
: MsMobil
Primary Key
: KdPelanggan, Nopol
Foreign Key
: KdPelanggan
Field Name
Type
Size
1
KdPelanggan
VarChar
30
2
NoPol
VarChar
9
3
Jenis
VarChar
100
4
Merk
VarChar
75
5
Type
VarChar
60
6
Tahun
SmallInt
2
L-VI
10. Table
: TrPerIntahKerja
Primary Key
: NoSPK
Foreign Key
: KdPelanggan, KdKaryawan
Field Name
Type
Size
1
NoSPK
Char
10
2
TglSPK
SmallDateTime 4
3
KdPelanggan
Char
10
4
KdKaryawan
Char
10
5
Nopol
VarChar
10
6
StatusKirim
Char
1
7
StatusTransaksi
Char
1
11. Table
: TrPerIntahKerjaBarang
Primary Key
: NoSPK, KdBarang
Foreign Key
: KdBarang, NoSPK
Field Name
Type
Size
1
NoSPK
Char
10
2
KdBarang
Char
10
3
JmlBarang
SmallInt
2
4
Harga
Int
4
Field Name
Type
Size
1
NoSPK
Char
10
2
KdBarang
Char
10
3
JmlJasa
SmallInt
2
12. Table
: TrPerIntahKerjaJasa
Primary Key
: NoSPK, KdBarang
Foreign Key
: KdBarang, NoSPK
L-VII
4
Harga
Int
4
5
Keterangan
VarChar
100
13. Table
: TrPenjualan
Primary Key
: Nopenj
Foreign Key
: NoSPK, KdKaryawan, KdPelanggan
Field Name
Type
Size
1
Nopenj
Char
10
2
NoSPK
Char
10
3
Tglpenj
SmallDateTime 4
4
KdKaryawan
Char
10
5
Diskon
Float
8
6
Statustransaksi
Char
1
7
Totalpenj
Int
4
8
KdPelanggan
char
10
9
Statusretur
char
1
14. Table
: TrPengiriman
Primary Key
: NoPengiriman
Foreign Key
: NoSPK, NoRetur, KdKaryawan, KdPelanggan
Field Name
Type
Size
1
Nopengiriman
Char
10
2
NoRetur
Char
10
3
NoSPK
Char
10
4
Tglpengiriman
SmallDateTime 4
5
KdKaryawan
Char
10
6
Keterangan
VarChar
100
7
KdPelanggan
Char
10
8
Statustransaksi
Char
1
15. Table
: TrPenerimaanKas L-VIII
Primary Key
: nopenerimaankas
Foreign Key
: nopenj, nopenagihan, KdKaryawan, KdPelanggan
Field Name
Type
Size
1
nopenerimaankas
Char
10
2
nopenj
Char
10
3
nopenagihan
Char
10
4
tglpenerimaankas
smallDateTime
4
5
KdKaryawan
Char
10
6
crbayar
VarChar
1
7
nocrbayar
Char
20
8
jmlpenerimaankas
Int
4
9
Tgltransfer
smallDateTime
4
10 nmpengirim
VarChar
30
11 KdPelanggan
char
10
16. Table
: TrPenagihanHeader
Primary Key
: Nopenagihan
Foreign Key
: nopenj, KdKaryawan, KdPelanggan
Field Name
Type
Size
1
Nopenagihan
Char
10
2
Tglpenagihan
Char
10
3
Tgljatuhtempo
SmallDateTime 4
4
Tglpenerimaankas
SmallDateTime 4
5
KdPelanggan
Char
10
6
KdKaryawan
Char
10
7
Statustransaksi
Char
1
8
Totalpenagihan
Int
4
17. Table
: TrPenagihanHeader
Primary Key
: Nopenagihan, NoPenj
Foreign Key
: nopenj L-IX
Field Name
Type
Size
1
Nopenagihan
Char
10
2
Nopenj
Char
10
18. Table
: TrReturHeader
Primary Key
: NoRetur
Foreign Key
: nopenj, KdKaryawan, KdPelanggan
Field Name
Type
Size
1
NoRetur
Char
10
2
nopenj
Char
10
3
tglretur
SmallDateTime 4
4
KdKaryawan
Char
10
5
statustransaksi
Char
1
6
KdKaryawan
Char
10
Field Name
Type
Size
1
NoRetur
Char
10
2
KdBarang
Char
10
3
JmlRetur
Int
4
19. Table
: TrReturDetail
Primary Key
: NoRetur, KdBarang
Foreign Key
: NoRetur, KdBarang
L-X
