I am creating a relational database - a library management system. I want to show an example where I normalize the data from 2NF to 3NF. My example of 2NF looks like
The definition of third normal form would be: 'all non-key attributes are not dependent on any other non-key attributes.'
In this instance, the non-key attribute ISBN determines the value of the primary key SKU (stock keeping unit). Does this define a transitive dependency, when SKU is the primary key?
And further, would it be correct to divide the uploaded table into a subtable (Book) with the attributes (isbn, title, author_first_name, author_middle_name, author_last_name) and the subtable (Copy) with the attributes (sku, isbn)?