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.

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

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

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

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

Thank you for such a clear description. I would recommend this video for anyone interested in database designing and how it works!

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

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!

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

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

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

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

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

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!!

Marvelous Lecture, thanks Brian

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

Incredible explanation. Thanks for the lesson.

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!!

Thank you Brian. Very well explained. Very helpful.

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

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

thank you so much for your comprehensive explanation! :)

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

You explained GREAT!! Thanks very much

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

Nice Video really helpful in understanding the ER Diagram.

The best tutorial about Logical Database Design

GOOD VIDEO, HELPFUL, deserves praise period

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

Well put video explaining ERDs and Database Logical Design.

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

@BrianGreenNJ

4 жыл бұрын

jasterix thank you!

Very good lecture.... Many thanks

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

29 күн бұрын

true, rarely see employee in multiple departments...

Really helpful. Great Video

Great job done. Thanks for the video.

Much appreciated. Thanks for the video

Great video, Thank you 👍

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

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

This video is sooo helpful. Im saving it.

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

Good tutorial for refreshing your knowledge

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

Just what I need, thank you

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

Nice I understood it in only one watch..

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

Excellent info.

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

Thank you Brian :)

Good video. Thanks! New subscriber.

Thanks that was informative.

thank you this helped me a lot

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?

exceptional lecture wooowwww

Well done.

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!

@aaklii

3 жыл бұрын

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

great video

thank you sir!

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.

BRIAN IS A GREAT TEACHER

@BrianGreenNJ

4 жыл бұрын

sanjay Paudel thank you!

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

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

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

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

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

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

Amazing

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

Thank you.

nice job

Nice video, just subscribed you😍

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

Thank u :)

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.

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

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.

thaaaaaankx

Ayn Rand! #StandWithRand. Great overview of ERD!

thanks

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

Hey Brian, Nice work but playlists should be rearranged.

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

thank u

@BrianGreenNJ

5 жыл бұрын

You're welcome.

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

what do u mean "a department can contain 0 or 1 employee" ? kzread.info/dash/bejne/jHabusRvZqbRqpM.html

It's like everybody is talking to their Brian .

I would say the same

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.

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.

Excellent, Better than my idiot proff

how abt the foreign key yooo

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.

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

Camel case not camel back! :) Otherwise good stuff.

Mim