Made with
ConceptDraw
DIAGRAM 15

Database Design

Being engaged in the database design, you can always find the ConceptDraw DIAGRAM diagramming and drawing software a very useful tool for making the database design related drawings, such as an architecture framework, having the examples as well as the stencil libraries from the IDEF Business Process Diagrams solution downloaded from another product of CS Odessa — the ConceptDraw STORE application.

Database Design *

Example 1. Database Design in ConceptDraw DIAGRAM

Database design itself is known to be the process of producing some detailed data model of some particular database, which should contain all the needed physical as well as logical design choices and all the needed physical storage parameters for being able to generate some definite design in a data definition language, that can be used in order to create a database after. Any fully attributed data model is expected to be containing the detailed attributes for each of the existing entities.

The term “database design” itself can be also used for describing lots of different parts of the design of some database system. Any database design can be also called a logical design of some base data structures, which are used for storage of the data, such as the views and the tables in the relational model. At the same time, the relationships as well as the entities in some object database can map directly to the named relationships and the object classes with no intermediation.

The term of “database design” can also be used for applying to the process of designing, not only the base data structures, but also the queries and the forms that are used as part of the database application within some particular database management system. The process of designing the database design usually consists of a few steps which will can be carried out by the database designer, who has to, first of all, determine the data which is to be stored in the database, determine the relationships between lots of different data elements and to superimpose a logical structure on the data, based on the mentioned relationships.

Architecture Framework — IDEF0 Activity Diagram

Example 2. Architecture Framework — IDEF0 Activity Diagram

The final step mentioned above can be broken down into 2 further steps within any relational model: determining the grouping of information within the given system by determining what exactly the basic objects are about which that information is being stored, and determining the relationships between the described groups of objects or information, which is never as necessary within one type of databases — an Object one.

In most of the cases, that person who is responsible for the design of some database is that person who has the necessary expertise in the area of database design, but he may have not as much of it in the domain from which the data is about to be stored, such as biological information or financial information. Thus, any data which is expected to be stored in the database, has to be determined in co-operation with a person who has enough expertise in that particular domain, being aware of what data should be stored within the system.

The mentioned process is the one, which can be usually considered as a part of the requirements analysis, requiring skill on the part of the database designer for eliciting the necessary information from those who have enough domain knowledge, as such people cannot express what their system requirements for the database are in a clear way, being unaccustomed to thinking in terms of the discrete data elements that must be stored. All the data to be stored can be always determined by the so-called “Requirement Specification”.

As long as a database designer knows about the data which has to be stored in the database, he must determine where the dependency is within the mentioned data. In case data is changed, then he can change other data which is invisible. In a list of addresses and names, for instance, assuming a situation where different people can have the same address, but one of them cannot have more than one address, the address is known to be dependent on the name. Once the name is provided, then the address can be determined. The inverse situation cannot happen, though, because many different people can reside at the same address. But once an address can be determined by a name, then it can be considered as the one dependent on a name.

Once the dependencies and the relationships between different pieces of information are determined, then it becomes possible to arrange any data into some logical structure which can always be mapped into the storage objects after, being supported by the database management system. In any Object database the storage objects are known to be corresponding directly to the objects, which are used by the Object-oriented programming language. The described language is usually used for writing the applications that will access and manage the data. Any relationships can be always defined as the attributes of the object classes, which are involved. They also can be defined as methods which operate on the object classes.

The way the mentioned mapping is usually performed is such that each of the sets of the related data which depends on a single object, whether it is abstract or actually real, is placed in one of the tables. The relationships between the dependent objects can after be stored as links between different objects. Each of the tables can represent some implementation of either a relationship joining one or more than one instances of a few logical objects or one single logical object. All the relationships between the existing tables can always be stored as links, which are connecting child tables with their parents. As the complex logical relationships are tables, they can have links to more than only one parent.

Example 3. Libraries of Database Design

Having an IDEF Business Process Diagrams solution, which is available for all the ConceptDraw DIAGRAM users means having all the necessary tools, such as the design symbols and the pre-made examples of the needed drawings which all can be used as the base for some other ones. The stencil libraries of the mentioned solution are full of the design elements, representing such terms as “Call and Continue Referent” (referent type/label in Locator), “Call and Wait Referent” (referent type/label in Locator), “Note” (Note ID), “UOB symbols” (unit behaviour - UOB labels), Junctions: AND junction (process), OR junction (process), Synchronous AND junction, Synchronous OR junction, XOR junction; and Links: Single precedence link, etc.






TEN RELATED HOW TO's:

Technical Drawing Software →

