Intranet software development, focused on management of personnel risk mapping in a hospital setting, with access restricted mostly to officers/employees of the Prevention and Protection Service and for doctors.
Starting from a version with limited functionality, realized in MS Access by internal personnel, it needed normalization in many steps of the previous db, and then later data migration to new version.
Application stack involved a LAMP configuration but the database used in reality was a MSSQL Server. This solution was due to a pre-existing configuration where the Oracle database, where resides the SAP master data of employees, was connected via direct link to a MS SQL server, where the same registry was available through a view always in sync.
Choice of such db had a direct consequence: develop a specific database driver, in addition to those at the lowest level existing and available in the open source community, to fully exploit the functionality of the HMVC framework ( Rapyd) used for software development.
On the other hand, several important changes were made to the framework itself, which was an open source project, and work in progress of a former colleague of mine, at the time of the project.