This video explores logical database design (a pre-cursor to physical database design) and demonstrates the use of Entity Relationship Diagrams.
Пікірлер: 140
@xorbite2 ай бұрын
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.
@amnest1ac4 жыл бұрын
This is by far the best video about E-R diagrams out there! Amazing work!
@BrianGreenNJ4 жыл бұрын
amnest1ac thank you! Kind words appreciated!
@abdulrahmanismailali1064 Жыл бұрын
@@BrianGreenNJ can you help me
@janmccoy46006 жыл бұрын
Your descriptions are eminently clear and accessible. This was just what I needed to begin with the analysis of a needed database. Well DONE!
@BrianGreenNJ4 жыл бұрын
Jan McCoy thank you!
@fredkzk3 жыл бұрын
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
@farzinkhaledi43942 жыл бұрын
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
@tutorb69756 жыл бұрын
Best video. I was struggling to understand other materials. This is helpful.
@anderlabaka32873 ай бұрын
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!!
@RitinderKaur-vi4in Жыл бұрын
Thank you for such a clear description. I would recommend this video for anyone interested in database designing and how it works!
@anqili36557 жыл бұрын
This is great!!! Super helpful for my course. Thank you Brian!
@sugars_nickels26527 жыл бұрын
All of the other comments are accurate! You are an awesome teacher Brian, very clear and concise. Thank you for this video!
@BrianGreenNJ4 жыл бұрын
Nicohle Herald-Lee thank you!!
@perx51712 жыл бұрын
Thank you Brian for providing best explanation. Appreciate your hardwork.
@mastermindrational19073 ай бұрын
Thank you this was helpful. The speed was perfect. The progression of topics was perfect. Very well put together.
@digigoliath4 жыл бұрын
Well explained & easy to understand. Thanks for a great video!
@victorarnault4 жыл бұрын
Really Nice video. I need to watch again and roll over again. That's soo important!
@luciolibanori8142 жыл бұрын
Anybody that uses Ayn Rand's Atlas Shrugged in an example deserves your subscription. ♥💪🌎
@Dfcameron134 жыл бұрын
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
@cydia00713 күн бұрын
true, rarely see employee in multiple departments...
@tahirsyed60114 жыл бұрын
Marvelous Lecture, thanks Brian
@ruggeddog31033 жыл бұрын
One of the best tut, i'm satisfied👏👏👏👏👏
@osoriomatucurane95116 ай бұрын
Absolutely awesome, crystal clear and informative. You are a legend!
@Jerrel.A Жыл бұрын
Topnotch effective explanation and walkthrough. It could be hours in length, but simplified to just half an hour.
@adavayya3 жыл бұрын
Thank you Brian. Very well explained. Very helpful.
@wanrongchua43334 жыл бұрын
thank you so much for your comprehensive explanation! :)
@jasterix4 жыл бұрын
Great video. It's the perfect intro to database design. thank you!
@BrianGreenNJ4 жыл бұрын
jasterix thank you!
@mucahidsener2 жыл бұрын
Incredible explanation. Thanks for the lesson.
@gulsarah77794 жыл бұрын
You explained GREAT!! Thanks very much
@reazulislam84464 жыл бұрын
GOOD VIDEO, HELPFUL, deserves praise period
@fierce43932 жыл бұрын
Been struggling the entire semester, wish if i had watch this video from the beginning to save my tears lol Thanks for this video!
@TheJavan123456 жыл бұрын
I love you.. this helped me so much. Please make more content because you're amazing at teaching
@blacknight44149 ай бұрын
The best tutorial about Logical Database Design
@OtRatsaphong4 жыл бұрын
Great video, Thank you 👍
@kamehameha5095 жыл бұрын
Well put video explaining ERDs and Database Logical Design.
@khabathasan17504 жыл бұрын
Thanks a lot for the explanation and making this helpful video.
@chinnalj4 жыл бұрын
Much appreciated. Thanks for the video
@jasonaranha11184 жыл бұрын
Nice Video really helpful in understanding the ER Diagram.
@fasiri-xj8qd5 жыл бұрын
Thankful this is so useful and easy understanding 👏🏻👏🏻👏🏻👏🏻
@archangel95823 жыл бұрын
Just what I need, thank you
@waltercatalfamo60284 жыл бұрын
Very great explanation! It'd be nice if you upload the presentation that you used in the video.
@andys69523 жыл бұрын
Really helpful. Great Video
@ibsu49613 жыл бұрын
Very good lecture.... Many thanks
@radovansurlak74454 жыл бұрын
Thank you Brian :)
@nanohetube Жыл бұрын
Great job done. Thanks for the video.
@bikramthapa26875 жыл бұрын
awesome video , thank you so much
@avenuech394 жыл бұрын
Nice voice to be glad to hear, and good presentation performance.Well done!
@annablaster3 ай бұрын
This video is sooo helpful. Im saving it.
@MauroDiBertPosta4 жыл бұрын
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!
@user-iu1sv4jr7z4 жыл бұрын
Excellent info.
@woodroofguy4 жыл бұрын
Good video. Thanks! New subscriber.
@mk98345 жыл бұрын
thank you sir!
@nileshtayshete74114 жыл бұрын
Nice I understood it in only one watch..
@SinskariBoi5guys662 жыл бұрын
Good tutorial for refreshing your knowledge
@thefuture991 Жыл бұрын
Thanks a lot for this. Hopefully this will help in my exam tomorrow.
@ryadelarbi86943 жыл бұрын
thank you this helped me a lot
@dealerfire84274 жыл бұрын
Well done.
@leo80leo807 жыл бұрын
This is called teaching!! Simple and Crystal Clear!! Kudos to you Brian. Brian - Do you have any videos on Dimensional modeling?
@BrianGreenNJ7 жыл бұрын
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.
@leo80leo807 жыл бұрын
thanks for the response.
@mydadshowering29782 жыл бұрын
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
@NazarAdamchuk4 жыл бұрын
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!
@aaklii3 жыл бұрын
He mentioned that there is error in the diagram. Each Model: Video, Book, Magazine will store FK for Media that is: mediaKey
@ofwlifevlogs67533 жыл бұрын
Good information thanks you for sharing
@mrhhh6938 ай бұрын
Thanks that was informative.
@sankethdhegde14715 жыл бұрын
Thank you
@oneman97233 жыл бұрын
exceptional lecture wooowwww
@sanjaypaudel32964 жыл бұрын
BRIAN IS A GREAT TEACHER
@BrianGreenNJ4 жыл бұрын
sanjay Paudel thank you!
@consciousrunning3 жыл бұрын
Thank you.
@alfredsfutterkiste75343 жыл бұрын
great video
@pagevpetty3 жыл бұрын
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
@ctgtraveller8663 жыл бұрын
i was having the same feelings, lol
@realchicagophill7 жыл бұрын
Unbelievable video. Thank You is there a playlist?
@BrianGreenNJ4 жыл бұрын
Phillip R Jorgensen yes... I have a playlist for MySQL, Oracle and Microsoft SQL Server. Very similar courses just geared to each RDBMS
@CareWithArsha3 жыл бұрын
Nice video, just subscribed you😍
@Epicgamerboy50004 жыл бұрын
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?
@BrianPondiGeoGeek3 жыл бұрын
Amazing
@raquelbuenoribeiro36133 жыл бұрын
Thank u :)
@thedembelecoder57766 жыл бұрын
thaaaaaankx
@csabraxas9 ай бұрын
How would foreign keys work with the Media books, videos and magazines example?
@alliedidentity22773 жыл бұрын
nice job
@rataraxia4 жыл бұрын
Excelent video. The mouse poniter though.....Ò_O
@bsratwelerufael39174 жыл бұрын
thanks
@joymixvlog3223 жыл бұрын
Great vdeo inspiring, New freind dropping my full support...hope to see you back thanks.
@chadpharris5 жыл бұрын
Ayn Rand! #StandWithRand. Great overview of ERD!
@nikki1230073 жыл бұрын
GOSH WHAT A RELIEF I GET IT NOW....
@Chobed Жыл бұрын
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...
@daviddonadze2215 жыл бұрын
thank u
@BrianGreenNJ5 жыл бұрын
You're welcome.
@joaom2246 жыл бұрын
Hello Brian, what is the program that you use to disign thisdiagrams that you show in the video. cheers
@BrianGreenNJ6 жыл бұрын
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.
@joaom2246 жыл бұрын
thanks you. I'm a computer engineering student and these tools help a lot
@akashtripathi59477 жыл бұрын
Brian Green: How to think in terms of business and make logical schema from scratch ?
@MegaTeaque3 жыл бұрын
INFO 365 3A Physical Database Design follows this video very well.
@vipinkoul91296 жыл бұрын
Do these PPT are available? It would be useful for quick revision. Can you please share?
@BrianGreenNJ6 жыл бұрын
I have the original ppt files I used, but I have no way to get them to you.
@vipinkoul91296 жыл бұрын
Pls share via google drive :) plizzzz ; really liked your way of explaining that you have done.
@jay_wright_thats_right5 ай бұрын
The vernacular is wrong. A tuple is a single RECORD (row). A single record consists of many ATTRIBUTES (columns).
@maazahmed88536 жыл бұрын
Hey Brian. Your Video is brilliant, I just need one help, can you recommend me a ERD designing software tool beside Microsoft Visio?
@BrianGreenNJ6 жыл бұрын
Maaz Ahmed I use draw.io which is free.
@maazahmed88536 жыл бұрын
Thankyou So much. you are a Life saver, may god bless you.
@balakk50094 жыл бұрын
I am searching for the physical design . Any one find plz share the URL
@jialusun78507 жыл бұрын
I would say the same
@carfan678955 жыл бұрын
Excellent, Better than my idiot proff
@aimanabdelraziq38652 жыл бұрын
Hey Brian, Nice work but playlists should be rearranged.
@sajakkhadka18206 жыл бұрын
It's like everybody is talking to their Brian .
@lucasmanuel32414 жыл бұрын
Great video, you made it look so easy! I would like to send you a message, how can I do that?
@BrianGreenNJ4 жыл бұрын
Lucas Heredia - bcg28 at Drexel dot Edu
@classicraceruk13373 жыл бұрын
I prefer UML to something like SSADM. UML matches well to Java and other OO databases designs
@BrianGreenNJ3 жыл бұрын
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.
@classicraceruk13373 жыл бұрын
@@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.
@mysterOrel79242 жыл бұрын
in 30 I review what i learned for 3 months at college !!!
@viks5994 жыл бұрын
what do u mean "a department can contain 0 or 1 employee" ? kzbin.info/www/bejne/kHPKiZVsa6iesJI
@HaiderAli-oi5fm3 жыл бұрын
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
@kreten7802 жыл бұрын
yeah I had the same thinking.
@thanosmrk Жыл бұрын
Maybe he ment the opposite? (An employee belongs to zero or one department & a department can have one or many employees)
@HaiderAli-oi5fm Жыл бұрын
@@thanosmrk yeah you're right. I got my answer long time ago. Anyway your comment will help newbies.
@iaintoolin16604 жыл бұрын
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
@ansm30136 жыл бұрын
Mim
@neuroglide68542 жыл бұрын
Camel case not camel back! :) Otherwise good stuff.
@ducmih2203 Жыл бұрын
what about many-many-many?
@BrianGreenNJ Жыл бұрын
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.