Every engineering project starts from a terms of reference document. The next stage of developing is a technical drawing, which requires using appropriate software. However, revisions and discussions about requirements are possible at any stage of development. This technical drawing demonstrates a schematic flow diagram of pulp reclaiming. This diagram of magnetite pulp reclaiming is created using ConceptDraw Chemical and Process engineering solution, The solution delivers more than 460 vector graphic icons and connectors. Generally, it is intended for designing process and instrumentation diagrams (P&ID) for chemical and process engineering. block flow diagrams (BFD), process flow diagrams (PFD) for chemical industry.Technical Drawing Software *
Picture: Technical Drawing Software
Related Solution:

Example of Flowchart Diagram →

ConceptDraw - feature-rich flowchart software. This software includes flowchart diagram examples set. Libraries contain vector stencils that allow users to use RapidDraw technology. Users can start draw their own flowchart diagrams from existing examples by clicking on direction arrows.Example of Flowchart Diagram *
Picture: Example of Flowchart Diagram
Related Solution:

Flowchart design. Flowchart symbols, shapes, stencils and icons →

When thinking about data visualization, one of the first tools that comes to mind is a flowchart design. You can find flowchart symbols, shapes, stencils and icons easily on the Internet, but it might take time to systematize this information. Nevertheless, once you start flowcharting, you’ll love its simplicity and efficiency. This diagram consists from standard flowchart symbols, approved by ANSI (American National Standard Institute) for drawing flowcharts. A flowchart is a diagram that represents a step-by-step algorithm of any process, displaying the process stages as boxes that are connected with arrows. Flowchart design makes it clear and readable. Flowchart designed using ConceptDraw DIAGRAM flowchart software allows to make attractive and clear process presentation, it makes interpretation of the business process flow fresh and versatile. Great flowchart design view is a big advantage over the diagram created manually on a paper.Flowchart design
Picture: Flowchart design. Flowchart symbols, shapes, stencils and icons
Related Solution:

How To use House Electrical Plan Software →

Electrical plan is a document that is developed during the first stage of the building design. This scheme is composed of conventional images or symbols of components that operate by means of electric energy. To simplify the creation of these schemes you can use house electrical plan software, which will not require a long additional training to understand how to use it. You only need to install the necessary software ant it’s libraries and you’ll have one less problem during the building projection. Any building contains a number of electrical systems, including switches, fixtures, outlets and other lightening equipment. All these should be depicted in a building electrical plans and included to general building documentation. This home electrical plan displays electrical and telecommunication devices placed to a home floor plan. On the plan, each electrical device is referenced with the proper symbol. Electrical symbols are used for universal recognition of the building plan by different persons who will be working on the construction. Not all possible electric symbols used on a certain plan, so the symbols used in the current home plan are included to a legend. The electrical home plan may be added as a separate document to a complete set of building plans.House Electrical Plan Software
Picture: How To use House Electrical Plan Software
Related Solution:

Concept Map →

A concept map is a way of representing relationships between ideas, images, or words. How to draw a Concept Map quick, easy and effective? ConceptDraw DIAGRAM offers the unique Concept Maps Solution from the "Diagrams" Area that will help you!Concept Map *
Picture: Concept Map
Related Solution:

Entity Relationship Diagram Examples →

An abstract representation is usually the first thing you will need while developing a database. To understand the ways that databases are structured, you should look through entity-relationship diagram examples and see the notations features and attributes. With an entity-relationship model you can describe a database of any complexity. This Entity-relationship diagram is a tool for software developers. It enables every element of database to be managed, communicated and tested before release. This ERD was created using symbols advocated by Chen's notation. Because of a linguistic origin of the Chen’s notation, the boxes representing entities could be interpreted as nouns, and the relationships between them are in verb form, shown on a diagram as a diamond.Entity Relationship Diagram Examples
Picture: Entity Relationship Diagram Examples
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 DIAGRAM 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:

IDEF0 Flowchart Symbols →

Functional modeling allows to make complex business processes simple. One of the basic methods is IDEF0 and one of the most effective also. To create a business model, use flowchart symbols. The IDEF0 library, supplied with ConceptDraw IDEF0 Diagrams solution contains 18 IDEF0 basic notation symbols. All symbols are the vector graphic images what means, that one can customize their size preserving the stable quality. Another library of IDEF0 symbols can be find out in the the Business Process Diagrams solution, included to the Business Processes section of ConceptDraw Solution Park. These libraries composed from just vector objects and are totally compatible. You can apply the IDEF0 symbols from both libraries at your flowcharts, if needed.IDEF0 Flowchart Symbols *
Picture: IDEF0 Flowchart Symbols
Related Solution:
ConceptDraw
DIAGRAM 15