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
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!
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 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
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 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.
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.
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!
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
Thank you for such a clear description. I would recommend this video for anyone interested in database designing and how it works!
Best video. I was struggling to understand other materials. This is helpful.
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
Thank you Brian for providing best explanation. Appreciate your hardwork.
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!!
This is great!!! Super helpful for my course. Thank you Brian!
Thank you this was helpful. The speed was perfect. The progression of topics was perfect. Very well put together.
Absolutely awesome, crystal clear and informative. You are a legend!
Really Nice video.
I need to watch again and roll over again. That's soo important!
Topnotch effective explanation and walkthrough. It could be hours in length, but simplified to just half an hour.
Well explained & easy to understand. Thanks for a great video!
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...
Thank you Brian. Very well explained. Very helpful.
One of the best tut, i'm satisfied👏👏👏👏👏
Great video. It's the perfect intro to database design. thank you!
jasterix thank you!
GOOD VIDEO, HELPFUL, deserves praise period
Anybody that uses Ayn Rand's Atlas Shrugged in an example deserves your subscription. ♥💪🌎
Marvelous Lecture, thanks Brian
You explained GREAT!! Thanks very much
thank you so much for your comprehensive explanation! :)
I love you.. this helped me so much. Please make more content because you're amazing at teaching
Been struggling the entire semester, wish if i had watch this video from the beginning to save my tears lol Thanks for this video!
Incredible explanation. Thanks for the lesson.
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!
The best tutorial about Logical Database Design
Thanks a lot for the explanation and making this helpful video.
Much appreciated. Thanks for the video
Well put video explaining ERDs and Database Logical Design.
Great video, Thank you 👍
Nice Video really helpful in understanding the ER Diagram.
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
Just what I need, thank you
Thankful this is so useful and easy understanding 👏🏻👏🏻👏🏻👏🏻
Very great explanation! It'd be nice if you upload the presentation that you used in the video.
Great job done.
Thanks for the video.
Very good lecture.... Many thanks
Really helpful. Great Video
This video is sooo helpful. Im saving it.
Thank you Brian :)
awesome video , thank you so much
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 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
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.
Thanks a lot for this. Hopefully this will help in my exam tomorrow.
Nice voice to be glad to hear, and good presentation performance.Well done!
thank you sir!
Excellent info.
Good video. Thanks! New subscriber.
thank you this helped me a lot
Good tutorial for refreshing your knowledge
Nice I understood it in only one watch..
Thanks that was informative.
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
Well done.
Good information thanks you for sharing
Thank you.
Thank you
exceptional lecture wooowwww
great video
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
Nice video, just subscribed you😍
How would foreign keys work with the Media books, videos and magazines example?
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
thaaaaaankx
Ayn Rand! #StandWithRand. Great overview of ERD!
BRIAN IS A GREAT TEACHER
sanjay Paudel thank you!
Thank u :)
Amazing
Excelent video. The mouse poniter though.....Ò_O
Great vdeo inspiring,
New freind dropping my full support...hope to see you back thanks.
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.
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...
thanks
GOSH WHAT A RELIEF I GET IT NOW....
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.
nice job
INFO 365 3A Physical Database Design follows this video very well.
Brian Green: How to think in terms of business and make logical schema from scratch
?
I am searching for the physical design .
Any one find plz share the URL
The vernacular is wrong. A tuple is a single RECORD (row). A single record consists of many ATTRIBUTES (columns).
thank u
You're welcome.
It's like everybody is talking to their Brian .
Hey Brian, Nice work but playlists should be rearranged.
I would say the same
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
Excellent, Better than my idiot proff
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.
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.
in 30 I review what i learned for 3 months at college !!!
what do u mean "a department can contain 0 or 1 employee" ?
ruclips.net/video/ZBgXb66Ckz0/видео.html
Mim
how abt the foreign key yooo
Camel case not camel back! :) Otherwise good stuff.
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.