Elements and Performance Criteria
- Verify the database model
- Verify that the 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 the game design requirements
- Verify that the entity relationships defined in the data model implement the game-design and game-play rules
- Verify the estimates of the amounts of data storage required, and the data types defined by the data model
- Document design inconsistencies
- Review the database model and address, and correct any inconsistencies
- Define the database test data
- Create the physical database design
- Implement the conceptual data model design as a physical database design
- Determine the default database file size, according to the data model storage estimates
- Determine game data input and output workload estimates
- Determine the reliability and performance requirements
- Define the minimum hardware requirements to support the input and output workload and reliability or performance requirements
- Configure the database management system in order to use minimum hardware requirements
- Refine and confirm the database test data
- Implement the physical database prototype
- Write structured query language (SQL) scripts to create physical database files according to the design requirements
- Write SQL scripts to create database tables
- Implement the primary key constraints
- Implement the 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