Indemnities4ya'llsjunk Insurance Company has a need for a database to store data on their customers, the policies of which their customers have purchased, the agents their customers have purchased the policies from, and any claims against a particular policy. Each customer can purchase 1 or more different types of policies under their own name. These types of policies include Auto, Boat, Motorcycle, Home, and Renters. Note: A customer can have more than one auto policy, but would have to be for a different auto. This example could be the same for any type of policy. Any policy has to be purchased via a company agent. Each agent is paid based on the sales of the policies. It is important that the database can capture policies sold by each agent. Note that only one agent can sella individual policy. In other words, agents can not team up to sell a particular policy to a customer. The database needs to also be able to capture each claim against a certain policy. 1 or more claims can be made against each policy during its existence. For each customer, all common personal contact information, and demographic information should be collected including age, SSN, gender, marital status, income range (0-$20,000, $20,001-$50,000, $50,001-$100,000, above $100,000), and risk assessment (low, average, high). For each agent, personal information should be collected including: Name, Address, City, State, Zip, Date of Hire, and Rank in company (Junior Sales Agent, Sale Agent, Senior Sales Agent). For each policy; policy number, policy type, date of purchase, deductible, value of what is insured, and premium must be collected. For each claim; date of claim, status of claim (submitted, in process, paid, rejected), amount of the claim, reason for the claim, and the name of the company Claim Specialist that handled the claim must be collected. 2 M