Data normalization (from 0NF to 1NF)
2
votes
2
answers
2589
views
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
"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. For example is the attribute 'ISBN' atomic?
ISBN is a unique numeric commercial book identifier. An ISBN consists of 4 parts (if it is a 10 digit ISBN) or 5 parts (for a 13 digit ISBN). The different parts is prefix element, registration group, registrant, publication and check digit.
Would you divide the identification number into smaller units, to guarantee an atomic value?

Asked by Jamgreen
(131 rep)
Apr 15, 2015, 07:10 PM
Last activity: Jun 24, 2021, 10:41 AM
Last activity: Jun 24, 2021, 10:41 AM