Conceptual, Logical & Physical Data Models (Enhanced Audio)
Рет қаралды 41,956
Күн бұрын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.
@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.
@equiwave80 3 жыл бұрын
This video was a real eye opener for me. Thanks for this video!!!
@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 !
@peterc2248 11 ай бұрын
Very good video - simple and easy to follow. Many thanks
@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!
@DenisKashirskiy 3 жыл бұрын
Thank you for this clear overview!
@DataAcademyIN 3 жыл бұрын
Thank you for your kind comments Denis.
@kenigiri 3 жыл бұрын
Much better! And Great explanation
@DataAcademyIN 3 жыл бұрын
Awesome, thank you Kenneth !
@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!
@juanarivera5422 3 жыл бұрын
This is great. Thank you so much for sharing.
@DataAcademyIN 3 жыл бұрын
You are so welcome! Please do subscribe.
@upulweerasinghe5336 3 жыл бұрын
Great Video, Many Thanks !
@DataAcademyIN 3 жыл бұрын
Thank you Upul. Please do Subscribe !
@SabrinaSterlingGA 9 ай бұрын
This is very helpful. Thank you for sharing!
@DataAcademyIN 8 ай бұрын
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!
@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!!
@ArunKumar-gb6hz 3 жыл бұрын
Informative. Thanks!
@DataAcademyIN 3 жыл бұрын
Thank you Arun !
@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 !
@gkic1209 7 ай бұрын
Very good, thanks.
@DataAcademyIN 7 ай бұрын
Glad you liked it!
@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.
@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
@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.
@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 :)
@divyareddy1853 Жыл бұрын
Awesome video!!
@DataAcademyIN Жыл бұрын
Thank you Divya. Glad you found it useful. Please do subscribe!
@clivechigwazo Жыл бұрын
Thank you for sharing. Very useful information.
@DataAcademyIN Жыл бұрын
Thank you for your comments Clive. Please do subscribe !
@abdulwahabkhan1086 Жыл бұрын
Very simple and efficient explanation.
@DataAcademyIN Жыл бұрын
Thank you Abdul. Please do subscribe!
@erangasenarath9829 2 жыл бұрын
Nicely explained. Thank you
@DataAcademyIN 2 жыл бұрын
Thank you for your comments !!
@lody33100 2 жыл бұрын
That was very helpful 👌
@DataAcademyIN 2 жыл бұрын
Thank you! I am glad you found it 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 !
@sujusuresh 2 жыл бұрын
amazing video!!
@DataAcademyIN 2 жыл бұрын
Glad you liked it!!
@glenrooney1068 Жыл бұрын
Not bad, not bad at all. Nice summary.🙂
@DataAcademyIN Жыл бұрын
Thank you Glen. Glad you found it useful. Please do subscribe !
@UntamedRogueMavrick 2 жыл бұрын
Awesome..., Can't forget even if I want to.
@DataAcademyIN 2 жыл бұрын
:) Thank you Prashant !
@sunnyj1967 2 жыл бұрын
Simply Superb
@DataAcademyIN 2 жыл бұрын
Thank you for your comments Sunny !
@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 ?
@salusivakumar1900 3 жыл бұрын
Thanks
@DataAcademyIN 3 жыл бұрын
You're welcome !
@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.
@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 жыл бұрын
:)
@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.
@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.