Good day. Please note that I am not a professional and the software I'm creating is for two small companies i own. Please take it easy on me. My plan is to create a cakephp app which has accounting, production (job tracking) and crm components. I understand it sounds ambitious but I'd like to able to finish this project in the near future. I need your advice on a good database design for this kind of system.
I have 2 small businesses which would use this system independently. Each company will have their own customers and database users. The customers tie all of the Accounting, Production and CRM Components together. Companies --------------> Corresponding Database Users (i.e. Company 1, Company 2) | | Customers | ---------------------------------------- | | | Accounting Production CRM I'd like to know a couple of things. 1. Do you think this kind of system is feasible to do with cakephp and mysql? We are currently using different third party software for these components except the Production system which is done in php. Having no tie-in between the three creates discrepancies. 2. Database Design - Here is where I get stumped. While it's easy to put everything on one database, I am inclined to believe that this isn't in line with good database design practices. I maybe wrong here but please give me your opinion. Single database (with all of the levels in tables) or multiple databases? 3. If I were to use multiple databases, which ones would need their own database? Should all components in the diagram have their own databases or should the databases be on a company level? (i.e. each company has its own mysql database) Since customers tie in the Accounting, Production and CRM components, should it have a separate database as well as these three? Please take it easy on me. I'd really appreciate some advice/feedback on my dilemma. Thank you for your time. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---