Project exam · Full-Stack Development
Project exam: tiffin orders, end to end
Project examintermediate· about 1.5 hours· 6 steps· 90 min · pass 60%
The brief
In 90 minutes, build one feature of the Ghar Ka Khana tiffin app across the whole stack: two SQL reports for the kitchen and the sales team, order validation, the POST /api/orders handler with a 10 am cut-off in Indian time, the frontend call, and the "my orders" table.
Why it matters
Full-stack interviews and freelance trials often give exactly this: one real feature, every layer, against the clock. Cloud kitchens and tiffin services in every Indian city run on these rules: daily counts per area, renewal reminders, order cut-offs and clear bills.
Skills you practise
- GROUP BY reports
- date ranges in SQL
- validation with field errors
- a handler with 401, 400, 409 and 201
- time zones (IST)
- fetch with credentials and errors
- rendering a table
What you will have at the end
Two SQL reports and orders.js (validation, the handler, the frontend call and the table), written and checked in 90 minutes.
How it is marked (rubric, 100 points)
| Tasks passedPoints for each checked task; 60% or more passes the exam. | 60 |
|---|---|
| Correct HTTP and time handlingRight status codes and a cut-off that works in Indian time on any server. | 15 |
| Safe codeEvery value validated on the server; textContent on the page; credentials sent with the request. | 15 |
| ReadableClear names and small functions. | 10 |
- 6tasks
- 90 mintime limit
- 60%to pass
Rules: a project exam
- The exam opens full screen. Stay on this page until you hand it in.
- Opening another tab or app, or leaving full screen, counts as one time away. After 3 times the exam ends.
- No copy or paste during the exam.
- No hints and no answers. You can run your code, but the checks run only when you hand in.
- Every task is checked automatically when you hand in, or when the time is up.
- You see which tasks passed at the end. You can take it again.