Elements and Performance Criteria
- Determine database requirements
- Meet with the client, and conduct a user-needs analysis, to determine database functionality
- Analyse the results of a user-needs analysis to identify technical requirements
- Develop a conceptual model of the database
- Submit the conceptual model to the client for review
- Evaluate client feedback and make changes as required
- Develop a logical data model
- Design the data structures
- Confirm primary and foreign keys for tables
- Review client business rules
- Identify the referential integrity constraints
- Establish database management system constraints and incorporate into database design
- Develop the validation rules for data
- Design indexes and develop the data dictionary
- Document the database design
- Design queries, screens and reports
- Design access and security systems
- Confirm the database design