Normalization to 3NF from un-normalized relation <p>Given</p> <pre><code>INSURANCE PORTFOLIO (portfolio id, insurance company name, insurance company phone, ((agent name, agent license number, state of residence, ((policy number, policy description, annual premium, benefit, beneficiary details)), number of policies)), number of policies in a portfolio) </code></pre> <p>I'm trying to get this into 3NF. Am I on the right track?</p> <p>1NF:</p> <pre><code>1NF: INSURANCE PORTFOLIO:(portfolio id, insurance company name, insurance company phone, ,agentname, number of policies in a portfolio) agentdetails: (agent name, agent license number, state of residence, policy number,number of policies in a portfolio#) policydetails:(agent name#,policy number#, policy description, annual premium, benefit, beneficiary details) </code></pre> <p>2NF</p> <pre><code>2NF: INSURANCE PORTFOLIO:( agent name ,portfolio id, insurance company name, number of policies in a portfolio) Agentdetails: (agent name, agent license number, state of residence, policynumber,number of policies in a portfolio#) policydetails:(agentname,policy number, policy description, annual premium, benefit, beneficiary details) </code></pre> <p>3NF:</p> <pre><code> INSURANCE PORTFOLIO:( agent name ,portfolio id, phonenumber , number of policies in a portfolio) agentdetails:(agent name#, agent license number, state of residence,policynumber,number of policies in a portfolio#) policydetails:(agent name#,policy number#, policy description, annual premium, benefit, beneficiary details) </code></pre> <p>Any guidance is appreciated</p>