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!
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.💖💖💖
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!
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.
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
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.
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
each video in this serie but esspecially the last three videos are the best i ve ever seen regarding ER Modeling in TH-cam. can you recommend a intermediary - advanced book or resource for ER Modeling & DB Design? Thx indeed..
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
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.
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!
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.
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.
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
Ma.ye Ha., [4/5/2022 3:45 PM] A company has organized its activities in projects. Each project has a name and is run at a specific location. Unfortunately, there are several projects with the same name-it may even be the case that two projects with the same name are run at the same location. Each project has a telephone, which is shared if there is more than one project at the same location. Each project has a boss, who is one of the employees of the company. Each company employee has a person number, address and telephone number. Many of the employees have several telephone numbers (office telephone, cellular 1, cellular 2₁. ). The employees work in the projects, most of them in more than one project. 1 each such "project employment" starts at a specific date and ends at another date (the end date of current project employments is unknown). Task: 1 Convert ER schema to Relational schema Time allowed: 2 hr. Instruction: Under this task the candidate is expected to perform activities (Cotion Design E-R diagram and identify the cardinality and constraints of database • Identify Functional Dependency. . Convert the ER schema to relational schema 2 & Assessment Assurance please view and work by a few days i want the answer of this questions
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!
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 ?
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!
Hey Mike, awesome work! I really do appreciate your effort. How did you create those diagrams and tables? I mean how did you visualized it, is there any function at PopSQL to transform data into tables and diagrams? Thank you in advance for your help!
Wow an entire week of lecture summarized in just 5 minutes of a video on 2.5x speed. Thanks a lot, great work!
Right? This video made so much more sense to me than any college professor I've come across.
how on earth did you get 2.5x on youtube?
@@ahmadby100 Video speed controller chrome extension
My Workflow is as follows.
See what professor is supposed to teach
TH-cam it
Learn in 1/10th the time.
(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
This video is 10x better than my university professors lecture :D
change your university and see dumbest one
Biggest facts i've ever seen written
I am Taiwanese, your course is very good, thanks for teaching!
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.
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.
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!
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.💖💖💖
Thanks for summarising 2 lectures of 1 hour each in 10 mins, and way easier to grasp!!!
6:30 This is wrong. We have two if you look closely, there is also an M:N relationship between Branch and Branch Supplier
You just cleared all the mess I had in my head.. Thanks for sharing these videos for free..
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!
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.
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
Yeah, that would be really good. Some real world project. Anyway I love your videos Mike. Thanks for sharing them for free!
Thanks buddy
no one is a "perfect coder."
+1
@@omnidye get going before you have to hear something.
one of the best explanations i've ever seen
Thanks for making SQL learning easy for us Mike
Thank you. After reading about entities and relations for two hours, this summed it all up perfectly!
I have finished today this tutorial, thank u a lot for all this detailed explanation!!!
This course got me introduced to SQL and I am starting a Project right away!
Dude. This video and the tutorial before it helped me so much with my database class. Thank you!!!!
U saved us bro. we had system diagram projects and this 100% made everything clearer
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.
Love the Office Database 😂😂
lol, same here! p.s. turns out Mike attended Scranton University!
6:30 there are actually two m:n relations
prathi sahrudh the other one is a weak entity we mapped it already
Fabulous!
God bless you!
Yay I finally completed the course!
You are so clear in your explanation!
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
thank you so much bro i was scratching my head before on this topic now it's clear thanks again
Really help me to complete my assignment. Great explanation
Same to you got it.
thanks man you have no idea how this helped me
the bestt! i love your tutorials they are the best :))) thankss
each video in this serie but esspecially the last three videos are the best i ve ever seen regarding ER Modeling in TH-cam. can you recommend a intermediary - advanced book or resource for ER Modeling & DB Design? Thx indeed..
Thanks Mike for this professional Tutorial. Keep up the good work.
Hi Mike, thank you to take your time to do this course that is amazing.
thanks bro ur playing a great role to the entire world i real benefit from ur pieces
Let me say Thank You for making life life getting easier !
Thank you so much for making all videos!
You are legend.
this is good stuff! thank you Mike. I destroyed my head learning this via book
Excellent. Clearly understand what are you say. Please add ISA hyrachy mapping
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
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.
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!
can you tell me what happen to age from Employee table and # of employees from Branch table. Those are derived attribute right?
Yaw Mike am fan of you, watching from Maryland
Great video! 👍🏼👍🏼👍🏼
Can you explain how to test database for my assignment I need that
can you explain about the BCNF(Boyce-codd Nornal Form)?
Nice Sir Thanks Sir.
How much i hate this subject :D Anyways thanks for the video. It was much easier than reading 120 slides
Hi Mike can you explain derived attribute in this example
Wow Mike, I just wanted to say that you rock. Your teaching techniques are so easy to follow. Keep it up ma peep.
Good work. Very helpful
What do you use to build database and table
wow bro excellent channel great work
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.
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?
What is if we have a terner relationship & not Binary? How to represent that?
Thank u so much!
can you make more advanced paid courses in SQL, Back end Developer with economical for students.
you teach so well.
great explanation thanks
Ziraff academy
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 the start_date?
Awesome.
Thanks a lot
It really helped me
Amazing tutorial
Thank you very much for explaining clearly
Hi, Do you have how this created in MS SQL?
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?
superb!! thanks
Thanks for helping me pass my database course
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
Thank you soo much !! Super helpful
In 3 videos i learned more than an entire semester….
no cap
this was a huge help tbh. Normalization video next please
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
Thanks man You made my Database class simple
Great help ✌️
Thanks for the video, I just use it to take my examination it is really really helpful.
Ma.ye Ha., [4/5/2022 3:45 PM]
A company has organized its activities in projects. Each project has a name and is run at a specific location. Unfortunately, there are several projects with the same name-it may even be the case that two projects with the same name are run at the same location.
Each project has a telephone, which is shared if there is more than one project at the same location. Each project has a boss, who is one of the employees of the company. Each company employee has a person number, address and telephone number. Many of the employees have several telephone numbers (office telephone, cellular 1, cellular 2₁. ). The employees work in the projects, most of them in more than one project. 1 each such "project employment" starts at a specific date and ends at another date (the end date of current project employments is unknown).
Task: 1 Convert ER schema to Relational schema
Time allowed: 2 hr.
Instruction: Under this task the candidate is expected to perform
activities
(Cotion Design E-R diagram and identify the cardinality and constraints of database
• Identify Functional Dependency.
. Convert the ER schema to relational schema
2 & Assessment Assurance
please view and work by a few days i want the answer of this questions
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!
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 ?
Awesoem Playlist
Great ending aswell ... is like back to the begining :)
does anyone know how he drew the relational model? I mean the software used ???
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!
You're so cool Mike!
what to do 1 to 1 relationship when there is total and partial participation on both sides? please reply. Thank you.
add pk of one table as fk on the other. doesn't matter what table.
This is gold
thanks for the free mysql course mate
it's really a great explaination
Thank mike you've been very helpful
This was great lesson. Thanks a lot.
Hey mike you are awesome,just you didn't mention multivalued attribute.
What if we have a relation 1:N with r
Total participation on the 1 side
Hey Mike, awesome work! I really do appreciate your effort. How did you create those diagrams and tables? I mean how did you visualized it, is there any function at PopSQL to transform data into tables and diagrams? Thank you in advance for your help!
When is the deadline for you bro?
@@richmond5607 haha bro I am an absolute data analyst beginner, please enlighten me
@@wunugat9198 th-cam.com/video/-CuY5ADwn24/w-d-xo.html watch this, I found it helpful. There are many videos just surf :)
excellent teacher !!!
What about the attributes on the relationship types? Won't they be added to any tables?
Hey mate plz help me create a conceptual schema from a given tables for the database management 😢
you are amazing
Is an er database a conceptual model?
really helpful thank you
Thank you! Very helpful!