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 |
|
Lawal25
Starting Member
1 Post |
 Posted - 2011-04-21 : 00:55:22
|
| I am new to data base design and management but I have project to develop a CRM which involves data base design how do i startlawalmohammed |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-04-21 : 07:08:14
|
| Umm.Start by gathering requirements. You need to know what the system is to be used for and by whpo and what data is available.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-04-21 : 09:41:09
|
| A great way to gather requirements is to ask what they want OUT of the system before you focus on how data will get IN to the system. You could spend months working on a design and interfaces and reports only to have someone say "but I wanted THIS on the report". If you didn't include THIS in the design, then you can't report it out.Hey, it compiles. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-04-21 : 09:59:41
|
If you are new to database design, why are you being asked to design a CRM system? Instead of your company purchasing a commercial CRM package?I mean, besides the obvious "because we've USED all the commercial CRM packages, and they're all crap".  |
|
|
|
|
|
|
New to Database Design