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
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 & RELATIONSHIP
-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 | | Phone# |
4595367 | Winifred Douglas | kol@va.re | (611) 427-2469 |
7128443 | Estelle Silva | zesuk@ege.li | (984) 402-4669 |
5145220 | Willie Sharp | ba@sejec.ga | (580) 398-4548 |
213904 | Alta Maldonado | kegadoba@ot.sh | (604) 461-9991 |
Policy Excel Worksheet
Policy# | | Phone# | Customer Name | City | State |
38499 | doditu@go.ag | (313) 731-9382 | Annie Hopkins | Sokemuha | ME |
52123 | doditu@go.ag | (313) 731-9382 | Annie Hopkins | Sokemuha | ME |
71710 | tedlur@gebor.tm | (315) 977-3150 | Effie Wade | Fepevako | VT |
72828221 | etehih@gogapur.mc | (556) 969-8511 | Nina Manning | Kertuko | VA |
Step by Step Solution
3.45 Rating (148 Votes )
There are 3 Steps involved in it
Step: 1
1Table Name Customer Table Design Table Data 2Table Name ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started