Data modeling with ConceptDraw PRO

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.



TEN RELATED HOW TO's:

UML Notation

There are many ways to track the system in a critical situation. To model a system behavior, uml notation is widely used. Usually, an UML diagram consists of elements such as actor and a case. This diagram represents the structure of UML notations. Unified Modeling Language (UML) is used in software engineering to depict graphically the software modeling process. UM Language uses graphic notations for developing models of object-oriented systems. These notations displays requirements, sub-systems, logical and physical elements, etc. We created this diagram using ConceptDraw PRO reinforced with Rapid UML solution. It can be helpful for students on software engineering, when learning UML.uml diagram types list
Picture: UML Notation
Related Solution:

Data Modeling with Entity Relationship Diagram

Data modeling is actively applied in analysis and uses wide set of methods for description the data requirements in a system. One of the most popular and well-known is the ERD method of database modeling. The best ERD tool for the Mac and Windows is ConceptDraw PRO software extended with the Entity-Relationship Diagram (ERD) solution from the Software Development Area for ConceptDraw Solution Park, which is sharpened for professional ERD drawing and data modeling with Entity Relationship Diagram.Data Modeling with Entity Relationship Diagram
Picture: Data Modeling with Entity Relationship Diagram
Related Solution:

Data Modeling Diagram

The vector stencils library Activity diagrams from the solution Rapid UML contains specific data modeling symbols for ConceptDraw PRO diagramming and vector drawing software. The Rapid UML solution is contained in the Software Development area of ConceptDraw Solution Park.Data Modeling SysML Activity Diagram
Picture: Data Modeling Diagram

UML Diagram

While developing software, it is very important to have a visual model, because it helps to represent the logic and the architecture of an application. Experienced engineers use UML diagrams to denote relationships between classes and their instances. UML is a general language for a set of diagrams like deployment diagrams, object diagrams or use case diagrams. This diagram represents UML class diagram used for a software system development using an object-oriented method. Class diagrams are categorized as static structure diagrams that depict the physical structure of a system. Class diagram divides a software system's structure into "classes". Classes are defined by the methods and variables of objects. UML Class diagram is used to depict relationships and source code dependencies between objects.UML Diagrams
Picture: UML Diagram
Related Solution:

ERD Symbols and Meanings

A database is a data collection, structured into some conceptual model. Two most common approaches of developing data models are UML diagrams and ER-model diagrams. There are several notations of entity-relationship diagram symbols and their meaning is slightly different. Crow’s Foot notation is quite descriptive and easy to understand, meanwhile, the Chen notation is great for conceptual modeling. An entity relationship diagrams look very simple to a flowcharts. The main difference is the symbols provided by specific ERD notations. There are several models applied in entity-relationship diagrams: conceptual, logical and physical. Creating an entity relationship diagram requires using a specific notation. There are five main components of common ERD notations: Entities, Actions, Attributes, Cardinality and Connections. The two of notations most widely used for creating ERD are Chen notation and Crow foot notation. By the way, the Crow foot notation originates from the Chen notation - it is an adapted version of the Chen notation.Entity Relationship Diagram Symbols and Meaning - crow
Picture: ERD Symbols and Meanings
Related Solution:

IDEF1 standard

Use Case Diagrams technology. Using visual graphical objects IDEF1 standard allows to model information interrelations.IDEF1 standard diagram example
Picture: IDEF1 standard

Express-G Diagram

The vector stencils library from the solution Information Model Diagrams contains specific data type symbols of the EXPRESS-G notation such as entity data type symbols, simple data type symbols, enumeration data type symbols, defined data type symbols, select data type symbols and specific attribute symbols for ConceptDraw PRO diagramming and vector drawing software. The Information Model Diagrams solution is contained in the Software Development area of ConceptDraw Solution Park.Express-G Diagram - Family Scheme
Picture: Express-G Diagram

Diagramming Software for UML Composite Structure Diagrams

UML Composite Structure Diagram shows the internal structure of a class and the possible interactions at this structure.uml composite structure diagram for mac
Picture: Diagramming Software for UML Composite Structure Diagrams

IDEF1X Standard

Use Case Diagrams technology. IDEF1x standard - for work with relational data bases. IDEF1x standard is meant for constructing of conceptual schemes which represent the structure of data in the context of the concerned system, for example, a commercial organization.IDEF1x standard diagram example
Picture: IDEF1X Standard

Cubetto Flowchart

Create flowcharts in a breath with Cubetto Flow on your iPad and iPhone wherever you are.cubetto flowchart
Picture: Cubetto Flowchart
1 Diagram Software
Professional business graphics tool for drawing schemes, diagrams and illustrating business documentation
1 Mind Map Software
Excellent tool for Mind Mapping, Planning, Brainstorming, and Building Processes
1 Project Management Software
The full complement of features needed to successfully plan and execute projects, including task and resource management, reporting, and change control