Logical and physical design of a

Therefore, the data to be stored in the database must be determined in cooperation with a person who does have expertise in that domain, and who is aware of what data must be stored within the system. This process is one which is generally considered part of requirements analysisand requires skill on the part of the database designer to elicit the needed information from those with the domain knowledge. This is because those with the necessary domain knowledge frequently cannot express clearly what their system requirements for the database are as they are unaccustomed to thinking in terms of the discrete data elements which must be stored.

Logical and physical design of a

Conceptual, logical and Physical data model Conceptual, logical and Physical data model Conceptual, logical and physical model or ERD are three different ways of modeling data in a domain. While they all contain entities and relationships, they differ in the purposes they are created for and audiences they are meant to target.

A general understanding to the three models is that, business analyst uses conceptual and logical model for modeling the data required and produced by system from a business angle, while database designer refines the early design to produce the physical model for presenting physical database structure ready for database construction.

Database design - Wikipedia

With Visual Paradigmyou can draw the three types of model, plus to progress through models through the use of Model Transitor. The need of satisfying the database design is not considered yet. Conceptual ERD is the simplest model among all. The usage is like generalization in UML.

Notice that only conceptual ERD supports generalization. It is more complex than conceptual model in that column types are set. Note that the setting of column types is optional and if you do that, you should be doing that to aid business analysis.

It has nothing to do with database creation yet.

Explain the difference between conceptual, logical and physical design.

This means that an accurate use of data type is needed for entity columns and the use of reserved words has to be avoided in naming entities and columns. Besides, database designers may also add primary keys, foreign keys and constraints to the design. This will form a new ERD with new entities there.

You can make changes like to rename the entities and columns, or to add extra entities in the new ERD.

Updated on May 2, Doc navigation.The physical aspects of our information resources are well understood by developers; e.g., computer hardware/software, DBMS files, manual files, screens, reports, forms, etc. The logical side of our resources is a bit more nebulous, yet just as important, if not more so, than their physical.

The physical design of the network is derived from the logical design and the physical design will often expand on the elements found in the logical design. For example, let’s say that the logical design shows a WAN connection as line between to buildings. A physical design does not tell us what is being leslutinsduphoenix.comL DESIGN:The logical design of a system pertains to an abstract representation of the data flows, inputs andoutputs of the system.

Logical and physical design of a

Jul 22,  · Logical and physical database models are required in order to visually present the database that has been proposed for a certain business requirement. The models help in showing the association of business requirements and the database objects.5/5(1). The logical design is more conceptual and abstract than the physical design.

In the logical design, you look at the logical relationships among the objects. In the physical design, you look at the most effective way of storing and retrieving the objects. Your design should be oriented toward the needs of . Jul 22,  · Logical database modeling is required for compiling business requirements and representing the requirements as a model.

It is mainly associated with the gathering of business needs rather than the database design. The information that needs to be gathered is about organizational units, business 5/5(1).

Difference between conceptual, logical and physical design - microsoft solution framework