| Work Function: A. Analyze and Design Database |
| Key Activity: A1. Perform research and analyze requirements |
| | Comment |
| | | | |
| | Employability Skills |
| | | Ability to identify key sources of information. | Important |
| | | Ability to analyze information for accuracy and consistency. | Important |
| | | Ability to work cooperatively with others and contribute ideas, suggestions and assistance. | Important |
| | | Ability to ask relevant questions. | Important |
| | | Ability to accurately summarize and document information. | Important |
| | | Ability to resolve conflicts in available information and expressed needs. | Important |
| | Technical Knowledge |
| | | Knowledge of basic business objectives and requirements analysis. | Important |
| | | Knowledge of database software, design tools and design principles. | Important |
| Key Activity: A3. Create and refine conceptual and logical data models |
| | Comment |
| | | | |
| | Employability Skills |
| | | Ability to create, store and distribute documentation according to requirements. | Important |
| | | Ability to recognize and resolve conflicting specifications. | Somewhat Important |
| | | Ability to work cooperatively with others and contribute ideas, suggestions and assistance. | Important |
| | | Ability to ask relevant questions. | Important |
| | | Ability to accurately summarize and document information. | Important |
| | Technical Knowledge |
| | | Knowledge of data modeling and database software and tools. | Important |
| | | Ability to translate client/user requirements into data model. | Important |
| | | Ability to define attributes and align to entities. | Important |
| | | Ability to resolve discrepancies in different/multiple models. | Important |
| | | Ability to relate user specifications to data model. | Important |
| Key Activity: A4. Identify high-level business rules for data model |
| | Comment |
| | | | |
| | Employability Skills |
| | | Ability to synthesize information. | Important |
| | | Ability to create detailed supporting documentation. | Important |
| | | Ability to visually analyze relationship between parts/whole. | Important |
| | Technical Knowledge |
| | | Knowledge of business structure and processes. | Important |
| | | Knowledge of business entities and relationships. | Important |
| | | Knowledge of business policies and procedures. | Important |
| | | Knowledge of validation rules and data constraints. | Important |
| Key Activity: A5. Adapt conceptual and logical data models to enterprise model |
| | Comment |
| | | | |
| | Employability Skills |
| | | Ability to examine data for relevance and accuracy. | Important |
| | | Ability to pay attention to detail. | Important |
| | | Ability to analyze structure and organization of information. | Important |
| | | Ability to negotiate and resolve conflicts. | Important |
| | | Ability to present technical information clearly. | Important |
| | Technical Knowledge |
| | | Knowledge of company modeling policies and company development standards. | Somewhat Important |
| | | Ability to communicate modeling issues to a variety of audiences. | Important |
| | | Ability to visualize and integrate conceptual and logical model to conform with the enterprise model. | Important |
| | | Knowledge of database software and database modeling techniques. | Somewhat Important |
| Key Activity: A6. Validate conceptual and logical data models with clients |
| | Comment |
| | | | |
| | Employability Skills |
| | | Ability to understand and respond to client/user concerns. | Important |
| | | Ability to negotiate and resolve conflicts and compare multiple viewpoints. | Important |
| | | Ability to use word processing and database software. | Somewhat Important |
| | | Ability to examine data for relevance and accuracy. | Important |
| | Technical Knowledge |
| | | Knowledge of validation procedures and processes. | Important |
| | | Ability to recognize and resolve conflicts between models. | Important |
| | | Ability to read and understand process model. | Important |
| | | Ability to negotiate changes or modifications in models with a variety of audiences. | Important |
| | | Knowledge of database software, operating systems and the particular business or domain. | Somewhat Important |
| Work Function: B. Develop and Implement Database |
| Key Activity: B2. Create database objects |
| | Comment |
| | | | |
| | Employability Skills |
| | | Ability to attend to detail in checking model/database. | Important |
| | | Ability to clarify, interpret and influence communication. | Important |
| | | Ability to work with minimal supervision. | Important |
| | | Ability to identify and resolve conflicts in data and requirements. | Important |
| | Technical Knowledge |
| | | Knowledge of database object design and testing procedures. | Somewhat Important |
| | | Ability to relate database usability and user requirements to object design. | Important |
| | | Ability to present data and database tools in a user-friendly manner. | Important |
| | | Knowledge of user preferences and expertise levels. | Somewhat Important |
| Key Activity: B3. Select unique identifiers and normalize the data model |
| | Comment |
| | | | |
| | Employability Skills |
| | | Ability to organize data in a usable form. | Important |
| | | Ability to track information efficiently and effectively. | Important |
| | | Ability to use logic to draw conclusions from available information. | Important |
| | Technical Knowledge |
| | | Ability to transform conceptual model into logical model. | Somewhat Important |
| | | Ability to identify and define attributes and align attributes to entities. | Important |
| | | Knowledge of operating systems and database software and principles. | Somewhat Important |
| | | Ability to choose and document identifiers and relate identifier selection to business domain. | Important |
| | | Knowledge of normalization rules and processes. | Important |