Answered! Logical modeling represents the solution without reference to a specific technology. Physical modeling maps the logical modeling to specific technologies….

Logical and physical models are required in order to represent the database. These are useful for showing the database objects. These models are used useful in order to gather all requirements.

Logical Database Model:
Logical database modeling is type of data model and it is required for compiling requirements and representing them as model. It focuses on requirements gathering rather than the design.After the gathering of requirements then it focuses on reports and diagrams. ERD diagrams shows the relationship between differenttypes of data.
Business process diagram shows the objects and entities within the company. It shows the flow of data that moves within the organization.Generally Logical database models determine whether all the requirements have been gathered or not. Then it is managed by developers, management.

Physical Database Model:
Physical database modeling mainly deals with designing database based on the requirements gathered during logical database modeling. Then all information is converted into relational models. During this model objects are defined at schema level.Here schema is considered as group of objects in database.In database tables and columns are made according to the requirements. Here mainly focuses on Primary keys, unique keys, and foreign keys and also on Indexes.Physical database is software specific. Physical modeling includes server model diagram which includes tables and columns that exist within a relational databse.