Even 7 years later, and this is still very relevant. Thank you so much for making this detailed explanation about ERDs. This is by far one of the best explanation videos I have found about this subject.
you are absolutely amazing at teaching Brian, thank you so much for the great tutorial I have learnt more from this tutorial than 3 months of going to the University and studying the same subject
Thanks to your clear tuto about relationships, I figured out the type I needed for my diagram. As far as I understand you are teaching, your students are lucky. Although, I kept moving my mouse throughout the course thinking the annoying cursor on the screen was mine LOL! :D
I know NOTHING about databases (although I'll have to learn for work), and this was super useful and incredibly easy to follow. Great content, thank you!!
Excellent video. Shows a clear way to think about this topic along with glimpses into different notation options. Very easy to follow. I did get hung up briefly on “an employee can be in many departments”. That’s not true for anyplace I’ve worked - yet it only slowed me down briefly. The rest is a lucid intro that makes intuitive sense
Thanks you Brian !! I a love this video and it will be instrumental in my success in an exam which I will be taking on May the 25th, 2022 !!! :D :D :DDDDDDDD :D
Brian! Hi! It was an awesome material and I was searching for a full course on DB and found that you have organized by number. I assume you teach this in Universities or something like that. Is there any possibility to get access to that 365 course? Thanks for this material again!
Thank you! I do not have any OLAP lectures online yet... but it is something I have considered. Until now, the field has been a moving target for undergrad courses... but I think standard practices are starting to settle in.
Hello Brian, very useful video for the start of my Ph.D.! I would like to ask you about the diagram at 21:38. Would be correct to use for three of derived tables video, book, ans magazine the primary key (and simulatiously, foreign key) - mediaKey, wouldn't be? Thanks for your answer and regards from Germany!
Thanks for your informative video! I appreciate the diagrams, but I kept trying to move my cursor out of the way and realized it was yours, not mine. LOL
Class diagrams are not generally used for database design. The concept of behavior/method, visibility, stereotypes, etc. has no context in databases. However, persistent classes in UML class diagrams can inform the database design. Also, class diagrams are not typically normalized; when they are ported to relations, they need to be normalized. My UML class diagrams videos explain more about how class diagrams are used in systems analysis and design.
@@BrianGreenNJ True it’s how I modelled a system way back in 2000 in my degree. It covers Object Models, Classes,Use cases, Actors etc. The final design was used the next year for a project to build the database. This was still in use at least 3 years after it was built. So the Objects were built, the attributes stored, the use cases programmed etc. Of course as it was just the design and not the implementation model it had to be adapted to work in Java. It matched pretty well.
GOOD VIDEO: Speaking as a member of the Peoples Popular Front against the Vilification of 'nulls' ... Nulls can be legitimate when there is latency between creating an entity with a latency on getting the full data. The trick is normalise the data and treat nulls as data that is unknown, but pending. Defaults can be used if necessary
Hey maybe you stated it in wrong way or I'm not getting it at 24:14. Should not it be like this way "An employee can exist in one or many departments and a department can have one or many employees". Because if department have zero employee then that means that department does not exist. Please somebody clear it to me
I believed that’s addressed in this video. The physical database, if it’s relational, can not have many-to-many relationships. There is a section that shows how an additional table must be added to support logical many-to-many relationships.
![[UNCUT] “เชื่อมจิต” ใกล้จนมุม อนันต์ชัยเปิดตัวละครลับ เตรียมล้างบาง I คนดังนั่งเคลียร์ l 2 ก.ค.67](http://i.ytimg.com/vi/jeOwG0vt114/mqdefault.jpg)
Even 7 years later, and this is still very relevant. Thank you so much for making this detailed explanation about ERDs. This is by far one of the best explanation videos I have found about this subject.
Thank you for such a clear description. I would recommend this video for anyone interested in database designing and how it works!
Your descriptions are eminently clear and accessible. This was just what I needed to begin with the analysis of a needed database. Well DONE!
Jan McCoy thank you!
Thank you Brian for providing best explanation. Appreciate your hardwork.
you are absolutely amazing at teaching Brian,
thank you so much for the great tutorial
I have learnt more from this tutorial than 3 months of going to the University and studying the same subject
This is great!!! Super helpful for my course. Thank you Brian!
Best video. I was struggling to understand other materials. This is helpful.
Thanks to your clear tuto about relationships, I figured out the type I needed for my diagram. As far as I understand you are teaching, your students are lucky.
Although, I kept moving my mouse throughout the course thinking the annoying cursor on the screen was mine LOL! :D
This is by far the best video about E-R diagrams out there! Amazing work!
amnest1ac thank you! Kind words appreciated!
@@BrianGreenNJ can you help me
Absolutely awesome, crystal clear and informative. You are a legend!
Thank you this was helpful. The speed was perfect. The progression of topics was perfect. Very well put together.
Well explained & easy to understand. Thanks for a great video!
Really Nice video.
I need to watch again and roll over again. That's soo important!
I know NOTHING about databases (although I'll have to learn for work), and this was super useful and incredibly easy to follow. Great content, thank you!!
All of the other comments are accurate! You are an awesome teacher Brian, very clear and concise. Thank you for this video!
Nicohle Herald-Lee thank you!!
Topnotch effective explanation and walkthrough. It could be hours in length, but simplified to just half an hour.
Thank you Brian. Very well explained. Very helpful.
Marvelous Lecture, thanks Brian
GOOD VIDEO, HELPFUL, deserves praise period
You explained GREAT!! Thanks very much
One of the best tut, i'm satisfied👏👏👏👏👏
thank you so much for your comprehensive explanation! :)
The best tutorial about Logical Database Design
Incredible explanation. Thanks for the lesson.
Great video. It's the perfect intro to database design. thank you!
jasterix thank you!
I love you.. this helped me so much. Please make more content because you're amazing at teaching
Anybody that uses Ayn Rand's Atlas Shrugged in an example deserves your subscription. ♥💪🌎
Thanks a lot for the explanation and making this helpful video.
Much appreciated. Thanks for the video
Been struggling the entire semester, wish if i had watch this video from the beginning to save my tears lol Thanks for this video!
Just what I need, thank you
This video is sooo helpful. Im saving it.
Great video, Thank you 👍
Excellent video. Shows a clear way to think about this topic along with glimpses into different notation options. Very easy to follow. I did get hung up briefly on “an employee can be in many departments”. That’s not true for anyplace I’ve worked - yet it only slowed me down briefly. The rest is a lucid intro that makes intuitive sense
true, rarely see employee in multiple departments...
Nice Video really helpful in understanding the ER Diagram.
Great job done.
Thanks for the video.
Very good lecture.... Many thanks
Well put video explaining ERDs and Database Logical Design.
Thankful this is so useful and easy understanding 👏🏻👏🏻👏🏻👏🏻
Really helpful. Great Video
awesome video , thank you so much
Thanks you Brian !! I a love this video and it will be instrumental in my success in an exam which I will be taking on May the 25th, 2022 !!! :D :D :DDDDDDDD :D
Thanks a lot for this. Hopefully this will help in my exam tomorrow.
Very great explanation! It'd be nice if you upload the presentation that you used in the video.
Thank you Brian :)
thank you this helped me a lot
Good tutorial for refreshing your knowledge
Nice I understood it in only one watch..
thank you sir!
Thanks that was informative.
Excellent info.
Thank you
Thank you.
Good video. Thanks! New subscriber.
Nice voice to be glad to hear, and good presentation performance.Well done!
exceptional lecture wooowwww
Well done.
Brian! Hi! It was an awesome material and I was searching for a full course on DB and found that you have organized by number. I assume you teach this in Universities or something like that. Is there any possibility to get access to that 365 course? Thanks for this material again!
Good information thanks you for sharing
great video
This is called teaching!! Simple and Crystal Clear!!
Kudos to you Brian.
Brian - Do you have any videos on Dimensional modeling?
Thank you!
I do not have any OLAP lectures online yet... but it is something I have considered. Until now, the field has been a moving target for undergrad courses... but I think standard practices are starting to settle in.
thanks for the response.
Hello Brian, very useful video for the start of my Ph.D.! I would like to ask you about the diagram at 21:38. Would be correct to use for three of derived tables video, book, ans magazine the primary key (and simulatiously, foreign key) - mediaKey, wouldn't be? Thanks for your answer and regards from Germany!
He mentioned that there is error in the diagram.
Each Model: Video, Book, Magazine will store FK for Media that is: mediaKey
BRIAN IS A GREAT TEACHER
sanjay Paudel thank you!
Unbelievable video. Thank You is there a playlist?
Phillip R Jorgensen yes... I have a playlist for MySQL, Oracle and Microsoft SQL Server. Very similar courses just geared to each RDBMS
Thank u :)
Amazing
Thanks for your informative video! I appreciate the diagrams, but I kept trying to move my cursor out of the way and realized it was yours, not mine. LOL
i was having the same feelings, lol
You mentioned you have a video on how to use Microsoft Visio but I don't see it on your channel. Did you take it down?
thanks
thaaaaaankx
nice job
Nice video, just subscribed you😍
GOSH WHAT A RELIEF I GET IT NOW....
Ayn Rand! #StandWithRand. Great overview of ERD!
INFO 365 3A Physical Database Design follows this video very well.
thank u
You're welcome.
Brian Green: How to think in terms of business and make logical schema from scratch
?
Excelent video. The mouse poniter though.....Ò_O
Hello Brian, what is the program that you use to disign thisdiagrams that you show in the video.
cheers
joaom224 this is all just creative use of PowerPoint :-).
Normally I would use Visio 2013 or draw.io which is a free web based tool.
thanks you. I'm a computer engineering student and these tools help a lot
How would foreign keys work with the Media books, videos and magazines example?
Hi.. I´m just learning.. sorry if its a dumb question. How do you link the table Media with one of the types of media? you didn't add an FK...
in 30 I review what i learned for 3 months at college !!!
The vernacular is wrong. A tuple is a single RECORD (row). A single record consists of many ATTRIBUTES (columns).
Great vdeo inspiring,
New freind dropping my full support...hope to see you back thanks.
Hey Brian, Nice work but playlists should be rearranged.
Do these PPT are available? It would be useful for quick revision. Can you please share?
I have the original ppt files I used, but I have no way to get them to you.
Pls share via google drive :) plizzzz ; really liked your way of explaining that you have done.
I would say the same
Hey Brian. Your Video is brilliant, I just need one help, can you recommend me a ERD designing software tool beside Microsoft Visio?
Maaz Ahmed I use draw.io which is free.
Thankyou So much. you are a Life saver, may god bless you.
I am searching for the physical design .
Any one find plz share the URL
It's like everybody is talking to their Brian .
I prefer UML to something like SSADM. UML matches well to Java and other OO databases designs
Class diagrams are not generally used for database design.
The concept of behavior/method, visibility, stereotypes, etc. has no context in databases.
However, persistent classes in UML class diagrams can inform the database design. Also, class diagrams are not typically normalized; when they are ported to relations, they need to be normalized.
My UML class diagrams videos explain more about how class diagrams are used in systems analysis and design.
@@BrianGreenNJ True it’s how I modelled a system way back in 2000 in my degree. It covers Object Models, Classes,Use cases, Actors etc. The final design was used the next year for a project to build the database. This was still in use at least 3 years after it was built. So the Objects were built, the attributes stored, the use cases programmed etc. Of course as it was just the design and not the implementation model it had to be adapted to work in Java. It matched pretty well.
Excellent, Better than my idiot proff
Great video, you made it look so easy! I would like to send you a message, how can I do that?
Lucas Heredia - bcg28 at Drexel dot Edu
GOOD VIDEO: Speaking as a member of the Peoples Popular Front against the Vilification of 'nulls' ... Nulls can be legitimate when there is latency between creating an entity with a latency on getting the full data. The trick is normalise the data and treat nulls as data that is unknown, but pending. Defaults can be used if necessary
Hey maybe you stated it in wrong way or I'm not getting it at 24:14. Should not it be like this way "An employee can exist in one or many departments and a department can have one or many employees". Because if department have zero employee then that means that department does not exist. Please somebody clear it to me
yeah I had the same thinking.
Maybe he ment the opposite? (An employee belongs to zero or one department & a department can have one or many employees)
@@thanosmrk yeah you're right. I got my answer long time ago. Anyway your comment will help newbies.
what do u mean "a department can contain 0 or 1 employee" ?
th-cam.com/video/ZBgXb66Ckz0/w-d-xo.html
what about many-many-many?
I believed that’s addressed in this video. The physical database, if it’s relational, can not have many-to-many relationships. There is a section that shows how an additional table must be added to support logical many-to-many relationships.
Camel case not camel back! :) Otherwise good stuff.
Mim
how abt the foreign key yooo