Wow an entire week of lecture summarized in just 5 minutes of a video on 2.5x speed. Thanks a lot, great work!
@zalkarn5 жыл бұрын
Right? This video made so much more sense to me than any college professor I've come across.
@ahmadby1004 жыл бұрын
how on earth did you get 2.5x on youtube?
@abhichakladar52794 жыл бұрын
@@ahmadby100 Video speed controller chrome extension
@darlingred60546 ай бұрын
My Workflow is as follows. See what professor is supposed to teach KZbin it Learn in 1/10th the time.
@falahrafi3 жыл бұрын
(0:39) STEP 1 : Mapping of Regular Entity Types (1:41) STEP 2 : Mapping of Weak Entity Types (2:49) STEP 3 : Mapping of Binary 1:1 Relationship Types (4:22) STEP 4 : Mapping of Binary 1:N Relationship Types (6:25) STEP 5 : Mapping of Binary M:N Relationship Types (8:43) Define the relationships (9:36) Create an actual database
@Skattarules3 жыл бұрын
This video is 10x better than my university professors lecture :D
@abduselamkoc57813 жыл бұрын
change your university and see dumbest one
@jcr11732 жыл бұрын
Biggest facts i've ever seen written
@HiruniAbeysekara-fl1ij3 күн бұрын
Actually, your lessons are of utmost important. Your teaching method is excellent as well. I notably say your explanations are so clear and easy to understand. Fantastically, you are offering a sound knowledge on IT to the whole world. Thank you so much from the bottom of my heart for your noble helping hand.💖💖💖
@kurtsmock30713 жыл бұрын
Best explanation of these concepts I've ever heard and I've been trying to get it for a while. Thanks. Teaching is clearly your calling.
@ahmedelsaadany88316 жыл бұрын
Hi Mike, really you are an excellent teacher, and perfect coder, your way is direct and extremely simple. if you please can you make a new series focused on practical and real projects. Many thanks . Ahmed
@ferenc34606 жыл бұрын
Yeah, that would be really good. Some real world project. Anyway I love your videos Mike. Thanks for sharing them for free!
@shubhampatil39045 жыл бұрын
Thanks buddy
@omnidye4 жыл бұрын
no one is a "perfect coder."
@alexandermotal59794 жыл бұрын
+1
@shashishekhar----3 жыл бұрын
@@omnidye get going before you have to hear something.
@aradaistanbul3 жыл бұрын
Thank you, I attended all the course it was really helpful. World needs people like you thanks for your time and your great way of teaching.
@user-ir2vf2nw6d2 жыл бұрын
I am Taiwanese, your course is very good, thanks for teaching!
@zhanybeksalgarin891810 ай бұрын
Amazing work guys! The way you made the whole loop, starting with the table schema in the low level and finishing the same schema in the hight level. Splendid! Thank you! I enjoyed the journey!
@wallacemarty5 жыл бұрын
Thanks for all that. I made a lot of notes and screen prints and now I'm going to create my own database. I expect to re-watch some sections a few times but the series has given me a good insight into SQL. Thanks!
@bangvu21279 ай бұрын
Thanks for summarising 2 lectures of 1 hour each in 10 mins, and way easier to grasp!!!
@raihantaher43085 жыл бұрын
You just cleared all the mess I had in my head.. Thanks for sharing these videos for free..
@ajo33002 жыл бұрын
Dude. This video and the tutorial before it helped me so much with my database class. Thank you!!!!
@lilmamagc2 жыл бұрын
Yay I finally completed the course!
@crisolivares78472 жыл бұрын
This course got me introduced to SQL and I am starting a Project right away!
@portiamixon9905 Жыл бұрын
I am currently taking an intro to data analytics class for my masters and your tutorials have helped me so much! You are an amazing teacher for newbies like me.
@yaraalsousi21242 жыл бұрын
I have finished today this tutorial, thank u a lot for all this detailed explanation!!!
@atillaselem48273 жыл бұрын
each video in this serie but esspecially the last three videos are the best i ve ever seen regarding ER Modeling in KZbin. can you recommend a intermediary - advanced book or resource for ER Modeling & DB Design? Thx indeed..
@vv91313 жыл бұрын
Thanks for making SQL learning easy for us Mike
@roseannemot84403 жыл бұрын
Really help me to complete my assignment. Great explanation
@yasina632 жыл бұрын
Same to you got it.
@fahadmomin11653 жыл бұрын
thank you so much bro i was scratching my head before on this topic now it's clear thanks again
@ShawkyJames2 жыл бұрын
6:30 This is wrong. We have two if you look closely, there is also an M:N relationship between Branch and Branch Supplier
@MrDaniel5602 жыл бұрын
the bestt! i love your tutorials they are the best :))) thankss
@babakazizi31472 жыл бұрын
Fabulous! God bless you!
@rafaelangelopiad89194 жыл бұрын
U saved us bro. we had system diagram projects and this 100% made everything clearer
@mykelroheys96353 жыл бұрын
thanks man you have no idea how this helped me
@JesuHena3 ай бұрын
Let me say Thank You for making life life getting easier !
@willswill81635 жыл бұрын
Thank you. After reading about entities and relations for two hours, this summed it all up perfectly!
@winnumber1013 жыл бұрын
one of the best explanations i've ever seen
@fabioPatroni5 жыл бұрын
Thank you very much for this videos! I have taken the codeacademy and the Alison courses before yours. I can say your videos were a way better, more simple and direct than theirs.
@FATTMONSTER5 жыл бұрын
Love the Office Database 😂😂
@ryanfox24782 жыл бұрын
lol, same here! p.s. turns out Mike attended Scranton University!
@aanyc.6198 Жыл бұрын
i have finished my homework because of this video after trying to find many videos Thank you so much. Better than my professor at uni who just read slides
@Edward-zr4bg4 жыл бұрын
Hey Mike your tutorials have been very helpful to me especially this one. If you have time can you make a video about converting more complex er diagrams to schema. Like with n-nary relationships and multivalue attributes and such that would be so great because your reasoning is very good and you explain very well.
@jiaweitan30664 жыл бұрын
You are so clear in your explanation!
@noname-oi1ei4 жыл бұрын
Excellent. Clearly understand what are you say. Please add ISA hyrachy mapping
@wadadafranck96943 жыл бұрын
thanks bro ur playing a great role to the entire world i real benefit from ur pieces
@sonamuhialdeen78663 жыл бұрын
Amazing tutorial
@rocketleague21363 жыл бұрын
this is good stuff! thank you Mike. I destroyed my head learning this via book
@beomseokpark15004 жыл бұрын
Thank you so much for making all videos! You are legend.
@Siddharth-uo6zw3 жыл бұрын
Thank u so much! can you make more advanced paid courses in SQL, Back end Developer with economical for students. you teach so well.
@edgardlucanagallegos17724 жыл бұрын
Hi Mike, thank you to take your time to do this course that is amazing.
@everboy1123 жыл бұрын
Good work. Very helpful
@Heckerschee3 жыл бұрын
Great video! 👍🏼👍🏼👍🏼
@mohamedsamuelkamara366111 ай бұрын
Thanks for the video, I just use it to take my examination it is really really helpful.
@IAmWaterr3 жыл бұрын
Thank you very much for explaining clearly
@PaxiKaksi5 жыл бұрын
How much i hate this subject :D Anyways thanks for the video. It was much easier than reading 120 slides
@jakkty39155 жыл бұрын
Thanks Mike for this professional Tutorial. Keep up the good work.
@sltech8374 жыл бұрын
wow bro excellent channel great work
@repotaps88992 жыл бұрын
Hi, if you have a 1:N relation should an attribute on that relation eg. price be included in the relation schema? And where if it should?
@muradsalameh52942 жыл бұрын
What about in the case that I have multiple partial keys in my weak entity? For example, my ER Diagram has the weak entity "Section", it has 3 partial keys, "Semester" "Year" and "Section #". The owner of this weak entity has the primary key as "Course #" The relationship between them is "HAS" and it's a many-to-many relationship. What would I put as my keys for this "HAS" table? Would it be Course# and all the other partial keys from "Section"? Or just Course# and Section#? Sorry if this is confusing but I'm super lost here. Thank you in advance!
@reachin4thetop709 Жыл бұрын
Wow Mike, I just wanted to say that you rock. Your teaching techniques are so easy to follow. Keep it up ma peep.
@ashokreddy29013 жыл бұрын
can you explain about the BCNF(Boyce-codd Nornal Form)?
@kramdjursbutiken10 ай бұрын
You're so cool Mike!
@ashrafulfuad29674 жыл бұрын
great explanation thanks Ziraff academy
@bigunhettiarachchi8532 жыл бұрын
Awesome. Thanks a lot It really helped me
@bananaboydan36425 ай бұрын
Good video but it'd be nice if you explained WHY we should always put the one table's PK as a FK in the many table
@yasina632 жыл бұрын
Yaw Mike am fan of you, watching from Maryland
@rukmanandareddyabbidi19943 жыл бұрын
it's really a great explaination
@gnidhi4103 жыл бұрын
What is if we have a terner relationship & not Binary? How to represent that?
@mukongshu3 жыл бұрын
As a beginner, I can imagine that I can even set everything on one table... if you don't worry about how messy it is, the reason it separtes to different small talbles, coz it would be easier to read
@kameraderz6 жыл бұрын
You're a great teacher, I really want to spend more of my time by watch and code along with your videos. Anyway, if you open a request, create Tableau tutorial would be amazing, I think. Okay that's all, keep it up the great work guys!
@sadgabe5 жыл бұрын
Thanks for helping me pass my database course
@mfurqanahmad6194 жыл бұрын
Hi Mike can you explain derived attribute in this example
@ezeuba001 Жыл бұрын
This was great lesson. Thanks a lot.
@esweee5 жыл бұрын
Hi Mike, I watched your 4 hour long vides over the weekend - they are so helpful and easily to follow. Thank you very much. As an frequent Excel user, do you have a video on, or know where I can find good information on, the Excel-like calculations? For example, what should if I want to add a column to an existing table, and populate the column use the product of Existing_Column_1 and Existing_Column_2. Thank you in advance.
@prathisahrudh5 жыл бұрын
6:30 there are actually two m:n relations
@hiruniliyanage985 жыл бұрын
prathi sahrudh the other one is a weak entity we mapped it already
@codingislife63872 жыл бұрын
Nice Sir Thanks Sir.
@raihanmomtaz76522 жыл бұрын
superb!! thanks
@mariyamashraf51995 жыл бұрын
Thank you soo much !! Super helpful
@krishnasahithikakunuri84272 жыл бұрын
Great help ✌️
@alfrediannegarciaquirante57614 жыл бұрын
thanks for the free mysql course mate
@dishansandasara82182 жыл бұрын
This is gold
@pratyakshamaheshwari82693 жыл бұрын
what to do 1 to 1 relationship when there is total and partial participation on both sides? please reply. Thank you.
@yacc83393 жыл бұрын
add pk of one table as fk on the other. doesn't matter what table.
@kiritmishra19984 жыл бұрын
you are amazing
@go_fuck_yourself4 жыл бұрын
Great video.
@mohammadsadikurrahman2591 Жыл бұрын
Question: Why didn't you make "Supplies" another table as it has a m:n relationship between Branch and Branch Supplier? Because you said if it's m:n relationship we gotta make a new table. Or is it because of it's weak entity type? I would appreciate any clarification. BTW amazing explanation. Awesome work!
@fasikawkindye68275 жыл бұрын
Thanks man You made my Database class simple
@carishmarahamathi9762 жыл бұрын
can you tell me what happen to age from Employee table and # of employees from Branch table. Those are derived attribute right?
@jatinverma67594 жыл бұрын
Hey Mike, thanks a lot for this. I also learned C from your channel. I wanted to know that what do I do now after finishing this course?
@limitless16925 жыл бұрын
Awesoem Playlist Great ending aswell ... is like back to the begining :)
@silenthive4 жыл бұрын
it would actually probably make more sense, if the background picture wouldnt be moved around so often, and instead putting a fixed view on it, as its hard to follow.
@vijayabharathi24095 жыл бұрын
Hi Mike, Thanks for the great video which clearly explains the relationships and the keys. I would like to know more about the foreign keys in case of ternary relationships ? Do you have any write-up or video on this ?
@monara973 жыл бұрын
does anyone know how he drew the relational model? I mean the software used ???
@rdwanbzzaze18135 жыл бұрын
Thank mike you've been very helpful
@Ivan-np3ls4 жыл бұрын
really helpful thank you
@unmmahrish3 жыл бұрын
Can you explain how to test database for my assignment I need that
@trungpham75884 жыл бұрын
excellent teacher !!!
@manuelaidos4 жыл бұрын
In 3 videos i learned more than an entire semester….
@winnumber1013 жыл бұрын
no cap
@unmmahrish3 жыл бұрын
What do you use to build database and table
@vectorhugo49975 жыл бұрын
Hey mike you are awesome,just you didn't mention multivalued attribute.
@bonoful43434 жыл бұрын
That was great!
@alimaydidthat Жыл бұрын
LIFE SAVER TY TY TY
@alex13ethiotube912 жыл бұрын
employ( empy id, last-name, first -name ,brith day , salary, sex,age, branch id) look branch id b/c money employee works for one branch .therefor there is FR key
@nilanga792 жыл бұрын
Hi, Do you have how this created in MS SQL?
@Ex-fk4nr5 жыл бұрын
What if we have a relation 1:N with r Total participation on the 1 side
@chintanpatel32765 жыл бұрын
Can you talk about generalization/specialization, aggregation and ternary relationship in your next video?