<aside> <img src="/icons/clock_blue.svg" alt="/icons/clock_blue.svg" width="40px" /> Where: Lecture 6

</aside>

<aside> <img src="/icons/bullseye_red.svg" alt="/icons/bullseye_red.svg" width="40px" /> Goal: Set your Schema in 2NF, 3NF and BCNF

</aside>

Content Explaining

Watch any of these videos:

https://www.youtube.com/watch?v=GFQaEYEc8_8&t=22s&pp=ygUNbm9ybWFsaXphdGlvbg==

https://www.youtube.com/watch?v=J-drts33N8g&pp=ygUNbm9ybWFsaXphdGlvbg==

READ THIS:

Database Normalization Tutorial: 1NF 2NF 3NF BCNF Examples

ADVANCED:

https://www.youtube.com/watch?v=0Jps8KJSjy4&t=4017s&pp=ygUcbm9ybWFsaXphdGlvbiBpc2FtIGFiZGVsbmFiaQ==

Exercises

2NF Ex.

3NF Ex.

BCNF Ex.

all Normal Forms

More to let go..

Goal Description Links
Deep Dive by Reading articles Get more knowledge in normalization **Normalization,
Normalization**

Assets you can use!

Website to use in creating BCNF and 3NF: Normalization