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