????? 4 ?????????????????????? Database Management System

1
????? 4??????????????????????Database
Management System

• ??????? ??.490 ???????????????????????????????????
  ?????
• ???????? ??????????????????????????????
  ??????????????? ????????????????

2
???????????????????????????????????
3
?????????????????????????????????????????????

• ???????????????????? (Recruitment data)
• ????????????????? (Personnel data)

• ?????????????????????? (Payroll data)

• ??????????????????????????????? (Human
  Resource Development data)

• ??????????????????????????????????
  ????????????????? (Staff Appraisal data)

• ???????????????????????????????????????
  (Time Card Registration data)

• ????????????????????????
  (Intranet/Intranet for Personnel Communication)

4
???????????????????????????????????
5
???????????????????

• ???????????????? ??????????????????????????
  (Relational Data)
• ?????????? Key Field (Primary Key)
  ??????????????????????????????? ???? ???????????
  ?????????? ??????? ???????
• ??????????????????????????????????????????????????
  ??????????????????????????????????????????????????
  ????????????
• ??????????????????????????????????????????????????
  ???????????? ???? SQL ???????

6
??????????????????? (File type)

• Master File
• Transaction File

• Document File

• Archival File

• Table Look Up File

• Audit File

7
??????????????????????? (File organization)

• ????????????????????????????? (Sequential File)
• ???????????????????????????????????? (random or
  direct File)
• ????????????????????????????????? (Indexed
  Sequential)

8
?????????????????? (Database management)

• ?????????????????????? (Data Base Management
  System) ???? DBMS

• ???????????????????????????????????
• ???????????????????? Data Definition Language
  (DDL)
• ??????????????????? Data Manipulation Language
  (DML)
• ??????????????? (Data dictionary)

9
?????????????????? (Database management) (???)

• ???????????????????????????????????
• ???????????????????? Data Definition Language
  (DDL)
• ??????????????????? Data Manipulation Language
  (DML)
• ??????????????? (Data dictionary)

10
????????????

• ????????????????? (Batch processing)
• ???????????????????? (Interactive)
• ????????????????????? (Online processing)

11
??????????????????

• ???????????????????????????????? (Conceptual
  Database Design)
• ?????????????????????????????? (Logical Database
  Design)
• ??????????????????????????????? (Physical
  Database Design)

12
??????????????????????