Develop the database design models and diagrams which establish the structure of a database by using modelling software tools to be implemented in further processes.
create database models
create database blueprint
Skill reusability level
Relationships with occupations
Create database diagrams is an essential skill of the following occupations:
Data warehouse designer: Data warehouse designers are responsible for planning, connecting, designing, scheduling, and deploying data warehouse systems. They develop, monitor and maintain ETL processes, reporting applications and data warehouse design.
Database integrator: Database integrators perform integration among different databases. They maintain integration and ensure interoperability.
Database designer: Database designers specify the database’s logical structure, processes, and information flows. They design data models and databases to serve data acquisition.
Create database diagrams is optional for these occupations. This means knowing this skill may be an asset for career advancement if you are in one of these occupations.
ICT capacity planner: ICT capacity planners ensure that the capacity of ICT services and ICT infrastructure is able to deliver agreed service level targets in a cost effective and timely manner. They also consider all resources required to deliver the appropriate ICT service, and plan for short, medium, and long term business requirements.
Knowledge engineer: Knowledge engineers integrate structured knowledge into computer systems (knowledge bases) in order to solve complex problems normally requiring a high level of human expertise or artificial intelligence methods. They are also responsible for eliciting or extracting knowledge from information sources, maintaining this knowledge, and making it available to the organisation or users. To achieve this, they are aware of knowledge representation and maintenance techniques (rules, frames, semantic nets, ontologies) and use knowledge extraction techniques and tools. They can design and build expert or artificial intelligence systems that use this knowledge.
- Create database diagrams – ESCO