Activity:
Database Development

Description:
Define, analyze and implement data requirements needed to support the business processes within the scope of corresponding information systems.

Scope:

  • Logical Database Design
  • Entity-Relationship Models (ER Diagrams)
  • Physical Database Implementation

Components:

  • Database Model
    • Schema Structure
    • Normalization
    • Tables
    • Views
    • Table Columns and Data Types
    • Default Values
    • Applicability of NULL values
  • Data Integrity
    • Referential (PK/FK)
    • Constraints
    • Rules
    • Checks
  • Transact-SQL (T-SQL)
    • Transactions
    • Stored Procedures
    • Functions
    • Triggers
    • Error Handling
    • XML
  • Performance Tuning
    • Indexes
    • Statistics
    • Query Plans
    • Concurrency (Locking Management)