Systems Development Life Cycle

1
??????????????????????
????????? ???????? ?????????
2
Systems Development Life Cycle
3
??????????????????? (SDLC)System Development
Life Cycle

• ????????? (planning)
• ???????????????? (analysis)
• ?????????????????????????? (detailed systems
  design)
• ???????????? (implementation)
• Coding Testing Installation fine-tuning
• ????????????????? (Maintenance)
• Evaluate, Maintenance and Enhance

4
Database Lifecycle (DBLC)
Figure 6.3
5
??????????????????? (DBLC)

• ?????????????????
• ??????????????????
• ??????????????
• ????????????????????
• ????????????
• ????????????????????????

6
??????? 1 ??????????????
7
??????? 2 ??????????????????

• Database Design

8
?????????????????????????

• ??????????????????? (Conceptual Design)
• ??????????????????????????????????
• (DBMS Software Selection)
• ????????????????? (Logical Design)
• ?????????????????? (Physical Design)

9
???????????????????

• ??????????????????????????????????????????????????
  ??????????????????????????????????????????????????
  ?????? (Conceptual Schema) ?????????????
• ????????
• ?????????????????????
• ???????????

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

• ??????????????????????????????????????????????????
  ?????????????????
• ???????????????????????-???? (E-R Model)
• ?????????????????
• ???????????????????????????
• ??????????????????????????????????????????????????
  ???????????????
• ????????????????????????
• ??????????????????????????????????????????????????
  ??????
• ????????????????????

11
Entity Relationship Modeling and Normalization
Table 6.2
12
E-R Modeling is Iterative
Figure 6.8
13
Concept Design Tools and Sources
Figure 6.9
14
??????????????????????????????????
15
???????? DBMS ????????????

• ??????????
• ???????????????????
• ????????? ?????????? ??????????
• ?????????
• ??????????????????????????????
• ????????????????????????? DBMS
• ????????????????????????? Platform ???????
• ??????????????????????????? DBMS

16
???????????????????????????

• (Logical Database Design)

17
??????????????????????????????

• ??????????????????????????????? (Conceptual
  Design) ???????????????????????????????????????
  (Internal Model) ?????????????????????????????????
  ??????????????????? ???? DB2, PostgreSql, Oracle,
  Mysql ???????
• ??????????????????????????????????????????????????
  ?????????? (Normalization) ??? Denormalization
  ????????????????????????????????????

18
??????????????????? (???)

• ????????????????????? ????????????????????????????
  ???
• Tables
• Indexes
• Views
• Transactions
• Access authorities
• Others

19
?????????????????????????????

• Physical Design

20
???????????????????????????????

• ??????????????????????????????????????????
  (Storage) ???
• ???????????????????? (Access Method)
  ????????????????????? ??????
• ??????????????????????????????????????????????

21
???????????????????????????????

• ?????????????????????
• Transaction Analysis
• File Organization
• Access Method
• Estimate Diskspace
• Create Relation and Integrity Constraint
• Database Security System

22
Physical Organization