Conceptual, Logical & Physical Data Models (Enhanced Audio)

No video

Conceptual, Logical & Physical Data Models (Enhanced Audio)

Рет қаралды 42,356

Күн бұрын

Learn about the 3 stages of a Data Model Design
- Conceptual Data Model
- Logical Data Model
- Physical Data Model
**This is a re-upload of my previous video about Conceptual, Logical & Physical Data Model. A lot of you complained you about poor audio quality in the older video. Hence the new video with enhanced audio.

Пікірлер: 81

@DataAcademyIN 20 күн бұрын

How about I train you on the foundations of Data Modeling? Email me at "ReachBinduKumar@gmail.com" 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 4 жыл бұрын

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

@DataAcademyIN 4 жыл бұрын

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 !

@vrmotovlog4333 20 күн бұрын

best video on data models in youtube

@DataAcademyIN 20 күн бұрын

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

@equiwave80 3 жыл бұрын

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

@peterc2248 Жыл бұрын

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

@pa32779 2 жыл бұрын

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

@DataAcademyIN 2 жыл бұрын

Thank you for your comments & Subscribing Parsa!

@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!

@juanfernandez5436 Жыл бұрын

Very clear and concise overview. Great job.

@DataAcademyIN Жыл бұрын

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

@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.

@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!!

@lody33100 2 жыл бұрын

That was very helpful 👌

@DataAcademyIN 2 жыл бұрын

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

@2001july06 2 жыл бұрын

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

@DataAcademyIN 2 жыл бұрын

Thank you for your comments Akash. Please do subscribe !

@SabrinaSterlingGA 10 ай бұрын

This is very helpful. Thank you for sharing!

@DataAcademyIN 9 ай бұрын

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

@rakeshkumar5077 2 жыл бұрын

Thank you for explaining in the simple terms.

@DataAcademyIN 2 жыл бұрын

Glad it was helpful!

@freebiehaha2078 3 жыл бұрын

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 3 жыл бұрын

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 !

@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.

@vdmarame 2 жыл бұрын

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

@DataAcademyIN 2 жыл бұрын

True. That's a great suggestion ! Thank you

@gkic1209 8 ай бұрын

Very good, thanks.

@DataAcademyIN 8 ай бұрын

Glad you liked it!

@abdulwahabkhan1086 Жыл бұрын

Very simple and efficient explanation.

@DataAcademyIN Жыл бұрын

Thank you Abdul. Please do subscribe!

@rudrakshpotghan801 2 жыл бұрын

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

@DataAcademyIN 2 жыл бұрын

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

@clivechigwazo Жыл бұрын

Thank you for sharing. Very useful information.

@DataAcademyIN Жыл бұрын

Thank you for your comments Clive. Please do subscribe !

@kenigiri 4 жыл бұрын

Much better! And Great explanation

@DataAcademyIN 4 жыл бұрын

Awesome, thank you Kenneth !

@DenisKashirskiy 3 жыл бұрын

Thank you for this clear overview!

@DataAcademyIN 3 жыл бұрын

Thank you for your kind comments Denis.

@juanarivera5422 3 жыл бұрын

This is great. Thank you so much for sharing.

@DataAcademyIN 3 жыл бұрын

You are so welcome! Please do subscribe.

@erangasenarath9829 2 жыл бұрын

Nicely explained. Thank you

@DataAcademyIN 2 жыл бұрын

Thank you for your comments !!

@glenrooney1068 2 жыл бұрын

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

@DataAcademyIN Жыл бұрын

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

@ArunKumar-gb6hz 3 жыл бұрын

Informative. Thanks!

@DataAcademyIN 3 жыл бұрын

Thank you Arun !

@upulweerasinghe5336 4 жыл бұрын

Great Video, Many Thanks !

@DataAcademyIN 4 жыл бұрын

Thank you Upul. Please do Subscribe !

@sunnyj1967 2 жыл бұрын

Simply Superb

@DataAcademyIN 2 жыл бұрын

Thank you for your comments Sunny !

@divyareddy1853 2 жыл бұрын

Awesome video!!

@DataAcademyIN 2 жыл бұрын

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

@UntamedRogueMavrick 2 жыл бұрын

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

@DataAcademyIN 2 жыл бұрын

:) Thank you Prashant !

@salusivakumar1900 3 жыл бұрын

Thanks

@DataAcademyIN 3 жыл бұрын

You're welcome !

@sujusuresh 2 жыл бұрын

amazing video!!

@DataAcademyIN 2 жыл бұрын

Glad you liked it!!

@drumsmaaan 2 жыл бұрын

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 2 жыл бұрын

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 ?

@shaibalbose9767 3 жыл бұрын

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

@DataAcademyIN 3 жыл бұрын

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.

@zhanaszhumagazinov5072 3 жыл бұрын

Can you send a presentation? I really need it

@zhanaszhumagazinov5072 3 жыл бұрын

Pleasee))

@demoon6069 3 жыл бұрын

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

@DataAcademyIN 3 жыл бұрын

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.

@nope4881 3 жыл бұрын

Where are the entity relationships ?

@DataAcademyIN 3 жыл бұрын

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

@kshitijsabale7534 3 жыл бұрын

100th like by me

@DataAcademyIN 3 жыл бұрын

@dendi1076 2 жыл бұрын

ideas are concise but the narration is pain in the ear

@DataAcademyIN 2 жыл бұрын

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