Elements and Performance Criteria
- Verify database model
- Verify that game architecture and system implementation requirements have been addressed by the proposed database architecture
- Correlate data model entities and their attributes with the game artefacts and game design requirements
- Verify that entity relationships defined in the data model implement game design and game-play rules
- Verify estimates of amounts of data storage required and data types defined by the data model
- Document design inconsistencies
- Review database model and address and correct inconsistencies
- Define database test data
- Create physical database design
- Implement conceptual data model design as a physical database design
- Determine default database file size according to the data model storage estimates
- Determine game data input and output workload estimates
- Determine reliability and performance requirements
- Define minimum hardware requirements to support input and output workload and reliability or performance requirements
- Configure the database management system to use minimum hardware requirements
- Refine and confirm database test data
- Implement physical database prototype
- Write structured query language (SQL) scripts to create physical database files according to design requirements
- Write SQL scripts to create database tables
- Implement primary key constraints
- Implement foreign key constraints
- Define and script stored procedures for selecting, inserting, updating and deleting data
- Define and script Insert statements for test data
- Execute SQL scripts and database, including test data
- Test the database and document results
- Review, evaluate and correct database performance