Co-working Space Desk Booking System

Co-working spaces sell their desks the way airlines sell seats — but many smaller spaces still manage bookings on spreadsheets and WhatsApp, which means double bookings, no-shows nobody tracks, and members who can't tell what's free without calling. This project builds the member-facing booking product and the operator dashboard as one system. The centrepiece is a live desk map: every desk on the floor shown as free, booked or occupied, grouped by zone (focus, collaboration, window row, private cabins). Members filter by amenities, pick a date and slot, and pay with plan credits; cancellations refund the credit automatically. Operators see occupancy by zone, plan uptake and booking history. The scope is deliberately one location done properly — the data model (desks, zones, plans, credits, bookings) is small enough to be fully understood and defended in a viva, yet realistic enough to demo like a real product.

1. The operator defines the space once: floors, zones, desks with amenities, and membership plans with credit allowances.
2. A member opens the live desk map, filters by zone or amenity, and picks a free desk.
3. They choose a date and time slot; the app shows the credit cost and remaining balance before confirming.
4. On confirm, a booking record is created, the credit is deducted, and the desk flips to booked on the map.
5. The member checks in at the space against the booking ID; the desk shows occupied.
6. Cancellations before the cutoff refund the credit instantly and free the desk.
7. The operator dashboard aggregates occupancy, plan usage and revenue-affecting metrics.

Tech stack:

• HTML5 · CSS3 · JavaScript (ES6)
• Node.js · Express
• MySQL · relational schema design
• REST API architecture
• Responsive mobile-first UI
• Credit ledger logic
• Git · version control

• [Live desk map] Floor-wise desk grid coloured by real-time status — free, booked later today, or occupied — grouped into zones with different pricing.
• [Zone & amenity filters] Members filter desks by zone and amenities (silent zone, monitor arm, natural light, private cabin) before booking.
• [Slot booking] Date picker plus time-slot grid; unavailable slots are struck through and unclickable, and the selection drives the price.
• [Membership plans with credits] Flexi, dedicated-desk and day-pass plans; bookings consume credits and cancellations refund them automatically.
• [Booking history] Every reservation listed with desk, zone, date and slot, with one-click cancellation for upcoming bookings.
• [Operator occupancy dashboard] Zone-wise availability bars, today's occupancy percentage and booking counts for the space manager.
• [Double-booking protection] Unique constraint on desk + date + slot at the database level, re-validated at booking time.
• [QR check-in ready] Each booking generates an ID designed to pair with a gate QR scanner (scanner hardware is outside project scope).

• Complete source code: member frontend, operator dashboard, backend API and database schema
• Database migration scripts with realistic seed data (desks, zones, plans, sample bookings)
• Setup and deployment guide (local + shared hosting/VPS)
• Operator manual for space managers
• Project report PDF (problem, design, schema, testing)
• PPT presentation for final review
• Viva Q&A preparation document