Normalization Practice Exercise | Third Normal Form| Denormalization

If you want to learn how to change De normalized dataset into 3rd normal form this video is for you
The video is part of the normalization series, Please watch these videos as well for better understanding on the entire concept.
The video is the 6th video in the video series of Normalization.
Here is the link to the 1st Video - normalization
Here is the link to the 2nd Video - 1st Normal form
The 2nd Normal focus on No Partial Dependency.
Here is the link to the 3rd Video - 2nd Normal form
The 3rd Normal focus on the transitive dependency.
#Keys #NormalizationSeries #TechCoach

[foremost]

Salamat bro. Marami kang natutulungan sa Philippines lalo na yung mga nag aaral sa tech field

[fredykilusu]

Oh! Fantastic. I took three months to understand normalization but you just made me a genius within a second. Well done bro💪💪

[randommagic]

Wow...one small video and everything got cleared.😮. Hats off .

[jetmartin]

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?

[hrprELIE]

we can use the email address as a primary key right? it's unique.

[fatimafirdos]

Here in converting the table in 3NF how could we know that we have to add an attribute of "Teacher-id".

[jkmo-ghvd]

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

[hichamcr]

When you did this normalization, were you relying on the data in the table or doing the analysis in general?

[eshaesha]

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

[mabioraguer]

What is the differences between first and second and third normal forms in database

[Oxalis]

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

[fernandojackson]

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?

[brenotanquista]

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

[khanomabatha]

what is the reason behind the grade relying on student_ID and Course_ID ?

[xygon]

Nice video, enjoyed the tennis references too

[cuteXpuffy]

How can i contact you about my project ?

[mapeiying]

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

[phanendraojha]

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

[Khanzeko]

Last mai teacher id kahn sy aya koi bta skta h

[karthiknetchikal]

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 ?