The Database is required for :-
Agents and Leads

A. STATEMENT OF USER REQUIREMENTS :

There is a Business Entity that has Agents and these agents sort business from the community.
- One Agent can generate multiple leads for the Business.
- A Lead (Customer) can only work with one Agent.
- The Business agent can work with multiple leads at a time
- the Business can have multiple people work on a lead at a time.

So the tables would look something like this ...
 Agent Information (I think this would be part of the Employee table since they are from the same company but I am not sure), 
 Customer/ Lead Info (such as name, phone, contact information, etc..
 Employees
 Lead Information (from Agents like what its about, when it should be ., how etc)
 Projects (that Business is working on)

That is the end of the Statement of User Requirements.

Barry Williams
13th. July 2008
Principal Consultant
Database Answers