21CSE354T & Full Stack Web Development
Assignment Questions
Batch - I
1. Build a multi-page website with a navigation bar, footer, and consistent styling using
external CSS.
2. Develop a to-do list app where users can add, edit, and delete tasks (store data in local
Storage).
3. Create a React application that displays a list of students using functional components.
4. Create a database schema for a Student Management System with tables: Students,
Courses, Enrollments.
i. Write SQL queries to:
• Insert 5 sample records into each table.
• Retrieve all students enrolled in a particular course.
• Update a student’s email and delete a course record.
ii. Write a SQL query to find the top 3 highest scoring students in each course.
iii. Implement JOIN operations between multiple tables to display related data.
5. Implement user authentication (login and signup) using Spring Security.
Batch - II
1. Design a product catalog page (for an e-commerce site) displaying product cards with
images, titles, and prices.
2. Write a JavaScript program to fetch and display data from a public REST API (e.g.,
random users, quotes, weather).
3. Build a React form that takes user input and displays the data below the form
dynamically.
4. Create a database schema for a Employee Management System with tables: EmpID,
EmpName, EmpSalary, EmpExperience.
i. Write SQL queries to:
• Insert 5 sample records into each table.
• Retrieve all employees whose experience >= 5 years.
• Update a Employees Designation
ii. Write a SQL query to find the top 3 employees with high experience.
iii. Implement JOIN operations between multiple tables to display related data.
5. Build a Spring Boot service for managing employee data with validation and exception
handling.