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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-24 : 17:05:11
|
shawn wang writes "Our company has 15 branches across the nation wide. We are planning to design a Sql server database to enable branches to enter order data either via web or a thin vb application.
I propose to have one database including a branch table with all the branch ids and then take the branch id as foreign key into other tables such as orders, customers..
All the branches basically perform same business processes.
Every branch enters 60 orders per day.
My questions are :
1. how would you guys deal with this situation? How about having databases for each branch?
2. if we use identity column for order_id and create views from the order table for each branch, is that possible to set the seed and increment for order_id in each view so we can get the following results?
select order_id, branch_id from order;
order_id branch_id
3000011 03
3000012 03
3000013 03
4000100 04
4000101 04
9000001 09
9000002 09
...
Any answers will be greatly appreciated.
shawn
" |
|
|
|
|
|
Database Design