DB Automation Challenge
Simulate a real enterprise automation pipeline where data moves from UI → Database → Business Rules → UI update.
Challenge Overview (Real System Flow)
In real companies, data is not processed directly on UI. It goes through multiple layers like databases and backend systems.
In this challenge, you will simulate the same workflow: extract data from UI → insert into a database → apply business rules → and reflect updated results back into the UI.
Real-World Automation Flow
1. Extract Data from UI
Read employee records shown in the table (like a front-end system).
2. Insert into Database
Store all extracted records into a structured DB table (simulate backend ingestion).
3. Apply Business Rules in DB
Run logic on stored data (like SQL procedure or backend service).
4. Update Records in DB
Modify status column based on rules (Approved / Rejected / Pending).
5. Sync Back to UI
Reflect updated DB results back into the webpage table.
6. Submit for Evaluation
System compares DB output vs expected results and generates score.
Business Rules (DB Layer Logic)
✔ If Experience ≥ 5 AND Department = "IT" → Approved
✔ If Experience < 3 → Rejected
✔ Otherwise → Pending
What you will learn
✔ End-to-end data pipeline understanding (UI → DB → UI)
✔ How backend systems process bulk records
✔ Database update & transformation logic
✔ Real enterprise onboarding workflows
✔ Automation exposure: ETL pipelines, RPA workflows, SQL-based transformations, backend rule engines
Common Mistakes
• Skipping extraction step from UI
• Not simulating DB update correctly
• Applying rules on UI instead of DB layer logic
• Not syncing final results back to UI
Complexity
Intermediate → Advanced
Multi-layer automation (UI + DB + Rules Engine)