Python + SQL (database)

You are required to develop a database-driven system for Global Insurance 
Incorporation. The requirements for the system are as follows: 
a) Centralised Database System – Develop a centralised database system 
using Python and SQLite to manage claims across Global Insurance 
Incorporation branches. The system should provide real-time visibility 
into claim details, policy information, incident information and generate 
information about the claim processing (e.g., adjuster details, 
assessment reports, communication logs) and payment. 
b) Claim Processing Management Features – Implement features for claim 
processing management, including adding new claim details (e.g., claim 
number, date of claim, type of claim, description of accident), updating 
policy information (e.g., policy number, coverage details, policy limits), 
tracking incident information (e.g., date/time of incident, location, 
incident report), financial information (e.g., claim amount, approved 
amount, payment details) and generating reports on claims status and 
resolution (e.g., claim status, resolution notes, settlement date). 
c) Policy Management - Integrate policy management functionalities into 
the database system to track policy changes (e.g., policyholder 
information, policy details), manage premium information (e.g., 
premium amount, payment schedule, payment history, outstanding 
payments), 
update 
beneficiary 
information 
and 
coverage 
limits/exclusions, and optimise customer interactions for efficient 
processing of claims. 
d) Data Security Measures: Implement robust data security measures to 
protect sensitive information stored in the database. This includes role- 
based access control, encryption of sensitive data, and regular auditing 
of database activities to detect and prevent unauthorised access. 
e) Scalability and Performance: Design the database system to be scalable 
to accommodate the company's growing data needs and ensure optimal 
performance even during peak operational periods. 
f) User-Friendly Interface: Develop a user-friendly interface for employees 
to interact with the database system, allowing them to easily input and 
retrieve data related to claims processing and policy management.