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.
| Author |
Topic |
|
hasanali00
Posting Yak Master
207 Posts |
 Posted - 2004-09-02 : 16:00:29
|
| I am on the verge of designing a new database from scratch for an e-commerce application.I am also very much interested in using Customer Relationship Management services on my website, such as customer profiling and personalisation.So how can i design a database that makes it easy to perform data-mining and any other analysis activity afterwards? Is it possible to design databases in such a way that it makes it easy to implement CRM services?Is there any book / website that can teach me how to do this?kind regadrs |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-09-02 : 19:22:58
|
| The best way would be to have a look at existing CRM packages and try and visualise how their databases may be structured. If you have a properly designed database, the data mining shouldn't be a problem. And it's certainly possible to design database to suit CRM (not sure what you mean by 'CRM services' though).Some CRM's to have a look at are Microsoft CRM (bit clunky, but basically good), SalesLogix, Seibel.Not sure about web/book resources about designing CRM, but as long as you can map out the functionality and logical structure it should be easy to draw a well designed database off that. |
 |
|
|
hasanali00
Posting Yak Master
207 Posts |
Posted - 2004-09-03 : 04:28:53
|
| thanks timmy, atleast I have a starting point |
|
|
|
|
|
|
Database design and CRM