Basic question on table design & relationships

[topgeek]

I have been asked to put together a database where we have Customers who have multiple sites and then engineers that could make multiple visits to those sites.

Could anyone help me with the corcect structure and relationships for a database like this?

 

[lespaul]

First thing to do is read The Fundamentals of Relational Database Design. Once you've read that you should have more specific questions and a preliminary table structure to post for critique and review.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[jebry]

Hi!

Try this:

CustomerTable
CustomerID
MainPhoneNum
WebSite
etc.

CustomerSites
CustomerID
SiteNum
PhoneNum
Address
Address2
City
State
etc

EngineersTable(could be employee)
EmployeeID
Name
etc

VisitsTable
EmployeeID
CustomerID
SiteNum
Date
Reason
Comments
etc

ContactsTable
ContactID
CustomerID
SiteNum
PhoneNum
Email
Name
etc.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst