I am designing a relational database in mySQL - a library management system. I want to show examples of the data in 1NF, 2NF, 3NF, BCNF, etc. My example of 1NF looks something like this

enter image description here 'A relation is in first normal form if the domain of each attribute contains only atomic values, and the value of each attribute contains only a single value from that domain.'

I am unsure of if the data is in 1NF. As a book can be written by multiple authors, the attributes author_first_name, author_middle_name, and author_last_name are multivalued attributes. How should I take this into consideration in my example of 1NF?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.