Capstone Project Using AI Tool

GitHub Copilot: AI-based code suggestions and completions

Project Overview

You are part of a software development team building a Student Management Portal for a school.The system should allow students to register and view their details, while admin/teachers can store, update, and retrieve student records.

The project will use HTML for the frontend, Java (OOPs) for backend logic, and SQL for the database

HTML – Frontend Design

  1. Create an HTML Registration Form with fields: First Name, Last Name, Email, Phone Number, DOB, Gender(Radio Button), Address(Textarea), Course (Dropdown), Submit Button
  2. Add validation using HTML attributes like 'required' and 'maxlength'

3. Create a Student Details Page (HTML Table) to display registered student information

4.Add a Navigation Menu linking to Home, Registration, and View Students pages

Java and OOPs – Backend Logic

  1. Create a Student class with attributes: id, name, email, phone, course
  2. Include a parameterized constructor, getters/setters, and a display() method
  3. Create a Main class that stores multiple students in an ArrayList and displays them
  4. Implement Inheritance, Polymorphism, Encapsulation, and Abstraction using appropriate examples
  5.  Add file handling to save and read student details from a .txt file

 

SQL – Database Design and Queries

Integration Challenge (Optional):

Simulate how HTML form data could be sent to the Java backend and stored in the SQL database using JDBC

(conceptual or code example)

Create a database named 'school_db'

Create a table 'students' with columns: student_id, first_name, last_name, email, phone, course, dob, gender

Insert 5 sample student records

Write queries to display, update, and delete student records

Retrieve all students enrolled in a specific course

Count the number of students in each course

Display students older than 18 years

Display students eligible

Expected Deliverables

 Optional explanation document linking all modules

SQL script file with table creation and queries

 Java files: Student.java, Main.java, and helper classes

HTML files: index.html, register.html, view_students.html

Note:- Above Assigned all task i.e. creating HTML files, Java Files and SQL Scripts has to been completed using GitHub Copilot- AI Based code suggestion and completion tool

GitHub Copilot: AI-based code suggestions and completions

By Content ITV

GitHub Copilot: AI-based code suggestions and completions

  • 12

More from Content ITV