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 |
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.com1- 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 didwww.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 |
|
|
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 |
|
|
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. |
|
|
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 above4. I think a customer table would be necessary..-ec |
|
|
|
|
|