DO GIAO Dl)C

vA DAo T~O
TRUONG D~I HOC DAN L~P NGO~I NGU -'TIN HOC 'rP.HCM
KHOA CONG NGHt THONG TIN
-----000 -----

KHOA LUAN
TOT NGHIEP
•
•
. XA Y DUNG
.

HO

TRANG WEB
TRO. MUA BAN
BA T DONG
SAN TREN MANG
.
.
A'

.

A

?

A

_

J

GIANG vrEN HUaNG DAN: TS. D4.NG TRUONG SON
SINH vrEN THljC HltN
: CAO THI HoAI PHUONG

THANH PHO

HO CHi MINH -

NAM 2002


Lui cam

dn

Em xin chan thanh cam on :
Cac Thgy Co Khoa Cong Ngh~ Thong Tin Tn/ang D(;li HQc Dan
L~p Ngo(;li Ngu Tin HQc - nhung nguai dff truy~n d(;lt l(;li cho chung em
nhung kie'n thuc quy bau trong su6t b6n nam qua.
Thgy - Dijng Truong Sdn - nguai dff t~n Hnh chi bao va huang dftn
cho em trong su6t thai gian lam D6 An Thlfc T~p T6t Nghi~p va Lu~n Van
T6t Nghi~p .
Gia dlnh- va b(;ln be - nhung nguai dff dQng vien giup dB v~ m~t
tinh thgn d~ em co dUQcnhu ngay hom nay ...
Thanh Ph6 H6 Chi Minh, ngay 23 thang 7 nam 2002

Cao Thi Hoai Phuong


Mue
. lue
.
Loi cam on
Loi md dgu
'"

,,?

"

,,'

CHu'(jNG I: TIM HIEU H:e THONG
(

II.
III.
IV .

TIm hiSu cac hlnh thuc mua ban ba't dQng san tren thi truong
Va nhii'ng ho~t dQng CJcong ty tu'va-n
D~n de'n slf ra doi batdongsan.com
" ca~u d e~ ta,,'1.
Y eu

CHu'(jNG II : PHAN TICH THlET


KE MO HINH HE

I. M6 hlnh xiI 1:9'
1.1. DFD muc ngu canh
1.2. DFD mac O
1.3. DFD muc 1
1.3.1. DFD muc 1 clla Process 1.
1.3.2. DFD muc 1 clla Process
1.3.3. DFD muc 1 clla Process
1.3.4. DFD muc 1 clla Process
1.3.5. DFD muc 1 clla Process
1.3.6. DFD muc 1 clla Process
II. M6 hlnh thlfC thS
II.l. ERD muc lu~n 1:9' (ve ra)
11.2. ERD muc v~t 1:9'
'K
b?ang
II ..3 M"0 ta? c h'I tiet
II.3.1 [KhachHang]
11.3.2 [DienDan]
11.3.3 [HoaDon]
11.3.4 [Admin]
11.3.5 [Quan]
11.3.6 [ThanhPho]
II.3.7 [ThongTinNhaDat]
11.3.8 [ThongTinThiTruong]
11.3.9 [TheTinDung]

!


!
2
2
.

THONG
3
3
4

2
3
4
5
6

5
6
7
8
9
10
.
11
12
.
13
13
14

15
15
15
15
17
17


-----------------------------------.
vA THu'(jNG M~I DItN TV

CHu'(jNG III :GIOI THItU VE THE TiN Dl)NG
I.
II.

The tin d\lng la gl ? Ti~n lch the tin d\lng ?
Thuong mC;lidi~n tU'la gl ?

19
19

III.

Lam vi~c vdi cae the tin dVng trong thu'dng m~i di~n tll'
III.l. Cac phuong phap xU'ly the tin d\lng
II1.2. Dich V\l xU'ly the tin d\lng : CyberCash
III.2.l. MCimQt tai khoan thuong mC;litin d\lng
III.2.2. Dang ky tC;liCyberCash
III.2.2.3. Cai d?t phftn m~m CyberCash
III.2.2A. Xac thlfc mQt giao dich sU'd\lng the tin d\lng

III.2.2.5. Thanh toan cac giao dich sU'd\lng the tin d\lng

21
21
24
24
24
25
25
26

CHu'(jNG IV:

HItN THTjC CHu'(jNG TRINH

1. Trang chli
2. Link "Rao ban -- Cho thue"
3 . L'In k"H?'d'
0I ap "
4. Link "Tha nh vie n "
5 . L'Ink "Q?ua n tr~."
at "
6 . L"Ink "Q?ua n tr~. nh'a d""
7. Link "Quan tri khach ha ng"
01 ap
8 . L.Ink"Q? uan tr~'h?'d'"
9. Link "Quan tri hoa don"
h"
' t h'~truong
, "

tm
10 .L'm k "Q?uan tq. tong
vOl passwor d?'"
quan tr~
11 .L.Ink "1:'\,:/'
h""
k"e "
12 .L'Ink "B a' 0 ca, 0 tong

,
,

29
32
. 35
37
.41
.43
.43
.45
47
.48
.49
. 50

CHu'(jNG V : cAe CONG NGHt LIEN QUAN
I. Microsoft Visual Interdev
II. ADO - ActiveX Data Objects
III. ASP - Active Server Pages
IV. SQL Server

Vanh gia ke't luan va huang phat tri~n
Tai lieu tham khao

52
52
65
81


Lui mUddu
Ngay nay, vai slf phat tri€n vu<;1tb~c cua khoa hQc kI thu~t va d~c
bi~t la Cong ngh~ Thong tin, chi b~ng cach sa huu mQt chi6c may Hnh va
tham gia vao m~ng Internet, b~n se d~ dang ngao du kh~p do day, rna
rQng hi€u bi6t, c~p nh~t thong tin, huu d\Jng hdn ca la b~n ng6i t~i nha rna
v~n co th€ mua s~m, tham quan hang hoa hay nhung thli mlnh cftn khac .
Va n6u b~n co nhu cftu v~ nha da't thl sao?
Va'n d~ d~t ra la phai co mQt Website giao dich ba't dQng san lam
cftu n6i giua khach hang mu6n ban va khach hang mu6n mua, cang quan
trQng va ca'p thi6t hdn nua khi khach hang hi~n nay khong co nhi~u thai
gian di san lung nhung can nha mlnh thich hay mu6n nhanh chong ban
dUQcnha da't cua mlnh ! £>6 cling chinh la m\Jc dich cua d~ tai nay: "Xay
dtfng trang Web h6 trq mua ban ba't dQng san tren m~ng" !
V~y n6u 1 ngay nao do b8ng dung b~n co nhu cftu v~ nha da't thl xin
mai hay d6n ngay vai batdongsan.com cua chung toi !
• B{ln dang tim moo hay thue ml)t can nha hay mitng dal ?
Hang ngan m\Jc nha da't dang du<;1crao ban va rao thue lien
t\Jc du<;1cc~p nh~t su6t 24 ti6ng d6ng h6 d€ b~n luon Hm tha'y
thong tin mai nha't , b~n se an tam Hm du<;1cnha mlnh Ltng y
nh(1't vai gia t6't nhf{t !
• B{ln muo11tim thay can nha md due chI trong 60 giay ?

TIm ki6m nha da't chua bao gia nhanh chong d6n th6 ! B~n Hm
nha duai 100 lu<;1nga nQi thanh ? Hay nha khoang 100 met
vuong ? Hay nha trong khu buon ban co huang Tay Nam
? ..Ta't ca chi ma't 60 giay tren batdongsan.com.vn . Bai VI nha
t6t se kh6ng cha lau , va thai gian la yang b~c , hay t~n d\Jng
slf nhanh chong va ti~n l<;1ia batdongsan.com.

• B{lll lJ xa muon tim nha lJ Thanh pho' H6 Chi Minh?
B~n khong cftn phai l~n IQi de'n Thanh Ph6 H6 Chi Minh d€
Hm nha a do , batdongsan.com co m~t a ta't ca mQi ndi . Nhu
v~y , mQi nguai d~u co th€ Hm va xem nha da't a mQi tlnh
thanh vai dfty du chi tie't va hlnh anh nhu di d6n t~n ndi v~y !
• B(P' co ml)t ciin nha hay mie1lg dal clin rao ban, rao thue ?


BC;lnco th~ quang cao vo cung chi tie't v~ din nha cua bC;ln,
ngay ca hlnh anh ...Can nha se tlf tlm dung ngu'oi quan Him
de'n no nhfft . Nhu' v~y bC;lnban du'Qcnha nhanh nht{t va dLt(/c
gia nhfft !
• Hay brpl chi co Ilhu ciiu tim hiiu vi thi trliullg bitt dQllg sail ?
BC;lnkhong cftn phai lien h~ voi bfft kl m(>tnhan v~t nao do co
kinh nghi~m trong thi tru'ong nha dfft rna vftn co th~ bie't du'Qc
tlnh hlnh nha dfft hi~n tC;lira sao!
Website ph\lc V\l cho d~ tai nay mang m(>t Y nghla thie't thlfc trong
nhip s6ng cong nghi~p hi~n nay, no ph\lc V\l cho tfft ca mQi d6i tu'Qng quan
tam hay co nhu cftu v~ bfft d(>ng san chi ddn gian voi vi~c truy c~p Internet



Trail


1

I. Tim hi~u cac hinh thuc mua ban ba"tdong san tren thi trtlClng til
trtlO'c de'n nay ...
Chung ta xua nay vfrn thuang phai t6n ra't nhieu thai gian, cong suc
va ca tien b~c cho vi~c rao hay tIm mua nha da't . Nguai mu6n ban hay
th~m chi mu6n mua ne'u mu6n nhanh chong ban hay mua du<;1cnha cftn
phai di tlm mQt nhan v~t nao do chuyen ve lInh v\fc nha da't rna doi khi
chung ta thuang gQi la "co ", nhan v~t nay se tlm cach nay hay cach kia
giup chung ta ban (hay mua) dUQc nha va se du<;1chudng muc phftn tram
tren gia ca. Cach lam nay tuy co mQt s6l<;1iich nha't dinh nhung r6 rang dii
lam tieu t6n thai gian va tien b~c cua chung ta, ngoai ra no con cho tha'y
mQt nhuQc di€m la s\f h~n che've tftm v\fc anh hUdng, nghIa la khong co
nhieu nguai se bie't d€n ngoi nha cua chung ta, va dieu do doi khi dfrn d€n
slf thi~t thoi ve gia ca ...

II ....Va nhung hoat dong iJ cong ty ttl va"nva kinh doanh nha da"t
Cong ty tu va'n va kinh doanh nha da't co chuc nang chinh la tu va'n
phap ly, tu va'n dinh gia nha da't, giup hoan ta't thu tl.lc mua ban ..Ben c~nh
do cong ty con ke't h<;1pthem dich Vl.lgioi thi~u nha da't, t~o slf thu~n l<;1i
cho ca hai lo~i khach hang mu6n mua va ban. Dieu nay nghIa la khi mQt
khach hang co nhu cftu rao ban hay cho thue can nha, hQ se lien h~ voi
cong ty, dien thong tin vao mQt mfru co san, dinh kern hlnh anh (ne'u co),
va nQp mQt it phi quang cao (tuy thuQc thai h~n rao va hlnh thuc quang
cao), hlnh anh va thong tin can nha sau do se du<;1cniem ye't trangtrQng va
dt;p de t~i cong ty, cong ty se co them nhieu hlnh thuc quang cao ngoi nha
cua khach hang de'n voi mQi nguai nhu phat
buom, quang cao qua di~n
tho~i .., Nhu the', se co nhieu nguai hdn bi€t de'n ngoi nha cua b~n. Hdn the'

nITa, ne'u b~n la khach hang co nhu cftu mua thue khi de'n voi cong ty se
ch~ng phai t6n mQt xu n~lOrna vfrn co th€ bie't them ra't nhieu thong tin nha
da't ha'p dfrn va nang h6i dang rao.

ta

The' nhung khi Internet bung n6 va mQi thu duang nhu deu co th€
dua len m~ng trao d6i mua ban va nguai ta mua s~m hang hoa rna khong
cftn phai buoc ra khoi nha thl va'n de d~t ra voi mQt cong ty h6 trQ mua ban
nha nhu tren la lam sao d€ khach hang co th€ thao tac mQi thu tl.lc,tlm
kie'm mQi thong tin nhu khi de'n voi cong ty rna ch~ng c~n phai di dau ca ?


Trail

2

III ... Dan de'n so' ra dO'ibatdongsan.com
Va nhu the' la mQt Website nua dUQcra dai d~ mang den nhung ti~n
IQi moi cho khach hang ding nhu mang them nhi~u ngu6n IQi den cho
cong ty.
Website nay c~n phai h6 trQ mQi thao tac nhu khi khach hang de'n
voi cong ty, ben cC;lnhdo Website con phai mang de'n nhi~u thu~n IQi hon
nua so voi khi khach hang den cong ty, truoc het la vffn d~ thai gian va stf
rieng tu, bdi VI khi do khach hang khong c~n phai thong qua nhan vien cua
cong ty d~ nh~p nhung thong tin c~n thie't, Website se h6 trQ tfft ca nhung
di~u do, nghla la khach hang co th~ ttf mlnh lam tfft ca cac cong vi~c nhu
nh~p thong tin ca nhan, dang rao nha dfft, hi~u chlnh thong tin, tim kiem
thong tin ...D~ can nha co th~ dUQc rao tren trang Web cua cong ty, khach
hang c~n phai nQp mQt it phi quang cao, co hai cach nQp phi: sa dl;lng the

tin dl;lng va nQp trtfc tie'p tC;li1 dC;liIi g~n nhfft cua cong.ty, truang hQp d~u
se dUQc ap dl;lng d6i voi nhung khach hang co the tin dl;lng, khach hang
khong sa dl;lng the cling khong phai mfft nhi~u thai gian Him voi vi~c nQp
phi, ngay sau do thong tin nha dfft cua khach hang se dUQc dang tai tren
trang Web cua cong ty voi b6 Cl;lCdyp va sinh dQng. Nhu v~y co th~ nh~n
xet ding stf ti~n IQi va tiet ki~m da: dUQcnang len rfft nhi~u.

IV. Yeu cau d~ Uli
D~ tai yeu c~u : "Xay dtfng trang Web h6 trQ mua ban bfft dQng san
tren mC;lng"chinh la yeu c~u thtfc hi~n Website neu tren.



2 : Pha]l (fch, (hief ke' III 0 hinh h~ tholl

Tram! 3

I. Mo hloh xii If
1.1. DFD rnuc ngu canh
hieu chinh thong tin nha da't
hoa don

Duyet (quan trD: them, xoa sU'a, tlm kie'm thong

nop phi quang cao
thong tin nha da't cftn rao
hieu chinh thong tin ca nhan
ke't qUa tIm kie'm

du


H~ th6ng

••

ca

giao djch
bit dQng
san

thong tin khach hang
tim kie'm thong tin nha da't

?

ke't qua tIm kie'm
oi cau hoi hay tra Wi
cau tra Wi
hieu chinh ca u hoi

on
t:::

..s:::
..s:::

'C'::$

'C'::$


~

•....
•....

~

.s
•....

..c

on
..s:::
•....

,ro

u

U

t:::

t:::

..s:::
..s:::


,ro

<0

on

t::
•....•

..s:::

•....

"0

,C'::$

..s:::

t::
t::
.....•

•....
on
t::

<0

..s:::

•....

S

U

'
;:l

:.Q


:a

:-6

'
s

,•....
....•

S
':.Q

s

,•....
....•

'ro
;:l
0'

.....

'
~

-

.c

;:l

;:l

:'5
~

.~

'ro

l.•....•
;:l

'ro

I-<
•....

U

,C'::$

;>

.....•
'0

..s:::
;:l
U

.....•
on

..s:::

u

..c
t:

..c

u

u

;:l

:E

'-0

Khach hang co nhu cftu Mua - Thue


Chlidllg 2 : Phlill tich thiel rno hillh hf thOllg

Trallg 41

1.2. DFD muc 0

Hoa don

.g

~

8


:.;;;

~

Thong tin nha da't

8

(il)

:g

.~
u
,~

.~'61
:l

0'

..Ioi

Thong tin diu hoi va cau tnl
duvet cau hoi. trii Wi

Thong tin khach hang

8
....•
(il)

...I<:

8

~
.~

'.;:l

.~
:l

t:

;>,
0:1

:a00(0

t::

8

:.;;;

8

'0

.~
t:

~

8 :.;;;
'.;:l
8
~ '.:::l

:l
<0:1

:l
<~

"0
"0

'0

(il)

.

:l
0'

~

(il)

0

~
...

"5b.O
t::

(0

.:;;

~

..t::
t::

:au
..d

...I<:

....•

..t::


.~
:l
0'

~

'(il)

...I<:

u

b.O

t::
,~
..t::
..t::
U

'<':l

..t::
...I<:

~

~

..t::
t::

b.O

t::
,~
..t::
..t::
U
,~
..t::

u

~S
b.O

:l
(il).

...I<:

t::

(0

.:;;

(il)

...I<:
0'0:1
"0

....•
'0

..t::

;"8

b.O

:au ,5b.O
:a

~

~

t::

..t::

.5

..t::

0'

thon!! tin khach han!!

~
<~
"0

,~
..t::
t::
t::
'.;:l

b.O

t::

<0

.:;;
8


0,~
"0

....•

(0

..t::

:.;;;

8

'.;:l


2 : Phall tich thief kt 1110 hinh h? tholl

Trail

1.3. D FD mITe 1
1.3.1. DFD fine 1 ella Process 1

°

hic$u chinh tt khach hang

Khach hang Ban - Cho Thue

thong tin khach hang

hic$uchinh tt khach hang

thong tin khach hang

Khach co nhu du Mua - Thue

them t.tin khach hang

Thong tin khach hang
hieu chinh tt khach han!!

Qmln tri

xoa khach hang

5


thief kt III 0 hin h h? thOl1

Trail

1.3.2. DFD mnc 1 clla Process 2

hi~u chinh tt nhfl Mt

Khach hang Ban - Cho Thue

hi~u chinh tt nhfl Mt

thong tin nhfl Mt rao

xoa thong tin nhfl

Mt he't h~n

Thong tin nha da't

,.

6


Trail

1.3.3. DFD muc 1 ella Process 3
ke't qua tim kie'm

ke't qua tim kie'm

Quan tri
tIm kie'm thong tin haa ddn

tIm kie'm thong tin nha da't

ke'tqua
tim kie'm

s

ke'tqua
tim kie'm

<(1)

:.Q

S

''':::

tim
kie'm
t.tin
hoi

dap
ke't qua tim kie'm
tim kie'm uin nha da't

Khach hang Ban - Cho Thue

Khach co nhu cftu Mua - Thue

7


thief kt III 0 hinh h? (hOII

Trail

1.3.4. DFD mITc 1 clla Process 4
hi~u chinh diu hoi
hi~u chinh diu hoi

hi~u chinh diu hoi

Khach hang Ban-

Cho Thue

gdi hoi dap
diu tni Wi

cau tni loi

Thong tin hoi da p

diu tni Wi

xoa hoi dap

8


Trail

1.3.5. DFD muc 1 clla Process 5

Khach hang Ban - Cho Thue

nQp phi auang cao

h6a adn

_1_
duy~t ttin h6a adn

Quan tri

H6a adn

9


1.3.6. DFD

mne 1 ella Process 6

H6a don

Thong tin hoi dap

xem bao cao th5ng ke .

Thong tin khach hang

bao cao th5ng ke

Thong tin nha da't


Trail

II. Mo hloh thlic th~

11.1. ERD fine IUaD l:Y

Thanh pho'

Thong tin nha da't

Khach hang

H6a don

The tin dl;mg

Di~n dan

11


Chlldng 2 : Phan tich, thief kt III 0 hinh h? thOllg

Trang 12

11.1. ERD muc vat If

ThongTinNhaDat

HoaDon
TheTinDung

LoaiThe
MaSo

DienDan
CI] STT
Cha
SoCon
UserName
NgayGui
TuaDe
NoiDung
HoiDap

ThanhPho
~MaTP
TenTP

UserName
HTKinhDoanh
NhaHoacDat

NgayLapHD

CI] SoThe
UserName
NgayHetHan
TenTre'nThe

CI] MaNhaDat

CI] SoHoaDon

)

SoTienTT
TinhTrangTT
MaNhaDat
UserName
Hinh ThucThanh Toan

hachHang
CI] User Name
Password
HoTen
DiaChi
Email
DienThoai
MaCauHoiMK
CauTraLoiMK

Quan
CI] MaQu'iln
TenQuan
~aTP

ThongTin ThiTruong
GiaVangSJC
GiaDola

Admin
~userName
Password

MaQu~n '
DonVi
I
NgayBDRao
DiaChiNhaDat
TongDT
DTXayDung
Dai
Rong
Huong
TTPhapLy
NoHau
ThoiHanRao
GiaBan
GiaBanVND
GiaThue
GiaThueVND
LienHe
DacDiem
TenHinh
LenWeb
LoaiNha
LoaiDat


C/utdng 2: Phfin tfeh thief

ki 1110hinh hf

thol1g

Trang 13

II.3. Mo ta chi tie't bang:
Cac bang nay dUQc xay d\l'ng tren SQL Server 2000. Bao g6m co 9
bang: Quan, ThanhPho, ThongTinNhaDat,
KhachHang, TheTinDung,
DienDan, HoaDon, ThongTinThiTruong, Admin.

+ Chli thich:

*:

0'

Til' khoa clla bang
: Co th€ chua gia tri NULL

11.3.1 [KhachHangl
Lu'u tru thong tin account khach hang. Khi khach hang truy c~p
website batdongsan.com va dang ky m9t account thi thong tin chung clla
khach hang dUQc lu'u tru trong bang nay, khach hang co dung account nay
d€ tham gia rao ban - cho thue nha ho~c tham gia di~n dan. Khi m9t khach
hang bi xoa thi toan b9 thong tin rao hay nhung thong tin gdi len website
d~u bi xoa. Sau m9t thai gian ne'u account khong dUQC d\lng (nghla la
khach hang khong co thong tin rao hay tham gia di~n dan) thi nguai quann
tri se xoa account nay.

sa

~~YR~Jr[€i1;t'~lfN(~mf~~scription_0
-'0"

*

UserName
Password
HoTen
DiaChi
Email
DienThoai
MaCauHoiMK
CauTraLoiMK

[varcahar]
[varcahar]
[varcahar]
[varcahar]
[varcahar]
[varcahar]
[tinyint]
[varcahar]

__

..

~

20
100
200
50
50
50
1
500

0

.:;. '-:-~.~
_..•.

. ...

Li-_~

,."ii ••",

UserName clla thanh vien
M~t khffu clla thanh vien
HQ ten
Dia chi
Email
Di<%ntho~i
Mff s6 cau hoi m~t khffu
Ca u tra Wi m~ t khffu

11.3.2 [DienDanl

Dung lu'u tru cac cau hoi va cau tra Wi do khach hang gdi len
website. M9t cau hoi co th€ co nhi~u cau tra Wi. s6 cau tra Wi dltQCth€
hi~n trong bang nhu la s6 con va cha clla no chinh la cau hoi.


C/lltdng 2 : "han tich thiet

*

[int]
[int]
[tinyint]
[varcahar]
[smalldatetime]
[varcahar]
[text]
[bit]

STT
Cha
SoCon
UserName
NgayGui
TuaDe
NoiDung
HoiDap

kt "'0 hinh

hf tho/Ig

Trang 14

S6 thu tt! hoi dap
Ma s6 cau hoi cua cau tnllOi nay
S6 cau tnllOi
UserName nguoi gdi
Ngay gdi
Tl!a d~
NQi dung
Gdi email khi cau hoi du<;1ctnllOi
0- Khong gdi
1 - Gdi

4
4
1
20
4
200
16
1

11.3.3 [HoaDonl
Khi khach hang rao mQt thong tin thl se t(;lOra mQt hoa ddn. Hoa ddn
dung d~ xac nh~n vi~c giao dich. Ne'u thong tin rao rna khong co hoa ddn
thl xem nhu thong tin do bi 16i va nguoi quan tri co quy€n xoa thong tin
nay.

*

SoHoaDon
NgayLapHD
SoTienTT
TinhTrangTT

MaNhaDat
UserName
HinhThucThanhToan

[int]
[smalldatetime]
[money]
[bit]

4

[int]
[varchar]
[bit]

4

4

8
1

20

1

S6hoa ddn
Ngay l~p hoa ddn
S6 ti~n thanh toan
TInh tr(;lng thanh toan
o - Chua thanh toan
1 - Da thanh toan
Ma nha da't
Username nguoi rao
Hlnh thuc thanh toan
o - Thanh toan b~ng
the tin dl;lng
1 - Thanh toan trt!c
tie' t(;licong t


Clllldng 2 : P/zlin tiel, t/ziet kt 1110 /zin/z h~ t/zOllg

Trang 15

II.3.4 [Admin]
Dung d€ lttu thong tin account cua nguoi qmln trio Nguoi quan
tri dung account nay d€ login vao trang quan tri d€ di~u hanh ho~t
dQng cua site.
I

[varchar]
[varchar]

UserName
Password

20
200

II.3.5 [Quan]
Bang nay dung d€ chua thong tin v~ qu~n, huyt$n cua tfft ca cac
thanh ph6 trong nuoc. Ma qu~n chi t6n t~i khi co rna thanh pho.

MaQuan
TenQuan
MaTP

*

[smallint]
[varcahar]
[smallint]

2
35
2

Ma qu~n
Ten qu~n
Ma thanh

ho

II.3.6 [ThanhPhol
Dung d€ lu'u thong tin cac thanh ph6 trong nuoc.

MaTP
TenTP

*

1-

[smallint]
[varchar]

2
35

Ma thanh pho
Ten thanh ho

II.3.7 [ThongTinNhaDat}
Dung d€ lu'u thong tin nha dfft rna khach hang rao. Tu)' theo tung
truong hvoi tung truong htrong truong khong co field do thl se lu'u voi gia tri la -1.


Cluldng 2 : Phan ticlt thief kt 1110 hinh hf thOllg

UserName

[varchar]

20

HTKinhDoanh

[tinyint]

1

Trang 16

UserName

nguai rao

Hlnh thuc kinh doanh
0-

Ban

1 - Cho thue
2 - Ban va cho thue
3 - Cho thue mij t bang
4 - Cho thue phong trQ
NhaHoacDat

[bit]

Nha hoijc da't

1

0- Nha
1 - Da't
MaQuan

[smallint]

2

DonVi
NgayBDRao

[varchar]

20

[smallda tetime ]

4

[varchar]

200

TongDT

[real]

4

DTXayDung

[real]

4

Dai

[real]

4

[real]
[smallint]

4
2

[smallint]

2

DiaChiNhaDat

Rong
Huong
TTPhapLy

Mff qu~n
Don vi (USD, VND, SIC)

0

Ngay b~t dffu rao
Dia chi nha da't
T6ng di~n tich

0

Di~n tich xay dlfng
Chi~u dai
Chi~u rQng

0
0

Huang nha
Tlnh trC;lngphap ly

o-

Dff h<;lpthuc hoa

1- Chua h<;lpthuc hoa
[real]

4

[tinyint]

1
8

GiaBanVND

[money]
[mop.ey]

GiaThue
GiaThueVND

[money]
[money]

LienHe

[varchar]

8
100

DacDiem

[text]

16

TenHinh

[varchar]

50

LenWeb

[bit]

1

NoH au
ThoiHanRao
GiaBan

8
8

0

Nd h~u cua nha
Thai hC;lnrao

0
0
0
0

Gia ban
Gia ban d6i ra VND

Gia thue
Gia thue d6i ra VND
Cach lien h~ de'n nguoi ban

0
0

Dijc di~m n6i b~c cua nha da't
Ten hlnh
Thong tin du<;lcdua len web

o-

Chua len web
1 - Dff len web

LoaiNha

[smallint]

2

0

LOC;linha


Cllltdng 2 : Phan tiell thief kt 1110 hinh hf thol1g

Trang 17

o-

LoaiDat

[smallint]

2

Vitri

[smallint]

2

SoLanTruyCap
GhiChu

[smallint]
[text]

2
16

0

0

Nha chung cu
1 - Bi~t thV

2- Nha ph6
Loqi dfft
o - Dfft th6 cu
1 - Dfft nong nghi~p
Vi tri din nha
0- Nha m~t ti~n
1 - Hem chinh
2 - Hem phl;l
3 - Nha hai m~t ti~n
S6lfin truy c~p nha hay dfft
Ghi chd khac

II.3.8 [ThongTinThiTruongl
Dung lu'u thong tin thi truang nhu gia yang gia dola. Nhii'ng thong tin
nay se dUQc nguai qmln tri c~p nh~t thuang xuyen hang ngay. Cac thong
tin lu'u trong bang nay cling dUQc dung d~ chuy~n d6i ti~n trong bang
[ThongTinNhaDat] .

GiavangSJC
Giadola

[money]
[money]

Gia yang SJC
Gia USD

8
8

II.3.9 [TheTinDungl
Banng nay dung 100 tqm thai thong tin v~ the tin dl;lng clla khach
hang. Trong cd sd dii' li~u clla website khong lu'u thong tin v~ the tin dl;lng
clla khach nhAm bao m~t thong tin the tin dl;lng clla khach.

•

..

*

SoThe
UserName
NgayHetHan
TenTrenThe

I-

[varchar]
[varchar]
[smallda tetime ]
[varchar].

20
20
4

20

sO' the tin dl;lng

UserN arne nguai rao
Ngay he't hqn slr dl;lng the
Ten n uai tren the