Great stuff...thank you for giving everyone an exercise...Learning is only fully realized by doing. It would be great if you could post a solution to the bonus problem. Also it would useful to extending this series to show how you could use this DB structure (e.g., Joins) to extract any data needed from it. My Solution to "bonus" challenge: 1 - Student table (student_id, student_name) 2 - Teacher table (teacher_id, teacher_name) 3 - Course table (course_id, course_name)
Hey Buddy, thanks for the kind wordw Your solutions looks good to me , I will just put the column grade at the end and will recheck once more in the morning. I plan to make an entire series on Oracle and sql pretty soon.
Bro...lets concentrate on Kilambakkam railway station..... this project is almost over..... and concentrate on remaining works on Tambaram terminal station
I have confusion in 3rd NF. I mean Teacher name is dependendent on Course ID, so even teacher name ks not given, we can still say that teacher Email is dependent on Course ID. Because teacher A is teaching code with ID 10
I think it’s not dependent because if the teacher gets changed, course id will still be there. Email is only dependent on Teacher name because if name is changed, it’ll be changed too. Idk that’s how i get it
we should break table intt two tables of course_id , coursename and second table with course id and teacher1 and teacher2 to achive 3nf. Correct me if i am wrong
Great Video. For the 3NF part, I guess we have Teacher Email depending on the non-prime attribute Teacher, right? Given the Primary Key of that table is Course_Id. Right?
It means 2 keys are combining to form a primary key In the above example studentID and CourseID together were the composite primary key of the original table
whatever two attributes make sense together, think of them as one, in this case if u take student id and course id and think of them as one (1,10) it kinda forms a singular key u can use to determine every other attribute
Thanks Sandeep for the kind words :) Please consider subscribing to my other channel as well. It will really help me. ruclips.net/video/6G1xGi-D5ow/видео.html
Sir in the video you said that student id and course id are primary keys but a primary key doesn't allow any duplicates in the column.how is it possible sir ?
You said the given table is in 1NF, 1NF states that there is no multivalued attribute in the table, teacher email is multivalued attribute, then how it is in 1NF. Please explain?
1.student_id,student_name 2.course_id,course_name 3.teacher_id,teacher_name,teacher_email 4.student_id,course_id,teacher_id,grade 5.course_id,teacher_id. please let me know if my ans is wrong.thanks.
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Oh! Fantastic. I took three months to understand normalization but you just made me a genius within a second. Well done bro💪💪
I am glad I could help
Salamat bro. Marami kang natutulungan sa Philippines lalo na yung mga nag aaral sa tech field
Wow...one small video and everything got cleared.😮. Hats off .
I am glad I could help you understand!
Great stuff...thank you for giving everyone an exercise...Learning is only fully realized by doing. It would be great if you could post a solution to the bonus problem. Also it would useful to extending this series to show how you could use this DB structure (e.g., Joins) to extract any data needed from it.
My Solution to "bonus" challenge:
1 - Student table (student_id, student_name)
2 - Teacher table (teacher_id, teacher_name)
3 - Course table (course_id, course_name)
Hey Buddy, thanks for the kind wordw Your solutions looks good to me , I will just put the column grade at the end and will recheck once more in the morning.
I plan to make an entire series on Oracle and sql pretty soon.
I thought of this same solution
Can we write in this way?
1 - Student table (student_id, student_name)
2- Teacher table (teacher_id, teacher_name, email)
3 - Course table (course_id, course_name)
4 - Students_Courses join Table (student_id, course_id, grade)
5 - Teacher_Course(course_id, teacher_id)
@@TechCoach i also noticed it’s common that 1nf - 2 tables, 2nf - 3, 3nf - 4 tables usually, like it gets added one by one, is it true?
I believe it is also important to note that if a field is a key then it should NOT be repeated elsewhere in that table. It violates 1NF
Thank you so much! Getting ready for an exam, and you explained it very well :)
I am glad I could help :)
Nice video, enjoyed the tennis references too
I am glad I could help :)
Great work, most asked in interviews
This video made my day, Sir. I'm just revising the normalization chapter. You made my concept Base much stronger. Thank you.
@pranav I am glad I could help.
I have 3 more videos on normalisation you can look at them as well :)
You are a real one
I am glad I could help
Here in converting the table in 3NF how could we know that we have to add an attribute of "Teacher-id".
Two teachers can have the same name so creating an id will help uniquely identify them
Bro...lets concentrate on Kilambakkam railway station..... this project is almost over..... and concentrate on remaining works on Tambaram terminal station
When you did this normalization, were you relying on the data in the table or doing the analysis in general?
Great job 👍♥️
I am glad I could help
Finally understood😊
I am glad I could help :)
Awesome video😎😎👍👍
I have confusion in 3rd NF. I mean Teacher name is dependendent on Course ID, so even teacher name ks not given, we can still say that teacher Email is dependent on Course ID. Because teacher A is teaching code with ID 10
I think it’s not dependent because if the teacher gets changed, course id will still be there. Email is only dependent on Teacher name because if name is changed, it’ll be changed too. Idk that’s how i get it
we can use the email address as a primary key right? it's unique.
Yes😊😊
we should break table intt two tables of course_id , coursename and second table with course id and teacher1 and teacher2 to achive 3nf. Correct me if i am wrong
Great Video. For the 3NF part, I guess we have Teacher Email depending on the non-prime attribute Teacher, right? Given the Primary Key of that table is Course_Id. Right?
Well explained. thankyou
I am glad I could help
great explanation and graphics for teaching! 👍
Thanks buddy, please consider subscribing to my other channel as well it will really help me :)
ruclips.net/video/6G1xGi-D5ow/видео.html
excellent explanation!
Nice Video Keep It Up
Thanks a lot
what is the reason behind the grade relying on student_ID and Course_ID ?
The grade of a student is dependent on the students Id, and also the course in which he achieved the grade. So it's dependent on both the primary keys
You can't determine grade by coure id becuase you don't know which student marks you wanna calculate
Course Name; teacher;
Correct?
😊
You are Rocking Vivek
@Ramesh, Thanks for the kind words.
Please consider subscribing to my other channel as well.
ruclips.net/video/6G1xGi-D5ow/видео.html
Sir can you answer my simple question? If a table has no compound key and is in 1FN then automatically it is in 2FN?
Definitely,true. And if the atomicity of values have been considered... It automatically in 2NF .
What is the differences between first and second and third normal forms in database
sir plz make a video on tips to solve normalization 1nf , 2nf and 3nf . if u do , i will be grateful .
Output of last table all forms
table 1 ( student ) - student id, student name
table 2 ( course ) - course id, course name
table 3 ( teacher ) - teacher id, course id, teacher name, teacher email
table 4 ( student course table) - student_course id, student id, course id, grade
explain urself how
Hi, can I know precisely what way to determine the composite primary key?
It means 2 keys are combining to form a primary key
In the above example studentID and CourseID together were the composite primary key of the original table
whatever two attributes make sense together, think of them as one, in this case if u take student id and course id and think of them as one (1,10) it kinda forms a singular key u can use to determine every other attribute
Wonderful bro! course name ,teacher id 5th mapping table will be added if we have two teachers for same course.
Thanks Sandeep for the kind words :)
Please consider subscribing to my other channel as well. It will really help me.
ruclips.net/video/6G1xGi-D5ow/видео.html
Very nice explanation
Sir in the video you said that student id and course id are primary keys but a primary key doesn't allow any duplicates in the column.how is it possible sir ?
I think that is why we are combining the course id and student id as compsoite key to make them unique
How can i contact you about my project ?
You can email me : reachtechcoach@gmail.com
Table 1 : student id, student name
2 : course I'd, course name
3 : teacher id, teacher name, email address
4 : student id, course Id, teacher id, Grade
this is my solotion
On spot🤗🥱
but email address is dependent on teacher name. This would be a non-key decency, violating 3NF.
@@matthewtsang8268 same thing bro
thanks!
I am glad I could help
Thankss!
The teacher can be determined by Course Name so it is violating . hence it is not a 3nf
gookd work
Why you added id colum with teacher table by your own in 3rd nf?
You can’t?
I think it is to accommodate the 1NF where each record should have a unique identifier.
@@rainremindsmetoyou7436 i don't think so
Jones Robert Hernandez Sharon Moore Kimberly
You said the given table is in 1NF, 1NF states that there is no multivalued attribute in the table, teacher email is multivalued attribute, then how it is in 1NF. Please explain?
Look every cell that no any multi value
For example : car, bus for single cell its called multi value
Last mai teacher id kahn sy aya koi bta skta h
the first video is no longer available
table 1 ( student ) - student_id, student name
table 2 ( course ) - course id, course name, teacher_id
table 3 ( teacher ) - teacher id, teacher name, teacher email
table 4 ( student _course) - student_ id, course_id, grade
Table 5 (Course_teacher) - course_id, teacher_id
Wrong. You wont be able to map the teachers, course to the student
@@sasidharnaidu4507course_id in the course_teacher table links to the course_id in the student_course table
Can we write in this way?
1 - Student table (student_id, student_name)
2- Teacher table (teacher_id, teacher_name, email)
3- Course table (course_id, course_name)
4 - Students_Courses join Table (student_id, course_id, grade) 5- Teacher_Course(course_id, teacher_id)
Didnt understand anything
Using complex words
If we could understand complex words we could have read our book
My apology. There are 3 other videos in this series . You should start with them . This is the 4th video
@@TechCoach bhai doesn't matter now
Exam over
I am at fault i should have paid attention in class.
1.student_id,student_name
2.course_id,course_name
3.teacher_id,teacher_name,teacher_email
4.student_id,course_id,teacher_id,grade
5.course_id,teacher_id.
please let me know if my ans is wrong.thanks.
5.course_id,teacher_id (Table) doesn't need Right?
@@gangardarwagle8938 I think you need this to link the course and teacher table? I'm not sure tho
Angie Island
Table 1) Student_ID,Student_Name
Table 2) Course_id,Course_Name
Table 3) Student_ID,Teacher,Teacher email,Grade
Table 4) Student_Id,Teacher ( For lossless decomposition)
Last mai teacher id kahn sy aya koi bta skta h