Question

Create a relational schema with all relations in third normal form for the following information about Stockton Life Insurance Company: The company has a large number of policies. For each policy, we want to know the policyholder's social security number, name, address, and birth date. We also need to know the policy number, annual premium and death benefit amount. Moreover, we want to know the agent number, name, and state of residence of the agent who wrote the policy. A policy holder can have many policies, and an agent will write many policies.

Answer 1

POLICIES: PolicyID, PolicyAnnualPremium, PolicyDeathEndBenefitAmount, AgentNumber, AgentName, AgentStateOfResidence, PolicyHolderName, PolicyHolderAddress, PolicyHolderBirthDate

POLICY HOLDERS: PolicyHolderSecurityNo, PolicyHolderName, PolicyHolderAddress, PolicyHolderBirthDate, NumberOfPoliciesHold

AGENT: AgentID, AgentName, AgentStateOfResidence, NumberOfPoliciesWritten

Explanation: Third normal form or 3NF is a normal formal that is usedto organize a database in order to reduce the duplication of data.