Database design/creation practice

Code No
Skill Category No: 
8
Skill No: 
1
Topic No: 
13
Level: 
II
  • Business analysis
    • Screening out entities
    • Creation of ERD
  • Design procedure of databases
    • Schema
    • Index
    • Distributed databases
  • Physical designs
  • Creation of tables
    • Restriction
    • Data loading
  • Items required in actual DB application developments
    • Procedures for the designs of business forms and screens
  • Performance
    • Data size and query plan
    • Improvement of index design
    • Monitoring of performance