Ava wants to use a database to keep track of the data records for her insurance company
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 & 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 |
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi