Hello, I have a project in SQL that I need help with. Here is the requirements:

Create the physical database in SQL Server creates.

Build the physical relationships between all of the tables based on design via the use of foreign keys.

Ensure complete normalization of the physical tables created in #9 above by assessing if each in in 1NF, 2NF, and 3NF. Create any needed additional tables based on this assessment and build the physical relationships with the normalized tables with the use of the foreign key.

Create referential integrity by altering the tables to add a foreign key constraint.

Write the drop tables statements in the appropriate order based on referential integrity.

Insert 5 or more rows into each table created.

Write the EXPLICIT SQL Select Statements for the following:

List all customers and their policies they own.

List all customers that have a claim in process. Show the policy and the date of the claim.

Show all customers who are Male that have had a claim against their auto insurance policy.

Show all agents policies they sold during a particular month. Show agent name, customer, policy and cost of policy.

Show all claim specialists that have rejected a claim on a policy. Provide the first name of the specialist, the date of the claim, the policy number, the policy date, the policy type, and the customer for any claims that have been rejected.

Here is the information about the company:

Indemnities4yallsjunk 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 sell an 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.