Dynamic database modelling for compliance related software applications

重点是一个动态的数据库模式和相应的用户界面（UI）设计创新 合作伙伴公司开发的移动的应用程序。动态数据库模式是指 灵活的数据库建模，其中表结构可以很容易地扩展或更改，即使在 该应用被发布用于生产。AirSenze Solutions Inc.（合作公司）开创了 * 开发移动的应用程序，以提高各省遵守细则的效率和问责制 市一级。这些移动的应用丰富了传统的现场检查过程， 包括标准的纸质清单，增加了基于移动设备的创新功能，如GPS跟踪， 多媒体附件、基于云的数据存储和数字时间戳签名。而发生轻微 检查清单的改动需要重新设计整个数据库模式和用户界面。一 自适应输入参数微小变化的动态数据库设计将大大减少 公司的开发成本和应用程序时间轴。这将有助于AirSenze有效地迎合 不断增长的客户群的技术需求。估计表明，软件开发时间轴 将减少1/3以上。动态数据库设计是一个相对较新的 概念和许多问题仍有待回答。多数据库建模的综合分析 方法将进行探索的各种能力和相关的设计问题的挑战。 该研究项目将显著提高公司的应用程序设计效率和收入。 目前，大多数政府检查都是使用古老的纸质表格进行的。这是一 通过使用移动的可以大大改善和简化的昂贵和低效的过程 应用程序.一个适应性强的数据库设计将帮助该公司满足多个政府部门， 及时提供具有成本效益的软件解决方案。

The focus is on a dynamic database schema and the corresponding User Interface (UI) design for innovative mobile apps that are developed by the partner company. Dynamic database schema refers to the concept of a flexible database modelling wherein the table structure can easily be extended or altered by its users even after the application is released for production. AirSenze Solutions Inc. (partnering company) has pioneered the development of mobile applications to increase efficiency and accountability in bylaw compliance at provincial and municipality levels. These mobile applications enrich the conventional site inspection processes that include standard paper-based checklists by adding innovative mobile-based functionalities like GPS tracking, multimedia attachments, cloud-based data storage, and digital time-stamped signatures. However, minor alterations in the inspection checklist requires a redesign of the entire database schema and user interface. A dynamic database design that self-adapts to minor changes in the input parameters will greatly reduce the development cost and application timeline for the company. This will help AirSenze to effectively cater to the technological demands of its growing customer base. Estimates indicate that the software development timeline will be reduced by more than 1/3 as a result of this project. Dynamic database design is a relatively new concept and many questions remain to be answered. A comprehensive analysis of multiple DB modelling approaches will be conducted to explore various capabilities and challenges associated the design problem. This research project will result in a significant increase in app design efficiency and revenue for the company. Currently a majority of government inspection are carried out by using archaic paper-based forms. This is an expensive and inefficient process which can be greatly improved and streamlined through the use of mobile apps. An adaptable database design will help the company cater to multiple government sectors by developing cost-effective software solutions in a timely manner.