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)