Database Development Projects in GujranwalaDatabase Development Projects in GujranwalaE‑commerce Order Management System
Tools: Airtable | Softr | Make.com
(http://Make.com)Description:
End‑to‑end order management system for an online store. Tracks products, customers, orders, and inventory in real time. When a customer places an order, stock is automatically deducted, and confirmation emails are sent to both the customer and the admin. Includes a dashboard for order status tracking (Pending → Processing → Shipped → Delivered) and low‑stock alerts.
Key features:
· Airtable tables: Products, Customers, Orders, Order Items (linked records, rollups for totals)
· Softr admin dashboard: view all orders, update status, see low‑stock products
· Softr customer portal (optional): customers can view order history
· Make.com (http://Make.com) automation:
· On new order → deduct inventory, send order confirmation email to customer
· On status change → send shipping notification email
· Daily stock check → email alert if any product stock < 5
· Mobile‑responsive design
Built independently – full database schema, frontend dashboards, and multi‑step automation logic Real Estate Property Management System
Tools: Airtable | Softr | Make.com
(http://Make.com)Description:
Property management platform for tracking listings, tenants, leases, and maintenance requests. Designed for landlords or agencies to manage rental properties, tenant communications, and maintenance workflows. Includes automated alerts for rent reminders and lease expiries.
Key features:
· Airtable tables: Properties (for sale/rent), Tenants, Leases, Maintenance Requests
· Softr landlord dashboard: property availability, tenant portal, payment tracking
· Softr tenant portal: online rent payment (placeholder), maintenance request submission
· Make.com (http://Make.com) automation: rent reminders via email, lease expiry alerts, maintenance request notifications
· Conditional routing: urgent vs standard maintenance requests sent to different channels
Built independently full database, frontend portals, and automation logic 
