Conceptual, Logical & Physical Data Models (Enhanced Audio)

[@DataAcademyIN]

How about I train you on the foundations of Data Modeling? Email me at "[e-mail]" or Telegram at @ReachBinduKumar to sign up for my Live Instructor Led course on "Data Modeling Foundations". I am a Senior Data Architect with over 18 years of real world experience designing Data Architecture for a variety of use cases. See you in my class!

[@KevShaw808]

Much better audio. Thank you very much for making this very informational video!

[@DataAcademyIN]

Thank you Kevin ! Please do subscribe to be notified of new uploads.

[@chinedumjoseph9875]

Excellent! This is the best video I have watched that explains the difference between the data models. Thanks you so much for sharing this.

[@DataAcademyIN]

Many thanks for your comments Chinedum :) Please do subscribe to the channel !

[@raeedsubhan7716]

Thank you soooo much. I was taught logical is files and physical is table, and that made absolutly no sense. Your video explained it perfectly, now I know what they meant by it. Your amazing!

[@DataAcademyIN]

Thank you Raeed for your encouraging comments🙏. I am glad to hear it clarified your doubts. Please do Like, Share & Subscribe!

[@yuvarajvelmuruganmudaliyar]

Conceptual data modeling is about establishing: entities, attributes and relationships. Search for er diagram symbols online. We need to use rectangle to represent entity. Ellipse to represent attributes. Diamond to represent relationship between two entities. Logical data modeling is independent of database system. It could be done with uml diagram tools like umbrello, staruml etc. Use uml entity relationship diagram. Physical data modeling is database system dependent.

[@DataAcademyIN]

Hello Yuvaraj. Thank you for sharing your different perspective. Your definition is correct, but I feel it is more academic. The intention of this video is to introduce a viewer on the 3 phases of Data Modeling, and not necessarily get into the finer details of the shape that should be used. Perhaps I will cover that in future videos. This video is more in line with usage of a Data Modeling tool like PowerDesigner. My hope is that after viewing this video, the viewer is now aware of the 3 phases, and appreciate it's need. After there onwards, the viewer is encouraged to learn further on the design part, exactly as you described.

[@juanfernandez5436]

Very clear and concise overview. Great job.

[@DataAcademyIN]

Thank you Juan. Appreciate your comments. Please do subscribe to show your support!

[@peterc2248]

Very good video - simple and easy to follow. Many thanks

[@equiwave80]

This video was a real eye opener for me. Thanks for this video!!!

[@compsciwithaayush1413]

such a nice and clear explanation sir. Hats off to you. One of the best tutor over the internet ❤❤

[@DataAcademyIN]

Thank you Aayush for your kind comments 🙂 Please do subscribe to show your support!!

[@vrmotovlog4333]

best video on data models in youtube

[@DataAcademyIN]

Thank you very much! Please do Like, Share & Subscribe!

[@pa32779]

Thank you so much, took 13 minutes than a two hour lecture to finally understand. Subscribed! Keep it up bro!

[@DataAcademyIN]

Thank you for your comments & Subscribing Parsa!

[@2001july06]

Perfect sir, I am new to data modeling and this video is really helpful

[@DataAcademyIN]

Thank you for your comments Akash. Please do subscribe !

[@abdulwahabkhan1086]

Very simple and efficient explanation.

[@DataAcademyIN]

Thank you Abdul. Please do subscribe!

[@vdmarame]

Thank you! It would be great to insert a reminder on primary-foreign keys when presenting the logical data model.

[@DataAcademyIN]

True. That's a great suggestion ! Thank you

[@rudrakshpotghan801]

It was a really helpful video, Since i have my tests tomorrow. Thanks sir.

[@DataAcademyIN]

Glad it helped ! Wish you all the best for your tests :)

[@nethravathi2845]

The explanations is very clear, it helped me for preparing for my interview, thank you much for the very clear explanation video, hope we get more videos 🙂

[@DataAcademyIN]

Thank you Nethravathi. I am glad you found it useful. Please do subscribe to show your support, and to get notified when I upload more.

[@freebiehaha2078]

Thank you for your explanation on data models sir♥️ I have a few question regarding the relationship between ER diagrams and Data Models. 1. So in ER mapping what we are generally doing is converting the ER diagram into a physical data model ? 2. Is it suitable to convert an ER digram to conceptual model -->logical model and finally into physical model? 3. Normalization is only possible for the physical data model ? Thank you again for the explaination.

