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!
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!
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.
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.
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.
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
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
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!
each video in this serie but esspecially the last three videos are the best i ve ever seen regarding ER Modeling in RU-vid. can you recommend a intermediary - advanced book or resource for ER Modeling & DB Design? Thx indeed..
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 ?
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.
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!
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
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!