I am trying to understand how to manage multiple stores in a inventory management system (Each store has large number of data). There are 123 stores in this shop. Some stores have sub stores.
So I planned to create one master database (only super admin can access this) and one separate database for each store and database user for each database.
I have some doubts about this approach.
1). Is this design is correct? If not what are the suitable ways?
2). What is the best DBMS for this kind of projects?
3). How to update master database to get daily sales, monthly sales, employee details etc real time?
4). How many databases I can create using this