Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Database Design Problem?

Author  Topic 

diptra
Starting Member

1 Post

Posted - 2006-12-23 : 07:39:38
Hi Everyone,

I want to build the site for independent sales representatives,like www.rephunter.net can anyone tell me that how can i design the database for sales representatives. means, how many tables i requried, or can i find those type of databases, creation tips on the net.

""URGENT""


Regards,

Faisal Khan

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-12-24 : 07:25:07
Welcome to SQL Team !!!

Well i guess for this you, need to make a proper study on that site, and then make a study document and accordingly make a table design.

This forum will help you, once you kick off with the projects, but here you are asking for a complete project.


Chirag

http://chirikworld.blogspot.com/
Go to Top of Page

token
Posting Yak Master

133 Posts

Posted - 2006-12-24 : 10:53:59
Tables for sales representative would obviously include details on the sales rep, their address, what industry they work in. I would have a seperate table for personal details and their industries.
Go to Top of Page

swatib
Posting Yak Master

173 Posts

Posted - 2006-12-28 : 06:33:14
Faisal, I think you must analyse what your project wants by gathering requirements.

Gathering of requirements will give you idea and overall view of the project which will be helpful to you as a base for database design. Also you can consider different types of Sales Representatives Reports generation while preparing DB design.


Hope you will start with the same.

All the Best


Njoy Life
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-01-01 : 03:00:16
1 You need training
2 Read related books
3 Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -