It is constructive type database designing considering with physical world, and includes entities and relationships between them and represents by entity relationship diagram. It is completed with three steps:
It describe data as much as possible details, with developing an information model, which is helpful in object storage and supports DBMS. In this designing we have to learn:
Logical database shows conceptual model, it also require to be stored in physical media like hard disk, which is further used by application.
It is helpful in translating logical database designing into a SQL and MySQL statements which explain database. Some basic important rule for translations:
Find the best Database Assignment Help Services with us
<div style="clear:both"><a href="http://www.assignmenthelp.net/assignment_help/database-designing"> <img src="http://www.assignmenthelp.net/files/database-designing.jpg" title="Differentiate between Conceptual database design,Logical database design and Physical database design" alt="Difference between Conceptual, Logical and Physical Data Models" border="0" /></a></div> <div>Courtesy of: <a href="http://www.assignmenthelp.net/assignment_help/database-designing">AssignmentHelpNet</a></div>