THệẽC HAỉNH POWER DESIGNER
1. Thieỏt keỏ moõ hỡnh CDM nhử sau:
s_emp_dept_id_fk
0,n
1,1
s_dept_region_id_fk
1,n1,1
s_month_emp_id_fk
0,n
0,1
s_per_emp_id_fk
0,n
1,1
s_user_emp_id_fk
1,1
1,1
s_year_emp_id_fk
0,n
0,1
s_date_emp_id_fk
0,n
1,1
s_lang_emp_id_fk
0,n
1,1
s_degree_emp_id_fk
0,n
1,1
s_reward_emp_id_fk
0,n
1,1

religion
comments
type_emp
resident_home
resident_district
resident_city
resident_tel
tempo_home
tempo_district
tempo_city
tempo_tel
mobile_phone
id_no
id_place
passport_no
passport_date
passport_place
social_insurance_no
social_insurance_date
health_insurance_no
health_insurance_date
personal _income_tax
N7
VA5
VA5
DT
VA25
VA25
VA30
DT

N3,2
s_month
id_month
cur_month
total_hours
over_hours
total_per
sal_month
N7
N6
N3
N3
N2
N7
s_permission
id_per
begin_date
end_date
full_half
reason
N7
DT
DT
N1
N7
s_user
username
pwd
attr
allow

place
date_of_issue
N7
VA30
VA20
VA80
DT
s_degree
id_degree
spec
spec_level
place
from_day
to_day
N7
VA30
VA20
VA80
DT
DT
s_reward
id_reward
style
content
grade
r_date
record_no
sign_id
N7
VA30

N4
VA25
s_time
begin_ti me N3,1
s_salary
id_sal
sal_level
sal
N4
N2
N7
2. Phaùt sinh moâ hình PDM
3. Phaùt sinh file Script hay taïo môùi 1 CSDL SQL Server
4. Tạo report