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 for email application

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-07-16 : 09:41:46
Prasad writes "i am developing a email service , similar to say yahoo, hotmail ,etc.. how should i go about the database design , tables. i mean the backend part of it. pls help

Prasad"

M.E.
Aged Yak Warrior

539 Posts

Posted - 2002-07-16 : 10:35:39
Holy vague batman. I guess this is one of those 'I want to make a job board like monster, pls send code now'

Prasad, I suggest you grab a couple books and read for a day or so. You'll need business rules to help to determine what your tables should look like. Good starting question

How many email addresses can a user have?

If a user can have more then one, you'll need a second table to record emails addresses. If they can only have one, you'll only need one user table.

-----------------------
Take my advice, I dare ya
Go to Top of Page
   

- Advertisement -