Made with
ConceptDraw
DIAGRAM 16

Data modeling with ConceptDraw DIAGRAM

One of the most difficult and important problems at software and data base projection is the definition of the requirements to the result. The more time is spent and the more attention is paid to the projecting software or data base, the simpler is the projection and the more qualitative is the result. The most frequently for definition of the requirements the method of data modelling is used.

In the given case data modelling presents the process of creation of data model in the convenient and comprehensible graphic form. In the process of model creation data is structured and organized with the usage of one of the methods, such as IDEF or ERD.

A creation of the model consists in collection of data which will be used in the projecting data base in the capacity of entities and other data base objects, in the definition of behavior rules of data in the system and operators which address to data in data base.

The model of data describes the structure of data in the given area. It contains the information about the classes of entities (for which the information is needed), attributes of this information and connections (including implicit) between entities and attributes of entities.

Entities are the objects of business-processes, real or virtual about which the information is collected and which are described in the model of data. For instance, entities can be all people having relation to the work of an enterprise. In their turn these entities are divided into classes. For example: “Clients”, “Suppliers”, Workers”. Each of the classes can be divided into subclasses by the given attributes. Classes are named with words of usual non technical language as well as connections between classes.

After the entity determination it is described with some definitions which are the attributes of the entity. Attributes must identify the entity, classify and appraise it qualitatively and quantitatively. Attributes can be obligatory and optional. For the entity “Worker” these can be individual data (name, age, and address), professional data (education, qualification, position) and so on. Attributes which originally define the entity are called primary.

After the definition of entities and their attributes in the model of data connections between entities and the type of these connections are defined. Connections can be unidirectional and bidirectional. Also the types of connections are distinguished: “one to one”, “one to many” or ”many to many”. Connections are called with verbal names. For example, between the entity “Worker” and entity ”department” there is a unidirectional connection of the type “One to one”. “Worker” works in the ”Department”. If consider the class of entities “Worker” the connection of this class with the entity “Department” will be of the type “one to many”.

The model of data describes semantics of data i.e. the set of confirmations about data which are used in the project.

The model of data can be presented in one of three forms:

  • Conceptual scheme- the description of semantics of data organization (entities classes and connections between these classes)
  • Logic scheme- description of data (tables, object oriented classes)
  • Physical scheme- description of physical environment of data keeping and processing

The more commonly used technologies of creation of such schemes are ERD (Entity Relationship Diagram) and some of IDEF standards (IDEF1, IDEF1x). Also for creation of schemes or diagrams which describe models of data it is possible to use special software such as ConceptDraw, where ready objects for creation of such diagrams exist. This lets you facilitate and accelerate the process of creation of such schemes and diagrams, creating diagrams which will be easy edited in the projection process.

Data modelling will help you to study and analyze business processes in your organization for optimization and increase of effectiveness and production.

Data modeling with ConceptDraw DIAGRAM  *

TEN RELATED HOW TO's:

Entity Relationship Diagram - ERD - Software for Design Chen ER Diagrams →

The Entity-Relationship Diagram (ERD) solution from ConceptDraw Solution Park extends ConceptDraw DIAGRAM vector graphics and diagramming software with the ability to describe a database using the Entity-Relationship (Chen) model. Use it for design your ERDs and verify that ConceptDraw DIAGRAM offers the best ERD diagrams software tools for design element Chen notation.Entity Relationship Diagram - ERD - Software for Design  <br>Chen ER Diagrams *
Picture: Entity Relationship Diagram - ERD - Software for Design Chen ER Diagrams
Related Solution:

Entity-Relationship Diagram (ERD) with ConceptDraw DIAGRAM  →

Database structures are usually described by ER-diagrams which represents entities as boxes with lines-connections between them. You can create any entity-relationship diagram (ERD) by means of ConceptDraw DIAGRAM using ready-to-use templates and special libraries containing all the needed symbols and shapes. Creating a model for your database from now on can take just a few minutes. ERD (entity relationship diagram) designed to show the logical structure of databases. It intended to depict the relationships between data components (entities). ERDs are a popular tool for software engineers and architects. Using ERD they can manage the every aspect of database design. Also ERD can be used as guidelines for testing and communications before software release. This diagram represents the file reference system of the WordPress web platform. Because entity relationship diagrams have such a broad application area through the prevalence of database technology, it can be applied for a wide range of users.Entity-Relationship Diagram (ERD) <br>with ConceptDraw DIAGRAM  *
Picture: Entity-Relationship Diagram (ERD) with ConceptDraw DIAGRAM
Related Solution:

Activity Network (PERT) Chart →

Activity Network and Project Evaluation and Review Technique, or PERT, charts are a way of documenting and analyzing the tasks in a project. This diagram is constructed as part of the process in creating a schedule of corrective actions. The Activity Network Chart (PERT) shows the logical connections and consequence of tasks to be performed. It displays the time period for problem solving and the implementation of all activities through the critical path.Activity Network (PERT) Chart *
Picture: Activity Network (PERT) Chart
Related Solution:

Network Topologies →

When describing any computer network, we imagine a set of devices and nodes, arranged in some way. Talking about network structures, we should distinguish physical and logical network topologies, as physical topology is about devices location and logical topology illustrates data flow. In the same time, they do not have to match, and some devices, such as repeaters, may have a physical star layout, but a bus logical topology. There are two main types of computer network topologies: Physical topology that show the physical organization of a network - equipment and types of connections. Star network topology involves a set of devices that is connected to a single hub (router). Ring network topology means that, devices connected according this topology have two connections, connecting with nearby devices to make a loop. Bus network topology is the topology presented at the current diagram. It is similar to a ring topology. The difference is that data moves up and down a linear connection, copying itself where network equipment works as bus-stations along the way. This network topology can be used for small network, or when adding an extra device into a network.Network Topologies
Picture: Network Topologies
Related Solution:

Network Glossary Definition →

When talking about engineering, one should define all the terms used, so anybody could understand the topic. Typical network glossary contains definitions of numerous network appliances, types of networks and cable systems. The understanding of basic is crucial for server management, network administration and investigating problems. The network glossary defines terms related to networking and communications. The most of glossary items has their visual representation in ConceptDraw DIAGRAM libraries of the Computer Network Diagrams solution. This illustration presents a local area network (LAN) diagram. It designed to show the way the interaction of network devices in a local network. The diagram uses a library containing symbols of network equipment, connections and the end-point devices such as network printer, hubs, server, modem and finally computers (PC, mac, laptop). This diagram depicts a physical LAN topology.Network Glossary Definition *
Picture: Network Glossary Definition
Related Solution:

Business Processes description with ConceptDraw DIAGRAM  →

Business Processes description with ConceptDraw. Business-processes it allows to describe functional blocks, for example production and marketing. ConceptDraw lets creation of business processes description using IDEF0 and IDEF2 methods.Business Processes description with ConceptDraw DIAGRAM  *
Picture: Business Processes description with ConceptDraw DIAGRAM
Related Solution:
ConceptDraw
DIAGRAM 16