End Sem Model Questions – 10 Use Cases (JAVA SPRINGBOOT)
1. Add a New Book to Library
Project: Library Manager
Description: Create an API to add a new book with title, author, ISBN, and published date.
Endpoints:
o POST /books
Tables: Book (id, title, author, isbn, published_date)
2. Reserve a Hotel Room
Project: Hotel Booking System
Description: Create an API to reserve a room for a guest on selected dates if available.
Endpoints:
o POST /reservations
Tables: Reservation (id, guest_name, room_no, check_in, check_out, status)
3. Assign Teacher to Subject
Project: School Management System
Description: Assign a teacher to a subject. If already assigned, return an error.
Endpoints:
o POST /subject-assignments
Tables: Teacher, Subject, Assignment (teacher_id, subject_id)
4. Generate Bill for Patient
Project: Hospital Billing System
Description: Calculate total bill including room charge, treatment charge, and return bill slip
as JSON.
Endpoints:
o GET /bills/{patientId}
Tables: Patient (id, name), Treatment, Bill
5. Raise IT Support Ticket
Project: IT HelpDesk
Description: Allow employees to raise a support ticket with issue, priority, and system ID.
Endpoints:
o POST /support-tickets
Tables: Ticket (id, issue, priority, system_id, status)
6. Add New Product to Inventory
Project: Inventory Control
Description: Add a new product to inventory with name, quantity, and unit price.
Endpoints:
o POST /products
Tables: Product (id, name, quantity, unit_price)
7. Register New Customer
Project: CRM System
Description: Create a backend API to register a new customer with name, email, and phone
number.
Endpoints:
o POST /customers
Tables: Customer (id, name, email, phone)
8. Update Order Status (Placed → Shipped → Delivered)
Project: Order Tracker
Description: Update the status of an order using the order ID.
Endpoints:
o PUT /orders/{id}/status
Tables: Order (id, status)
9. Apply for Scholarship
Project: Scholarship Portal
Description: Student applies for a scholarship by specifying academic year and reason.
Endpoints:
o POST /scholarship-applications
Tables: Scholarship (id, student_id, academic_year, reason, status)
10. View Customer Orders History
Project: Order Management System
Description: Retrieve all orders made by a specific customer sorted by order date.
Endpoints:
o GET /orders?customerId={id}
Tables: Order (id, customer_id, order_date)