Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an Entity Relationship Diagram that fits the following requirements some thing to keep in mind as you design this ERD the client needs the

Create an Entity Relationship Diagram that fits the following requirements

some thing to keep in mind as you design this ERD the client needs the ability to create new customers, projects and bids via easy to use forms is a must. The client will want to be able to update customers' projects and bids easily and with minimal training in Access. Information entered in any forms should update to relevent tables with out issue. While you aren't actually making the database these are things to keep in mind during the design phase.

1.Be able to track customers, projects and project bids.

(a) Customers may have more than 1 address and project at a time.

(b)contact address may be different than project address.

2.Track sprinkler blowouts by address and a zone defined by the client at a later time.

(a) Blowouts may be done at more than 1 property on different days

3.Tracking job bids

(a)a bid sheet will have the customers contact information as well as the project location information (these will not alway not be the same addresses)

(b) will contain job details for the front, back and side yards as well as prices for each section and a total cost for the whole project. ( so the customer can choose to only do parts of the work or all at once.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

0782125395, 9780782125399

More Books

Students also viewed these Databases questions

Question

(-1, 3) Plot the given points in a coordinate system.

Answered: 1 week ago

Question

Why is the System Build Process an iterative process?

Answered: 1 week ago