Physical Data Modelling Vs Logical Data Modelling

[teky]

Hi everybody,

Can anybody explain me the difference between Physical Data Modelling and Logical Data Modelling.

Thanks,
Teky.

 

[perryf]

The most basic answer to the question I've seen is that:

Logical Model: Tables and their relationships. But columns can have English names. And their is no more details then Customer Table includes Customer Name and Customer Address.

Physical Model: Details are spelled out, especially for columns. Includes datatype and size, and actual name in DB.

HTH,

PF

 

[tlbroadbent]

Here are some good resources.

http://softwaredev.earthweb.com/sdtech/article/0,,12065_641521,00.html

http://www.aisintl.com/case/CDM-PDM.html

http://www.rational.com/products/whitepapers/411.jsp

There are many other resources on the Web, at Microsoft and in SQL BOL. Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm

 

[teky]

Thank you very much for all your responses.
They are really helpful.

-Teky.