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 |
|
brucey54
Starting Member
2 Posts |
 Posted - 2014-01-09 : 07:43:18
|
| Hi folks, I need some guidance, I have been asked to create a database for a small business. The business has 3 shops, each shop stocks and sells mostly the same merchandise.The question is do I create 3 databases, 1 for each shop or do I create 1 database for the 3 shops?The owner would like to pulls stats from the 3 shops i.e. to find out stock levels, how much stock has been sold from each shop etc.Any help or advise would be much appreciated, I am new to MS SQL, I will be using C# to build the frontend.Brucey54 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-09 : 09:18:38
|
| if your attempt is to merge data from all shops then it makes sense to bring all of them to same db with a shopid field to distinguish them. Otherwise you may choose to keep it separate in its own db.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
brucey54
Starting Member
2 Posts |
Posted - 2014-01-10 : 05:48:34
|
| Thanks visakh16, I think I will create just 1 database!Brucey54 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-10 : 06:17:15
|
| ok cool------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Database Design