Database Lesson #4 of 8 - Data Modeling and the ER Model

  Рет қаралды 372,948

Dr. Daniel Soper

Dr. Daniel Soper

Күн бұрын

Пікірлер: 203
@ziadcs5309
@ziadcs5309 2 жыл бұрын
Dear Dr Daniel I just wanted you to know That I am a computer science student who lives in Syria With very Poor financial conditions so I cannot afford for private tutors to teach me dbms I'm so grateful for the high quality knowledge you provide here for free Words cannot describe how thankful I am Wish you all the best
@dgenerationbigestfan
@dgenerationbigestfan Жыл бұрын
please keep us updated on your progress. Us here are interested in how you end up!!!
@ziadcs5309
@ziadcs5309 Жыл бұрын
I appreciate your kindness, the situation here is very bad in all aspects, unfortunately I'm just doing the bare minimum to pass my courses at university, the electricity here is available only 3/24 (three hours a day at its best), I think I'm graduating next year, but I think its hard for me to get to the real job market, I may start learning web development (in case things does not go worse!!). thanks for your comment again it made my day, wish you a nice day @@dgenerationbigestfan
@mgray999
@mgray999 4 жыл бұрын
You're better than my prof. I've been anxious about this class because the lectures cover just spouts of info and not the details. Thanks for this!
@Blue4736.
@Blue4736. 5 жыл бұрын
Requirements to ER model 5:15 Entity class v entity instance 6:50 Entity class v entity instance visual 10:30 Attributes 11:20 Identifiers [keys] 13:10 Types of keys 13:50 Level of entity attribute display 16:45 Relationships 18:50 Conceptual unary relationship 21:20 Conceptual binary relationship Conceptual ternary relationship One or many connections 23:12 One-to-one binary relationship 24:10 One-to-many binary relationship 25:00 Conceptual many to many binary relationship Note: can’t build a direct conceptual many to many in a db. Need a middle table….extra entity 25:40 Conceptual many to many binary relationship/ extra entity 26:50 Maximum cardinality 27:20 Minimum cardinality 28:40 Crows foot symbols 29:20 Cardinality example 33:20 Er diagrams 34:40 Has -a-relationship 36:00 Strong and weak entities 36:30 Id-dependent weak entities 38:00 Weak entity relationships 40:00 Weak entity identifier/ non-id dependent 41:30 42:10 Subtype entities 44:00 Subtype entity identifiers 47:30 Subtype entity examples Recursive relationship 53:00
@joannaglasby2596
@joannaglasby2596 4 жыл бұрын
Hero status unlocked!
@MelancholyMadoka
@MelancholyMadoka 3 жыл бұрын
You dropped this crown, @Warren L.
@SRHarkreader
@SRHarkreader 8 жыл бұрын
Thank you so much Dr Soper; this is hands down, the best ERD tutorial I've ever watched. Great job!
@sabanaar
@sabanaar 9 жыл бұрын
Thanks a lot Dr. Soper, best coverage on the data modeling and the entity-relationship (ER) model I have ever seen. You are one of the best teacher I have ever had.
@GameFraper
@GameFraper 10 жыл бұрын
Paying 9 grand for uni and get a useless pdf as a resource. Pay nothing for an hour long, detailed, easy to understand video. This is just so wrong
@ervincasiguran
@ervincasiguran 9 жыл бұрын
i feel you
@BraulioCespedesAcosta
@BraulioCespedesAcosta 9 жыл бұрын
Fedil Al-Hayawi That's the new model of education. The same thing happened to me. I got a book of data base design from the library, Too complex for a beginner, but this video make thing easier.
@meyerjohannes
@meyerjohannes 9 жыл бұрын
+Fedil Al-Hayawi It's a f***ing scam. I decided not to buy any textbooks this semester (except for one that I found an older edition for $5). It's so frustrating, they release new editions every couple years, and the only thing that changes is maybe the introduction and the end-of-chapter questions! And then when you finish the course, a $250 book is suddenly worth $60. Better to rent, but it's still a rip off. About to graduate, and the whole time I'm thinking when I walk the dean is going to hand me a paper, saying "here's your receipt".
@vayunandu
@vayunandu 7 жыл бұрын
well said!
@promisennanemere4
@promisennanemere4 5 жыл бұрын
I understand you bro. It can be that bad.
@ginaonline83
@ginaonline83 7 жыл бұрын
I've taken 2 database classes in the past but I've learned so much from your series of videos than I've learned in the classes, very detailed and easy to understand, thx u so much.
@oreed
@oreed 8 жыл бұрын
Dr. Soper, you are a great teacher. The content is so clear and easy to understand, the way you explain things is so logical, and your examples really help. Thank you for this!
@prfgee8788
@prfgee8788 7 жыл бұрын
Your method of presentation is second to none and your explanation is top notch. You deserve an award. Thank you!
@bindenlibejohn7378
@bindenlibejohn7378 Жыл бұрын
If it must be done, It must be done well. Dr. you did it all . from simplicity through clarity to comprehensiveness. Bravoo!!!!!
@jephthah2347
@jephthah2347 6 жыл бұрын
This is the best tutorial on this topic you'll find on the internet
@lilitanikushkina1194
@lilitanikushkina1194 7 жыл бұрын
Love everything about your lectures - the pace, the material, the structure, presentation and also the manner of speaking. Huge thanks!
@hkrumble
@hkrumble 7 жыл бұрын
Dr. Daniel Soper, thank you so much for this. This is by far the most clear, lucid explanation of data modeling and ERDs I've come across. Fantastic!
@jimb6554
@jimb6554 2 жыл бұрын
At 20:56 I was having difficulty with the Person entity relating to itself with marriage. I was thinking “Aren’t 2 different entities getting married?”. Then I resolved the difficulty by realizing that A person entity is a table. While an employee table relating to a parking table is a binary relationship because it involves two tables, one person instance getting married to another person instance is a Unary relationship because it involves just one table which is why we also call it a reflexive relationship.
@hauteswan2541
@hauteswan2541 8 жыл бұрын
This is a great addition to my non-lecture database class. I will recommend it to my class. Thank you.
@streetdogg4406
@streetdogg4406 6 жыл бұрын
Kimberly wow. How easy is it being a teacher?
@tiyezx5993
@tiyezx5993 7 жыл бұрын
Just came across your tutorials today after years of many challenges learning databases. I'll return to give feedback. Very positive comments so far about your work. Thank you
@pajhume
@pajhume 11 жыл бұрын
Very clear and concise. Video elaborates on specific details that are critical to understanding the subject matter. A+ quality. Deeply appreciative of your generosity!!!
@christopheropara6083
@christopheropara6083 6 жыл бұрын
I thank God for creating people like you.
@scienceklinic4584
@scienceklinic4584 2 жыл бұрын
Saved the video in 2018 and watching in 2022. What a gem! Thank you so much, prof.
@SrkySrky
@SrkySrky 11 жыл бұрын
This is gold. The best lessons on KZbin.
@agofpos
@agofpos 10 жыл бұрын
37:07 "Any entity that is not a weak entity is called a strong entity" Very helpful.
@jimc1499
@jimc1499 Жыл бұрын
Dr. Soper thank you for this great video series.
@binti3881
@binti3881 6 жыл бұрын
this is the best video on Data Modeling . very clear and explanatory. well done prof.
@fred.chapman
@fred.chapman 5 жыл бұрын
*DR. SOPER* , I am learning a great deal from your lectures! I believe I found a small mistake at 52:52 and 55:03. In the recursive (unary) relationship between employees and managers, an employee need not have a manager (e.g., the CEO has no manager), but each manager must supervise at least one employee _and may supervise many employees._ So, the crow's foot symbol next to the employeeId attribute should have a cardinality of *one-to-many* , not one-and-only-one. Is that correct? Thank you!
@GlebLobanov
@GlebLobanov 4 жыл бұрын
I have the same question.
@thomasjust2663
@thomasjust2663 2 жыл бұрын
Who asked you id_ot
@fred.chapman
@fred.chapman 2 жыл бұрын
@@thomasjust2663, if another person's intelligence, knowledge, and ability make you feel so threatened, inadequate, and inferior that you become rude and insulting and lash out for no reason, then you have a real problem. You need to get help with that. I want you to talk with someone you trust, like a close friend, counselor, or therapist, to figure out why you are so desperately unhappy. You'll never find happiness by trying to tear other people down. You need to believe in yourself, invest in yourself, and build yourself up. I did it, and you can do it too. Will you try, Thomas?
@junaidmughal3806
@junaidmughal3806 2 жыл бұрын
I think you are right
@radocisar3420
@radocisar3420 2 жыл бұрын
p 9
@vbossbla532
@vbossbla532 Ай бұрын
Excellent explanations. Clear and concise. Thank you!
@pikkosaksa
@pikkosaksa 10 жыл бұрын
a joy to refresh and learn with Dr. Soper. Thank you!
@karnabudhathoki5311
@karnabudhathoki5311 4 жыл бұрын
I have no formal training on IT.yet these lectures give me an insight into the IT world...Thanks...from Nepal.I am learning a lot...
@tvd1826
@tvd1826 7 жыл бұрын
Thank you Dr. Soper for this presentation. It has been a great help!
@scottmacnevin3555
@scottmacnevin3555 7 жыл бұрын
You have a teaching gift - like many others who have furnished a response - I currently study this topic at University. The teaching at my facility just isn't up to this standard when it comes to imparting concepts this clearly...I am almost at the end of your fourth video and feel I have such a good grasp of the concepts involved. Thank you
@vbreddy800
@vbreddy800 10 жыл бұрын
That is is great lecture I ever had before. Thanks very much Dr. Soper.
@GSoftagon
@GSoftagon 6 жыл бұрын
Dr. Soper, this is excellent. Thank you very much.
@JFrameMan
@JFrameMan 10 жыл бұрын
Very smooth and understandable explanation. Thanks a lot.
@jim-ngormohkamara4805
@jim-ngormohkamara4805 6 жыл бұрын
Dr. Soper you are a life saver
@neetuarya2252
@neetuarya2252 Жыл бұрын
Thanks a lot Dr. For this really informative lecture. Have a good day
@kanchapagimhara584
@kanchapagimhara584 5 жыл бұрын
Great,perfect explanation.One of the best video tutorial in the youtube I have seen,I improved my Englilsh also as an extra benefit.
@madiyarabdukhashimov8570
@madiyarabdukhashimov8570 4 жыл бұрын
I have studied all those things at the university and I had no idea what the heck I was studying. I could barely get B0 (B-) for all preparing tests and exams with many not sleeping nights. I was just happy not to get FAIL. I have been watching this video with 1.5X speed and can't believe everything is so well explained and easy to understand!)
@manhungchan5447
@manhungchan5447 4 жыл бұрын
Well done, Dr. Daniel Soper.
@fksheke1
@fksheke1 10 жыл бұрын
Thank you Dr Soper. This is really amazing. God bless you.
@bedbathorybeyond
@bedbathorybeyond 9 жыл бұрын
I am very stoked on these videos.
@caseyobrien1082
@caseyobrien1082 8 жыл бұрын
Why hasn't my prof done anything like this? I'm having to scour the internet to find a lecture on the subject. My professor just has us read the book, then gives us assignments. He offers no other learning resources whatsoever. Thankfully I've found this.
@GloriaCopeland563537
@GloriaCopeland563537 8 жыл бұрын
Same here
@bhatz829
@bhatz829 7 жыл бұрын
My professor doesn't even speak to me. Been asking about what I should do. I get this video. This isn't even on the chapter I am learning.
@noniboi1673
@noniboi1673 5 жыл бұрын
My lecturer just gave us a pdf, which were slides from THIS series. huehuehe
@geetatiku
@geetatiku 11 жыл бұрын
Very useful.. Explaining it in a very simple way.. Thank You Dr. Soper.
@nandhi19
@nandhi19 8 жыл бұрын
Valuable learnings keep life FRESH😊 Thank you for your valuable lessons🙏
@kaizhou8278
@kaizhou8278 10 жыл бұрын
Thank you so much Dr. Daniel Soper.
@VinaySesham
@VinaySesham 8 жыл бұрын
Excellent. Explanation is so simple and effective.
@xolelamqikela4534
@xolelamqikela4534 7 жыл бұрын
Writing business systems and analysis test in 12hours, thanks to Doc im gonna nail it
@anvikshadixit4674
@anvikshadixit4674 7 жыл бұрын
Very informative lecture . i was able to understand the data modelling in much better way. Thank you sooo much for making such a great video with great explanation. :)
@bettyseyfu8140
@bettyseyfu8140 5 жыл бұрын
Thank you so much Dr.Daniel Soper, this is the best use full and understanding lecture I never had i'm thank full! if you have more continuing database lesson 9 Ext
@_devParty
@_devParty 5 жыл бұрын
Thank you Sir. This is still relevant and informative in 2019
@nareshpuppala1544
@nareshpuppala1544 4 жыл бұрын
3w553ree555sr43w553ree554445sr554 5r5545 and 5 I 4354noon err e4t4t3 tt4rr44 koi544 55555inches3zwdxx'r5was342455ss55sssssssssxcxv554ewd5xx'r 35 the 5same of 2444 re 445w55 i re6,655s6tr56t6 rut 66 rut 66666666666s66s6 ttrr tree error r76 Stewart 3ewe7sfor or rate w5r÷6d5a5sa5eew ee6 55w5wr55e6 w5w5wr55e6 a week 5w
@chaitanyavs
@chaitanyavs 6 жыл бұрын
Thank you for this amazing lecture series! One feedback- I'd love to see more examples of how to read the diagrams depicting entity relationships- You explained the concept well but some more examples would help the viewers
@gramirom
@gramirom 2 жыл бұрын
Amazing series Daniel! Thank you very much
@M00nShad00w
@M00nShad00w 9 жыл бұрын
Thanks god for a video in KZbin I can understand
@BobTheBob647
@BobTheBob647 9 жыл бұрын
Thank you for these videos, they have been incredibly helpful.
@sohaibkhan8835
@sohaibkhan8835 6 жыл бұрын
Thank you so much Dr. Soper!
@fmartinez004
@fmartinez004 6 жыл бұрын
I took introduction to Oracle SQL and this is bringing it all together for me.
@ajharrisTX
@ajharrisTX 9 жыл бұрын
Great presentation; well-spoken and thoroughly informative. Will definitely utilize your videos to supplement my AIS course!
@aaronsalifukoroma7994
@aaronsalifukoroma7994 6 ай бұрын
I appreciate your careful systemic explanation
@srv14evr
@srv14evr 8 жыл бұрын
You are an awesome teacher!
@vadanmehta784
@vadanmehta784 9 жыл бұрын
Dr Soper.. thank you very much for knowledge.. u made things so simple ..wow :)
@Cswaleomatic
@Cswaleomatic 4 жыл бұрын
Thanks a Million Professor!!!! God bless you.
@parthpatel4221
@parthpatel4221 4 жыл бұрын
very very useful, and easy to understand and in easy language. thanks
@emperoy8
@emperoy8 9 жыл бұрын
Great man done great Job. Thanks Dr. Soper
@csanadkozma7538
@csanadkozma7538 8 жыл бұрын
Awesome vid! Now I understand the giant 20-30 entity diagrams in my work.now All I have to do is memorise them!
@kevinpaul3285
@kevinpaul3285 10 жыл бұрын
Great work on the video series. Very informative.
@BrokkoliSchleuder
@BrokkoliSchleuder 10 жыл бұрын
wow, in this way (and length) every youtube video lesson should be. Nice!
@2002egncn
@2002egncn 2 жыл бұрын
Awesome series. Thanks so much!
@samanthapikus3178
@samanthapikus3178 7 жыл бұрын
Thank you so so so much!!! My textbook is written poorly. Also, I now even understand objects and classes better. Thanks!!!
@fatossm
@fatossm Ай бұрын
harika bir şekilde örneklerle küçük adımlarla anlatıyorsunuz, teşekkürler.
@rotopercutorash
@rotopercutorash 7 жыл бұрын
very nice video! thank you for taking the time to share your knowledge. However, I had to speed up to 1.5 as i found it to slow but that is probably because i had too much coffee. Works like a charm
@theamazingspiderplan
@theamazingspiderplan 10 жыл бұрын
Thank you Dr. Soper!
@deepakpathak9368
@deepakpathak9368 5 жыл бұрын
Great Videos and Very informative for building good concepts. Thanks.
@delroyfrancis4491
@delroyfrancis4491 10 жыл бұрын
Thanks for all you do;
@medbee6067
@medbee6067 7 жыл бұрын
very well explained Data Modelling and Entity Relationship Model. Thank you
@harryk1317
@harryk1317 10 жыл бұрын
Thanks for the excellent presentation!
@tamimhekmatpey2729
@tamimhekmatpey2729 10 жыл бұрын
Very helpful teaching presentation, above all I admire your good intention for sharing it with the public. Is there any other subjects or topics on your agenda? - Thank you.
@zzhao463
@zzhao463 8 жыл бұрын
Question: If the PK of the strong entity is not a FK in the weak entity, and all other restrictions remains the same, would it be a non-id-dependent relationship?
@ubongessien4934
@ubongessien4934 11 жыл бұрын
Thank you for this presentation, this was very helpful.
@abv250
@abv250 6 жыл бұрын
Thanks very much for your lecture. I was able to connect a lot of dots. Would you post the slides - the examples help when trying to model parallet db schemas in my own work. Thanks again.
@ivyma8593
@ivyma8593 7 жыл бұрын
26:43 why do we must have third table link those two together?
@ivyma8593
@ivyma8593 7 жыл бұрын
can't it just be item-supplier
@srest0173
@srest0173 10 жыл бұрын
For the model you showed with undergraduates and graduates, how would you prevent losing the data about a student who goes from undergrad to graduate considering each one has their own specific attributes?
@agofpos
@agofpos 10 жыл бұрын
25:33 misleading picture, it should be Department -> Employee and not the other way around.
@sywanneto1506
@sywanneto1506 8 жыл бұрын
The example of ID-Dependent and non-ID-Dependent weak entities gived by dr. Daniel had the same parent entity and almost the same child entity. The only difference was the way the parent's primary key was organized in the child entity (as foreign or primary ). Is the non-ID-Dependent and ID-Dependent choice arbitrary? I mean, are they only paradigm? or there's a best practices preferential onle? or depends of the case? Cause the example gave the impression that it doesn't.
@BraulioCespedesAcosta
@BraulioCespedesAcosta 9 жыл бұрын
Thanks, Professor.
@sangminpark2948
@sangminpark2948 6 жыл бұрын
can an entity have more than 1 primary key? 43:27
@zegeyewoldemariam9518
@zegeyewoldemariam9518 10 жыл бұрын
that's really amazing God bless you
@Cashman9111
@Cashman9111 7 жыл бұрын
why do you have to acknowledge recursive relationship ? empId implies managerId so why does it have to be marked ?
@0xatul
@0xatul 2 жыл бұрын
Great Lecture
@weiniu5400
@weiniu5400 10 жыл бұрын
Very helpful! Thanks a lot for sharing!
@autumnking100
@autumnking100 10 жыл бұрын
Thank you. Very well explained.
@Karmidzhanov92
@Karmidzhanov92 6 жыл бұрын
For the last example, the diagram reads that an employ can have ZERO OR ONE manager (with which I agree) but a manager can have EXACTLY ONE employee (showed with the two hash marks) which the following illustration clearly proves wrong (as a manager had three employees under him) Did I miss something?
@Karmidzhanov92
@Karmidzhanov92 6 жыл бұрын
Well asking the question I think I answered myself - managerId can be NULL, but a managerId HAS TO be one and only one employeeId
@BattleFieldAllHands2022
@BattleFieldAllHands2022 4 жыл бұрын
Can you provide the slides for your lecture?
@Steve-zz5ds
@Steve-zz5ds 2 жыл бұрын
This series was highly recommended to supplement my DBMS course....but that microphone static in this video is incredibly distracting.
@ayca7401
@ayca7401 5 жыл бұрын
great explanation!
@NwankamaNwankama
@NwankamaNwankama 11 жыл бұрын
Excellent presentation
@ianlee9505
@ianlee9505 7 жыл бұрын
are these slideshows available anywhere for download?
@nickwoodward819
@nickwoodward819 5 жыл бұрын
Are the 'Hiking_Club'/'Sailing_Club' types poorly named? A club surely isn't a subtype. Wouldn't they be better as 'Hiking_Student' etc? I know I'm likely splitting hairs, but it helps me understand the concepts.
@nickwoodward819
@nickwoodward819 5 жыл бұрын
Great videos by the way, really helpful, although even in 2013 your microphone should be illegal :D
@dudet15951
@dudet15951 8 жыл бұрын
Great videos!
@popularcomments3272
@popularcomments3272 9 жыл бұрын
thank you dr for this amazing content
@Regalert
@Regalert 7 жыл бұрын
The guy is great!
@silmankhan5832
@silmankhan5832 9 жыл бұрын
thank you very much !! very clear tutorial
@TheAsimjan
@TheAsimjan 6 жыл бұрын
Thumbs up for u Sir. From where can I download these slides? If anyone knows please tell me as soon as possible
Database Lesson #5 of 8 - Database Design
50:11
Dr. Daniel Soper
Рет қаралды 225 М.
Database Lesson #1 of 8 - Introduction to Databases
38:43
Dr. Daniel Soper
Рет қаралды 1,2 МЛН
小丑教训坏蛋 #小丑 #天使 #shorts
00:49
好人小丑
Рет қаралды 54 МЛН
Master Data Modeling in Power BI - Beginner to Pro Full Course
2:09:21
Pragmatic Works
Рет қаралды 82 М.
Entity Relationship Diagrams
20:32
Decomplexify
Рет қаралды 2,4 М.
#01 - Relational Model & Algebra (CMU Intro to Database Systems)
1:23:38
CMU Database Group
Рет қаралды 23 М.
Entity Relationship Diagram (ERD) Training Video
15:04
Gina Baldazzi
Рет қаралды 1 МЛН
Database Lesson #3 of 8 - The Structured Query Language (SQL)
1:18:25
Dr. Daniel Soper
Рет қаралды 383 М.
Database Lesson #2 of 8 - The Relational Model
47:04
Dr. Daniel Soper
Рет қаралды 435 М.
Basic Entity Relationship Models
15:01
Jacob Schrum
Рет қаралды 12 М.