[@DataAcademyIN]

Hello, Here are the answers to your questions 1) The 3 phases that I have discussed about is not only specific to ER modeling, but is applicable to any "type" of data model. So, yes we can say that we convert the ER Diagram (Logical Model) into a Physical Data Model. 2) An ER Diagram is equivalent to a Logical Data Model. Hence there is no question of converting a ER Diagram to a Conceptual or a Logical Data Model 3) Normalization should happen at Logical Data Model itself. Otherwise you cannot get the benefit of automatically converting a Logical Data Model to a Physical Data Model, using a Data Modeling tool. Hope these answers help. Let me know if any further questions. Thanks !

[@rakeshkumar5077]

Thank you for explaining in the simple terms.

[@DataAcademyIN]

Glad it was helpful!

[@clivechigwazo]

Thank you for sharing. Very useful information.

[@DataAcademyIN]

Thank you for your comments Clive. Please do subscribe !

[@SabrinaSterlingGA]

This is very helpful. Thank you for sharing!

[@DataAcademyIN]

Glad it was helpful!. Please do like, share & subscribe

[@glenrooney1068]

Not bad, not bad at all. Nice summary.🙂

[@DataAcademyIN]

Thank you Glen. Glad you found it useful. Please do subscribe !

[@gkic1209]

Very good, thanks.

[@DataAcademyIN]

Glad you liked it!

[@DenisKashirskiy]

Thank you for this clear overview!

[@DataAcademyIN]

Thank you for your kind comments Denis.

[@sunnyj1967]

Simply Superb

[@DataAcademyIN]

Thank you for your comments Sunny !

[@lody33100]

That was very helpful 👌

[@DataAcademyIN]

Thank you! I am glad you found it helpful :)

[@divyareddy1853]

Awesome video!!

[@DataAcademyIN]

Thank you Divya. Glad you found it useful. Please do subscribe!

[@juanarivera5422]

This is great. Thank you so much for sharing.

[@DataAcademyIN]

You are so welcome! Please do subscribe.

[@erangasenarath9829]

Nicely explained. Thank you

[@DataAcademyIN]

Thank you for your comments !!

[@kenigiri]

Much better! And Great explanation

[@DataAcademyIN]

Awesome, thank you Kenneth !

[@UntamedRogueMavrick]

Awesome..., Can't forget even if I want to.

[@DataAcademyIN]

:) Thank you Prashant !

[@ArunKumar-gb6hz]

Informative. Thanks!

[@DataAcademyIN]

Thank you Arun !

[@upulweerasinghe5336]

Great Video, Many Thanks !

[@DataAcademyIN]

Thank you Upul. Please do Subscribe !

[@sujusuresh]

amazing video!!

[@DataAcademyIN]

Glad you liked it!!

[@salusivakumar1900]

Thanks

[@DataAcademyIN]

You're welcome !

[@shaibalbose9767]

I wonder, why I did not see any Cardinality in the Logical & Physical ERDs ... thank you

[@DataAcademyIN]

Hello Shaibal - There are options in the Data Modeling tool to hide/display the cardinality between tables. They were turned off while taking the screenshots.

[@drumsmaaan]

I'm a little bit confused. At what point do you add the "Decision Diamonds"? Currently studying for an assignment on this and trying to get my head around it...

[@DataAcademyIN]

Apologies for the delay in responding. I don't think "Decision Diamonds" are relevant in Data Modeling. I could be wrong though. Any specific reference would help me understand it ?

[@nope4881]

Where are the entity relationships ?

[@DataAcademyIN]

Hi Saurabh. @ 05:29 you can see the lines connecting the entities. The lines represent the relationship.

[@zhanaszhumagazinov5072]

Can you send a presentation? I really need it

[@zhanaszhumagazinov5072]

Pleasee))

[@demoon6069]

@@zhanaszhumagazinov5072 по икт задали?))

[@DataAcademyIN]

Hello Zhanas. Apologies for the delay in responding, but I do not have the slide with me. I lost it during my laptop crash. A quick way to recreate this maybe is to take screenshots from the video, and insert them into a PPT. I know it is not an easy thing to do, but it may be the only thing possible.

[@kshitijsabale7534]

100th like by me

[@DataAcademyIN]

:)

[@dendi1076]

ideas are concise but the narration is pain in the ear

[@DataAcademyIN]

I can understand. I am a novice at making KZbin videos. Could you help me understand specifically what wasn't right? I could use that to improve my next upload.