Home

Iv.3.6 “Tblkhachhanglapdat” table (Customer Installation)

3.IV.2 Draw class diagram


Figure 3-4: Class diagram

3.IV.3 Database design

3.IV.3.1 “tblThietBi” table


STT

Attribute name

Data type

Meaning

1

MaThietBi

Int

Device Code - Master Key

2

Device Name

Nvarchar(100)

Device Name

3

MaLoai

Int

Code Type

Maybe you are interested!

Table 3-15: Table tblThietBi

3.IV.3.2 “tblSanPham” table


STT

Attribute name

Data type

Meaning

1

MaSP

Int

Product Code

2

TenSP

Nvarchar(100)

Product Name

3

DonGIa

Int

Unit price

4

Image

Image

Image

5

Technical Information

Nvarchar(MAX)

Specifications

6

Product Introduction

Nvarchar(MAX)

Product Introduction

7

BaoHanh

Nvarchar(15)

Guarantee

8

MaNSX

Int

Country of manufacture code

9

MaHSX

Int

Manufacturer code

10

MaThietBi

Int

Device code

Table 3-16: Table of tblSanPham

3.IV.3.3 Table “tblNuocSanXuat” (Country of Origin)


STT

Attribute name

Data type

Meaning

1

Water Production

Int

Country of manufacture code

2

Country of Origin

Nvarchar(50)

Country of manufacture

Table 3-17: tblNuocSanXuat table

3.IV.3.4 “tblLoaiThietBi” table (Type of Equipment)


STT

Attribute name

Data type

Meaning

1

MaLoai

Int

Type code

2

Name

Nvarchar(50)

Type name

Table 3-18: Table of Equipment Types

3.IV.3.5 “tblLapDat” table (Installation)


STT

Attribute name

Data type

Meaning

1

MaLapDat

Int

Installation code

2

Land Name

Nvarchar(50)

Installation name

Table 3-19: Table tblLapDat

3.IV.3.6 “tblKhachHangLapDat” table (Customer Installation)


STT

Attribute name

Data type

Meaning

1

MaKHLD

Int

Customer installation code

2

MaKH

Int

Customer code

3

MaLapDat

Int

Installation code

4

Land Name

Nvarchar(50)

Installation name

5

Note

Nvarchar(MAX)

Note

Table 3-20: Table tblKhachHangLapDat

3.IV.3.7 “tblKhachHang” table


STT

Attribute name

Data type

Meaning

1

MaKH

Int

Customer code

2

Name

Nvarchar(50)

Customer name

3

Contact

Nvarchar(11)

Contact

4

Address

Nvarchar(MAX)

Address

Table 3-21: tblKhachHang table

3.IV.3.8 “tblHangSX” table (Manufacturer)


STT

Attribute name

Data type

Meaning

1

MaHSX

Int

Manufacturer code

2

Manufacturer Name

Nvarchar(50)

Manufacturer name

Table 3-22: tblHangSX table

3.IV.3.9 Table “tblChiTietThietBi” (Equipment Details)


STT

Attribute name

Data type

Meaning

1

MaCTTB

Int

Device detail code

2

Name of the Company

Nvarchar(50)

Device detail name

3

Product Introduction

Nvarchar(MAX)

Product Introduction

4

Technical Information

Nvarchar(MAX)

Specifications

5

BaoHanh

Nvarchar(15)

Guarantee

Table 3-23: Equipment Details Table

3.IV.3.10 “tblChiTietLapDat” table (Installation Details)


STT

Attribute name

Data type

Meaning

1

MaCTLD

Int

Installation detail code

2

MaThietBi

Int

Device code

3

MaLapDat

Int

Installation code

4

Device Name

Nvarchar(100)

Device Name

5

Quantity

Int

Quantity

6

Technical Information

Nvarchar(MAX)

Specifications

7

MaSP

Int

Product code

8

TenSP

Nvarchar(100)

Product Name

9

DonGia

Int

Unit price

Table 3-24: Table of Details of the Land

3.IV.3.11 Table “tblChiTietKhachHangLapDat” (Customer Installation Details)


STT

Attribute name

Data type

Meaning

1

MaCTKHLD

Int

Customer installation detail code

2

MaKHLD

Int

Customer installation code

3

MaSP

Int

Product code

4

TenSP

Nvarchar(100)

Product Name

5

Quantity

Int

Quantity

6

DonGia

Int

Unit price

Table 3-25: LandedCustomerDetails table

Sequence diagram

3.V.1 Sequence diagram “Import goods”


Figure 3-5: Sequence diagram “Import goods”

3.V.2 Sequence diagram “Building a computer”


Figure 3-6: Sequence diagram “Building a computer”

VI. Functional decomposition diagram

3.VI.1 Functional decomposition chart of “Import Management”



Figure 3-7: Functional decomposition chart of “Import Management”


3.VI.2Functional decomposition chart “Installation Management – ​​Installation formula”


Figure 3-8: Functional decomposition chart “Installation management – ​​Installation formula”

3.VI.3 Functional decomposition diagram “Building a computer”


Figure 3-9: Functional decomposition diagram “Building a computer”

Comment


Agree Privacy Policy *