Luckily I already had SQL Server 2008 R2, SQL Server 2008 and SQL Server Compact editions installed in my computer. Created the planned schema as follows:
- SQL Server 2008 R2 - for the Common DB
- SQL Server 2008 - Branch DB (Will clone the same to another SQL Server 2008 Express database, to simulate the DB for another branch).
- SQL Server Compact - for Mobile.
The diagrams for each database are given below:
 |
| Tables for the Common DB |
In addition to the planned schema for the Common DB, I have added a stand alone table called
TimeConfiguration to maintain various time related information to the system, such as order expiry time & table reservation expiry time.
 |
| Tables for the Branch DB |
 |
| Tables for the Mobile DB |
No comments:
Post a Comment