So, I’m sure it is 2nf since there is no partial dependency, but I’m not sure if phone numbers 1 and 2 are transitive.
I could create a new table with c_id as the primary and phone number as the secondary. I just want to know if the initial design violates 3nf.
New contributor
Nascoor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.