A fully-featured Django-based Database Management System for Azani Company, which provides internet services and infrastructure to learning institutions in Kenya.
# AZANI Internet Service Provider Information System
A fully-featured Django-based Database Management System for **Azani Company**,
which provides internet services and infrastructure to learning institutions in Kenya.
---
## Quick Start (4 Commands)
```bash
# 1. Install Django
pip install -r requirements.txt
# 2. Apply migrations (creates the database)
cd azani
python manage.py migrate
# 3. Load demo data (12 institutions, all scenarios)
python manage.py seed_demo_data
# 4. Create admin user, then run
python manage.py createsuperuser
python manage.py runserver
```
Open **
http://127.0.0.1:8000** in your browser.
Admin panel: **
127.0.0.1
---
## Business Rules Implemented
### Fees
| Fee | Amount (KSh) |
|---|---|
| Registration Fee | 8,500 |
| Installation Fee | 10,000 |
| Personal Computer (each) | 40,000 |
| Overdue Fine | 15% of monthly bill |
| Reconnection Fee | 1,000 |
| Bandwidth Upgrade Discount | 10% off new plan |
### Bandwidth Plans
| Bandwidth | Monthly Cost (KSh) |
|---|---|
| 4 MBPS | 1,200 |
| 10 MBPS | 2,000 |
| 20 MBPS | 3,500 |
| 25 MBPS | 4,000 |
| 50 MBPS | 7,000 |
### LAN Node Pricing
| Nodes | Cost (KSh) |
|---|---|
| 2 – 10 | 10,000 |
| 11 – 20 | 20,000 |
| 21 – 40 | 30,000 |
| 41 – 100 | 40,000 |
---
## Demo Data (seed_demo_data)
Running `python manage.py seed_demo_data` creates **12 institutions** covering every scenario:
| Institution | Type | Status | Notes |
|---|---|---|---|
| Nairobi West Primary School | PRIMARY | INSTALLED | 10 MBPS, all paid |
| Mombasa Junior Academy | JUNIOR | INSTALLED | Upgraded 10→20 MBPS (10% discount) |
| Kisumu Senior High School | SENIOR | INSTALLED | 25 MBPS, last month OVERDUE |
| Nakuru Technical College | COLLEGE | INSTALLED | 50 MBPS, fully paid |
| Thika Road Junior School | JUNIOR | DISCONNECTED | Failed to pay, disconnected |
| Eldoret Primary School | PRIMARY | NEEDS_INFRA | Buying 10 PCs + 8 LAN nodes |
| Kisii Senior Academy | SENIOR | READY | Awaiting insta …