Normalization Practice Exercise | Third Normal Form| Denormalization

the first video is no longer available

Sir can you answer my simple question? If a table has no compound key and is in 1FN then automatically it is in 2FN?

Great work, most asked in interviews

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

Hi, can I know precisely what way to determine the composite primary key?

Very nice explanation

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

Why you added id colum with teacher table by your own in 3rd nf?

sir plz make a video on tips to solve normalization 1nf , 2nf and 3nf . if u do , i will be grateful .

Thankss!

excellent explanation!

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?

This video made my day, Sir. I'm just revising the normalization chapter. You made my concept Base much stronger. Thank you.

Nice video, enjoyed the tennis references too

Thank you so much! Getting ready for an exam, and you explained it very well :)

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?

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) <note: we've removed the teacher_id from this table>
4 - Students_Courses join Table (student_id, course_id, grade, teacher_id)

These Student, Teacher, and Course table can be associated to each other by using the Students_Course Join table.

Anybody agree, disagree, other solutions?

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

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.

great explanation and graphics for teaching! 👍

Wonderful bro! course name ,teacher id 5th mapping table will be added if we have two teachers for same course.

You are Rocking Vivek

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