Question

Ava wants to use a database to keep track of the data records for her insurance company and to enforce the following business policies/requirements: USE MS ACCESS TO CREATE A DATABASE & RELATIONASHIP

-Every customer must be uniquely identified.

-A customer can have many insurance policies.

-Every insurance policy must be uniquely identified.

-An insurance policy must belong to a valid customer.

-Every customer must be served by a valid insurance agent (employee).

-An insurance agent (employees) serves many customers.

-Every insurance agent (employee) must be uniquely identified.

Employee Excel Worksheet

Agent ID	Agent Name	Email	Phone#
4595367	Winifred Douglas	[email protected]	(611) 427-2469
7128443	Estelle Silva	[email protected]	(984) 402-4669
5145220	Willie Sharp	[email protected]	(580) 398-4548
213904	Alta Maldonado	[email protected]	(604) 461-9991

Policy Excel Worksheet

Policy#	Email	Phone#	Customer Name	City	State
38499	[email protected]	(313) 731-9382	Annie Hopkins	Sokemuha	ME
52123	[email protected]	(313) 731-9382	Annie Hopkins	Sokemuha	ME
71710	[email protected]	(315) 977-3150	Effie Wade	Fepevako	VT
72828221	[email protected]	(556) 969-8511	Nina Manning	Kertuko	VA

Answer 1

This demonstration is using Microsoft Access 2013.

1.Table Name : Customer

Table Design :

Table Data :

*****************************

2.Table Name : Agent

Table Design :

Table Data :

******************************

3.Table Name : Policy

Relationships :

To create relationship : Click on Database Tools ==> click on relationships ==> Add three tables ==> click on CustomerId and agentId columns and create relationship.

Table Design :

Table Data :