????? 4 ?????????????????????? Database Management System - PowerPoint PPT Presentation

1 / 12
About This Presentation
Title:

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

Description:

4 Database Management System .490 ... – PowerPoint PPT presentation

Number of Views:57
Avg rating:3.0/5.0
Slides: 13
Provided by: acth
Category:

less

Transcript and Presenter's Notes

Title: ????? 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
??????????????????????
Write a Comment
User Comments (0)
About PowerShow.com