I am really struggling to convert the table into second normal form.
I've tried examples which are much easier, however I can't seem to be able to identify the keys for this one and work my way forward. I have converted that to 1st normal form by duplicating the module information.
How to convert a table into second normal form
normalization
Related Question
- Decompose table into third normal form
- Anomalous Updates in Normalized Database
- Normalization – Proving or Disproving Dependencies in A ? BC and A ? B then A ? C
- Second Normal Form (2NF) Normalization Exercise
- Normalization – How to Apply Second and Third Normal Form
- Database Design Normalization – Does This Design Violate a Normal Form?
- Normalization with Two Potential Primary Keys – Best Practices
Best Answer
Now this seems like a bit of a homework question so I won't do it for you but make a module table, make a room table. If you want third normal form making a booking table with module code and room number as a compound primary key, and the fields relevant to a booking.
Remember normalisation is to make all the data related and remove repetition.