Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Email

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#

Email

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

Students also viewed these Databases questions

Question

Find the radius of convergence of? 1.2.3 1.3.5 (2n-1) r2n+1 -1

Answered: 1 week ago