Scope:
- Tools and techniques for efficient data modeling, collection,
organization, retrieval, and management. - How to extract information from data to make data meaningful to
the organization. - How to develop, deploy, manage and integrate data and
information systems to support the organization. - Safety and security issues associated with data and information.
- Tools and techniques for producing useful knowledge from
information.
Competencies:
- Express how the growth of the internet and demands for
information have changed data handling and transactional and
analytical processing, and led to the creation of special purpose
databases. (Requirements) - Design and implement a physical model based on appropriate
organization rules for a given scenario including the impact of
normalization and indexes. (Requirements and development) - Create working SQL statements for simple and intermediate
queries to create and modify data and database objects to store,
manipulate and analyze enterprise data. (Testing and
performance) - Analyze ways data fragmentation, replication, and allocation
affect database performance in an enterprise environment.
(Integration and evaluation) - Perform major database administration tasks such as create and
manage database users, roles and privileges, backup, and restore
database objects to ensure organizational efficiency, continuity,
and information security. (Testing and performance)
Subdomains and Core Hour allocation
| Subdomain | Level |
| ITE-IMA-01 Perspectives and impact | 1 |
| ITE-IMA-02 Data-information concepts | 2 |
| ITE-IMA-03 Data modeling | 3 |
| ITE-IMA-04 Database query languages | 3 |
| ITE-IMA-05 Data organization architecture | 3 |
| ITE-IMA-06 Special-purpose databases | 1 |
| ITE-IMA-07 Managing the database environment | 2 |
Suggestions Accepted for consideration for the next Edition:
Please provide your suggestions about this knowledge unit. All submitted comments will be reviewed at the end of the month. Comments accepted for inclusion will be listed above.