Bài giảng Thương mại điện tử - Lecture 8: Thiết kế Data Model - Web thương mại điện tử - Đào Nam Anh

1 
Thƣơng mại điện tử 
Lecture 8: 
THIẾT KẾ Data Model - WEB TMDT 
TS Đào Nam Anh 
Đại học Điện lực, Khoa CNTT 
2 
Tài liệu 
 Frontiers of Electronic Commerce, Ravi 
Kalakota, and Andrew B. Whinston 
 E-commerce applications, Luisa Calcagno 
 KIẾN THỨC THƢƠNG MẠI ĐIỆN TỬ, TS. 
Nguyễn Đăng Hậu 
 GIÁO TRÌNH THƢƠNG MẠI ĐIỆN TỬ 
DÀNH CHO DOANH NGHIỆP, Ths Dƣơng 
Tố Dung 
3 
Nội dung 
1. Thiết kế dự án web - Project Design 
2. Mô hình dữ liệu Data Model 
3. Entity-Relation Diagram (ERD). 
4. Mô hình qui trình - Process Model 
5. Functional Decomposition Diagram 
4 
In order to design a web site, the 
relational database must be 
designed first. 
Conceptual design can be divided into 
two parts: The data model and the 
process model. 
1. Project Design 
5 
The data model focuses on what data should be 
stored in the database while the process 
model deals with how the data is processed. 
To put this in the context of the relational 
database, the data model is used to design the 
relational tables. 
The process model is used to design the queries 
that will access and perform operations on 
those tables. 
1. Project Design 
6 
A data model is a conceptual representation 
of the data structures that are required 
by a database. The first step in 
designing a database is to develop an 
Entity-Relation Diagram (ERD). 
The ERD serves as a blue print from which 
a relational database maybe deduced. 
2. Data Model 
7 
1. Data Model 
8 
2. Data Model 
9 
2. Data Model 
10 
2. Data Model 
11 
2. Data Model 
12 
2. Data Model 
13 
2. Data Model 
14 
3. Process Model 
A Process Model tells us about how 
the data is processed and how the 
data flows from one table to another 
to gather the required information. 
This model consists of the Functional 
Decomposition Diagram and Data 
Flow Diagram. 
15 
3. Functional Decomposition Diagram 
A decomposition diagram shows a top-
down functional decomposition of a 
system and exposes the system's 
structure. The objective of the 
Functional Decomposition is to break 
down a system step by step, beginning 
with the main function of a system and 
continuing with the interim levels down 
to the level of elementary functions. 
16 
3. Functional Decomposition Diagram 
17 
Bài Tập Nhóm 
Chuẩn bị phần “Thiết kế dự án web – 
Data model” cho Đề tài TMDT của 
nhóm.