How to design a relational database using Normalization With example

Explanation of tables, primary keys, foreign keys, relationship types, 1 to many (1:M), many to many (M:N) and one to one (1:1).

Design a database to 3NF (3rd normal form) using a normalization diagram. Desirable dependency, Partial dependency, and transitive dependency explained.