Car Insurance Management system

ERD

// note: forgot to put password in the client tables

Data Dictionary

// note: there has been some changes, and the following dictionary are not absolute

EMPLOYEE

CLIENT

INSURANCE

CAR

ADMIN

CHOOSE

UPDATE

Project Structure

Folder & File Breakdown

1. /Admin

Purpose: Contains all the files and scripts for the admin panel. The admin panel allows the system administrator to manage the platform, including insurance policies, users, and claims.

Files: dashboard.php – Admin dashboard page. manage_policies.php – Page for adding, editing, and deleting insurance policies. manage_users.php – Page for managing user accounts. manage_claims.php – Page for reviewing and approving/rejecting claims.

2. /Config Purpose: Contains configuration files that are used globally in the project.

Files: db_config.php – Contains database connection settings (e.g., host, username, password).

3. /db Purpose: Database Schema.

4. /includes Purpose: Stores reusable components and utility scripts used across multiple pages.

Files: header.php – Contains the top navigation bar and branding. footer.php – Contains the footer section with contact information. sidebar.php – Sidebar menu for navigation (if needed).

5. /pages Purpose: Houses all user-facing frontend pages.

Files:

policies.php – Displays a list of available insurance policies. purchase_policy.php – Page for purchasing insurance policies. claims.php – Page for filing insurance claims. profile.php – Displays and allows users to manage their profile. renew_policy.php – Page for renewing expired or soon-to-expire policies.

6. /public Purpose: Contains public-facing assets such as CSS, images, and JavaScript files.

/public/css Files: styles.css – Main stylesheet for the website. admin.css – Styles specific to the admin panel.

Note

• To avoid future conflicts with the database configuration file I have successfully installed the phpdotenv package, where all the secret keys are created in the .env file. Go ahead and run the composer install function in your terminal