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
 General SQL Server Forums
 Data Corruption Issues
 help me :(

Author  Topic 

alemadi
Starting Member

1 Post

Posted - 2007-02-10 : 20:58:41
hi,

i have graduation project and i want ask some question

and my project about design the web site for selling and buying the items like the www.ebay.com

1- which is the best progeram to design the database Microsoft SQL Server or MySQL ?

2- should i make a table for buying cash?

3- there is any program for design the shcema for database?

4- which the necessary table ?

i attach the shcema what i did

www.qtruni.com/pic_qu/shcema.doc


Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-02-10 : 21:07:11
"2- should i make a table for buying cash?"

Who buys cash?



CODO ERGO SUM
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-02-10 : 22:36:18
anybody who borrows money at a non-zero interest rate is buying cash...


www.elsasoft.org
Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2007-02-10 : 22:41:36
1. Depends on what you are aiming for.
For something like ebay you would probably want one of the mainstream commercial databases.
If it's to be fairly low volume then you could probably get away with something cheaper like mysql or free like sql server express.

2. You mean do you need structures for holding accounting info for customers and the site (sales ledger, general ledger) - I would have thought so.

3. Lots but you probably don't need them. Pen and paper works well.

4. No idea what this means.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-02-11 : 00:36:29
1. visio is a good choice. mysql also has a specialized tool for schema design - but the mysql tool only works with mysql.
2. ???
3. see number 1 above
4. I think a customer table would be necessary..


-ec
Go to Top of Page
   

- Advertisement -