Elements and Performance Criteria
- Determine database requirements
- Develop logical data model
- Design data structures
- Confirm primary and foreign keys for tables
- Review client business rules
- Identify referential integrity constraints
- Establish database-management system constraints and incorporate into database design
- Develop validation rules for data
- Design indexes and develop data dictionary
- Document the database design
- Design queries, screens and reports
- Design access and security systems
- Confirm database design