Logical and Physical are another level of complexity above Conceptual, whilst a conceptual model can be considered “Data Rich” and may have more data and tables that actually required in the system.

This is fine as during the Logical/Physical design its refined.

Both logical and physical are very similar.

Great comparison image.

logical-vs-physical

Logical shows how the tables will be designed in plain text, Physical shows the actual SQL descriptions.

Logical allows the designer to get a good grasp of what they will be making, Physical allows them to have reference for the actual CREATE TABLE commands.

With my project i’ll be creating both as they are very useful tools.

RES701.

Interesting class, the focus on critical writing and thinking is great and i loved having the chance to write long form blogs about subjects, would be nice if we were given more chance to create big long blogs about different topics but whatever, still enjoyed.

https://jaskanores701.wordpress.com/2016/08/21/tranhumanism-and-ai-james-cotton/

Would have to be my favorite of the blogs i made, pretty interested in both the topics but they are rather complex in their intricacy to do my project on. and it’s not like i want to work as an AI developer or in the field of trans-humanism as that would require knowledge of medical stuff.

Will be recommending to my friends to do, and look forward to having Claire as a tutor again as you are awesome šŸ™‚

One thought on “Logical/Physical and Thoughts about RES”

  1. Thank you James – it has been great to hear/read your interesting and thoughtful observations on various topics šŸ™‚

    I always thing the main difference between conceptual logical and physical is this:
    A good conceptual model can be transformed into a logical model of any type e.g. relational, object-oriented, non-relational etc…it should be Data Model independant.
    A good logical model can be transformed into any DBMS of the same type – e.g. a relational logical model can be transformed into an Oracle, MySql, SLQServer, DB2 etc database
    A good physical model is specific to the particular DBMS that it is built for so a physical database built in ORACLE is not the same as one built in MySQL for example. They will require different kinds of physical structures like indexes or partitions etc to take full benefit of the specific software. So a physical model will also include not just the tables but the indexes tablespaces permissions etc etc..

    Wow you have just reminded me why I love databases!

    Like

    Reply

Leave a comment