Logical Database Design and E-R Diagrams

Рет қаралды 369,074

8 жыл бұрын

This video explores logical database design (a pre-cursor to physical database design) and demonstrates the use of Entity Relationship Diagrams.

Пікірлер: 140

@xorbite 2 ай бұрын

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.

@amnest1ac 4 жыл бұрын

This is by far the best video about E-R diagrams out there! Amazing work!

@BrianGreenNJ 4 жыл бұрын

amnest1ac thank you! Kind words appreciated!

@abdulrahmanismailali1064 Жыл бұрын

@@BrianGreenNJ can you help me

@fredkzk 3 жыл бұрын

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

@janmccoy4600 6 жыл бұрын

Your descriptions are eminently clear and accessible. This was just what I needed to begin with the analysis of a needed database. Well DONE!

@BrianGreenNJ 4 жыл бұрын

Jan McCoy thank you!

@farzinkhaledi4394 2 жыл бұрын

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

@anderlabaka3287 3 ай бұрын

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!

@tutorb6975 6 жыл бұрын

Best video. I was struggling to understand other materials. This is helpful.

@mastermindrational1907 3 ай бұрын

Thank you this was helpful. The speed was perfect. The progression of topics was perfect. Very well put together.

@anqili3655 7 жыл бұрын

This is great!!! Super helpful for my course. Thank you Brian!

@perx5171 2 жыл бұрын

Thank you Brian for providing best explanation. Appreciate your hardwork.

@sugars_nickels2652 7 жыл бұрын

All of the other comments are accurate! You are an awesome teacher Brian, very clear and concise. Thank you for this video!

@BrianGreenNJ 4 жыл бұрын

Nicohle Herald-Lee thank you!!

@luciolibanori814 2 жыл бұрын

Anybody that uses Ayn Rand's Atlas Shrugged in an example deserves your subscription. ♥💪🌎

@osoriomatucurane9511 6 ай бұрын

Absolutely awesome, crystal clear and informative. You are a legend!

@digigoliath 4 жыл бұрын

Well explained & easy to understand. Thanks for a great video!

@victorarnault 4 жыл бұрын

Really Nice video. I need to watch again and roll over again. That's soo important!

@Jerrel.A Жыл бұрын

Topnotch effective explanation and walkthrough. It could be hours in length, but simplified to just half an hour.

@ruggeddog3103 3 жыл бұрын

One of the best tut, i'm satisfied👏👏👏👏👏

@adavayya 3 жыл бұрын

Thank you Brian. Very well explained. Very helpful.

@fierce4393 2 жыл бұрын

Been struggling the entire semester, wish if i had watch this video from the beginning to save my tears lol Thanks for this video!

@tahirsyed6011 4 жыл бұрын

Marvelous Lecture, thanks Brian

@jasterix 4 жыл бұрын

Great video. It's the perfect intro to database design. thank you!

@BrianGreenNJ 4 жыл бұрын

jasterix thank you!

@gulsarah7779 4 жыл бұрын

You explained GREAT!! Thanks very much

@mucahidsener 2 жыл бұрын

Incredible explanation. Thanks for the lesson.

@reazulislam8446 4 жыл бұрын

GOOD VIDEO, HELPFUL, deserves praise period

@wanrongchua4333 4 жыл бұрын

thank you so much for your comprehensive explanation! :)

@Dfcameron13 4 жыл бұрын

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

@cydia007 12 күн бұрын

true, rarely see employee in multiple departments...

@blacknight4414 9 ай бұрын

The best tutorial about Logical Database Design

@TheJavan12345 6 жыл бұрын

I love you.. this helped me so much. Please make more content because you're amazing at teaching

@khabathasan1750 4 жыл бұрын

Thanks a lot for the explanation and making this helpful video.

@jasonaranha1118 4 жыл бұрын

Nice Video really helpful in understanding the ER Diagram.

@chinnalj 4 жыл бұрын

Much appreciated. Thanks for the video

@OtRatsaphong 4 жыл бұрын

Great video, Thank you 👍

@kamehameha509 5 жыл бұрын

Well put video explaining ERDs and Database Logical Design.

@MauroDiBertPosta 4 жыл бұрын

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!

@annablaster 3 ай бұрын

This video is sooo helpful. Im saving it.

@andys6952 3 жыл бұрын

Really helpful. Great Video

@nanohetube Жыл бұрын

Great job done. Thanks for the video.

@fasiri-xj8qd 5 жыл бұрын

Thankful this is so useful and easy understanding 👏🏻👏🏻👏🏻👏🏻

@ibsu4961 3 жыл бұрын

Very good lecture.... Many thanks

@waltercatalfamo6028 4 жыл бұрын

Very great explanation! It'd be nice if you upload the presentation that you used in the video.

@archangel9582 3 жыл бұрын

Just what I need, thank you

@bikramthapa2687 5 жыл бұрын

awesome video , thank you so much

@NazarAdamchuk 4 жыл бұрын

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!

@aaklii 3 жыл бұрын

He mentioned that there is error in the diagram. Each Model: Video, Book, Magazine will store FK for Media that is: mediaKey

@thefuture991 Жыл бұрын

Thanks a lot for this. Hopefully this will help in my exam tomorrow.

@radovansurlak7445 4 жыл бұрын

Thank you Brian :)

@SinskariBoi5guys66 2 жыл бұрын

Good tutorial for refreshing your knowledge

@woodroofguy 4 жыл бұрын

Good video. Thanks! New subscriber.

@avenuech39 4 жыл бұрын

Nice voice to be glad to hear, and good presentation performance.Well done!

@user-iu1sv4jr7z 4 жыл бұрын

Excellent info.

