Firstly, i apologise if this is in the wrong section. I am currently trying to learn more about database normalisation, and i have a set of attributes that i am trying to put in 1NF, 2NF and 3NF. After reading through some websites and watching videos on youtube (they haven't been much help) i am still quite lost. I am aware that no repeating fields should be shown within 1NF, but i am still not quite sure how this data would be broken up.
Any help or suggestions anyone can give would really help me to understand this.
a) Every column value is atomic (does not comprise of multiple distinct values) - 1NF
b) Each table has a primary key (customerId, orderId, productId, supplierID) - 2NF
c) The non-key columns are wholly dependent on the primary key of each table - 3NF