@mydadshowering2978 2 жыл бұрын

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

@nileshtayshete7411 4 жыл бұрын

Nice I understood it in only one watch..

@ofwlifevlogs6753 3 жыл бұрын

Good information thanks you for sharing

@ryadelarbi8694 3 жыл бұрын

thank you this helped me a lot

@mk9834 5 жыл бұрын

thank you sir!

@mrhhh693 8 ай бұрын

Thanks that was informative.

@dealerfire8427 4 жыл бұрын

Well done.

@realchicagophill 7 жыл бұрын

Unbelievable video. Thank You is there a playlist?

@BrianGreenNJ 4 жыл бұрын

Phillip R Jorgensen yes... I have a playlist for MySQL, Oracle and Microsoft SQL Server. Very similar courses just geared to each RDBMS

@leo80leo80 7 жыл бұрын

This is called teaching!! Simple and Crystal Clear!! Kudos to you Brian. Brian - Do you have any videos on Dimensional modeling?

@BrianGreenNJ 7 жыл бұрын

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.

@leo80leo80 7 жыл бұрын

thanks for the response.

@consciousrunning 3 жыл бұрын

Thank you.

@oneman9723 3 жыл бұрын

exceptional lecture wooowwww

@sanjaypaudel3296 4 жыл бұрын

BRIAN IS A GREAT TEACHER

@BrianGreenNJ 4 жыл бұрын

sanjay Paudel thank you!

@sankethdhegde1471 5 жыл бұрын

Thank you

@pagevpetty 3 жыл бұрын

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

@ctgtraveller866 3 жыл бұрын

i was having the same feelings, lol

@alfredsfutterkiste7534 3 жыл бұрын

great video

@Epicgamerboy5000 4 жыл бұрын

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?

@CareWithArsha 3 жыл бұрын

Nice video, just subscribed you😍

@BrianPondiGeoGeek 3 жыл бұрын

Amazing

@joaom224 6 жыл бұрын

Hello Brian, what is the program that you use to disign thisdiagrams that you show in the video. cheers

@BrianGreenNJ 6 жыл бұрын

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.

@joaom224 6 жыл бұрын

thanks you. I'm a computer engineering student and these tools help a lot

@thedembelecoder5776 6 жыл бұрын

thaaaaaankx

@raquelbuenoribeiro3613 3 жыл бұрын

Thank u :)

@joymixvlog322 3 жыл бұрын

Great vdeo inspiring, New freind dropping my full support...hope to see you back thanks.

@alliedidentity2277 3 жыл бұрын

nice job

@rataraxia 4 жыл бұрын

Excelent video. The mouse poniter though.....Ò_O

@maazahmed8853 6 жыл бұрын

Hey Brian. Your Video is brilliant, I just need one help, can you recommend me a ERD designing software tool beside Microsoft Visio?

@BrianGreenNJ 6 жыл бұрын

Maaz Ahmed I use draw.io which is free.

@maazahmed8853 6 жыл бұрын

Thankyou So much. you are a Life saver, may god bless you.

@bsratwelerufael3917 4 жыл бұрын

thanks

@csabraxas 9 ай бұрын

How would foreign keys work with the Media books, videos and magazines example?

@chadpharris 5 жыл бұрын

Ayn Rand! #StandWithRand. Great overview of ERD!

@vipinkoul9129 6 жыл бұрын

Do these PPT are available? It would be useful for quick revision. Can you please share?

@BrianGreenNJ 6 жыл бұрын

I have the original ppt files I used, but I have no way to get them to you.

@vipinkoul9129 6 жыл бұрын

Pls share via google drive :) plizzzz ; really liked your way of explaining that you have done.

@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...

@MegaTeaque 3 жыл бұрын

INFO 365 3A Physical Database Design follows this video very well.

@nikki123007 3 жыл бұрын

GOSH WHAT A RELIEF I GET IT NOW....

@daviddonadze221 5 жыл бұрын

thank u

@BrianGreenNJ 5 жыл бұрын

You're welcome.

@akashtripathi5947 7 жыл бұрын

Brian Green: How to think in terms of business and make logical schema from scratch ?

@jay_wright_thats_right 5 ай бұрын

The vernacular is wrong. A tuple is a single RECORD (row). A single record consists of many ATTRIBUTES (columns).

@mysterOrel7924 2 жыл бұрын

in 30 I review what i learned for 3 months at college !!!

@aimanabdelraziq3865 2 жыл бұрын

Hey Brian, Nice work but playlists should be rearranged.

@balakk5009 4 жыл бұрын

I am searching for the physical design . Any one find plz share the URL

@jialusun7850 7 жыл бұрын

I would say the same

@sajakkhadka1820 6 жыл бұрын

It's like everybody is talking to their Brian .

@lucasmanuel3241 4 жыл бұрын

Great video, you made it look so easy! I would like to send you a message, how can I do that?

@BrianGreenNJ 4 жыл бұрын

Lucas Heredia - bcg28 at Drexel dot Edu

@carfan67895 5 жыл бұрын

Excellent, Better than my idiot proff

@classicraceruk1337 3 жыл бұрын

I prefer UML to something like SSADM. UML matches well to Java and other OO databases designs

@BrianGreenNJ 3 жыл бұрын

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.

@classicraceruk1337 3 жыл бұрын

@@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.

@iaintoolin1660 4 жыл бұрын

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

@HaiderAli-oi5fm 3 жыл бұрын

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

@kreten780 2 жыл бұрын

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.

@viks599 4 жыл бұрын

what do u mean "a department can contain 0 or 1 employee" ? kzfaq.info/get/bejne/kKiXi8Vnm6nPqmQ.html

@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.