Q1) Spring Boot REST Application for Student and Course Resources

Objective

• Write a Spring Boot REST application which will provide following CRUD operations for "Student" and "Course" resource offered by Training Institute.
• A course can have multiple students. A student can enroll only in 1 course.

CRUD Operations

1. Add new Course
   • i/p course details
2. Add new Student
   • i/p student details along with course id
3. Update Course Details
   • i/p course id n new (Start Date, End Date, Fees)
4. Fetch all courses by given Category
   • i/p category name

Additional Optional Work for More Practice

1. Fetch all students for given Course Name
   • i/p course name
2. Cancel Admission of specific student
   • i/p student id
3. Cancel Course
   • i/p course id

Course Attributes

• Course has the following attributes:
  1. ID (unique identifier for each Course, auto generated, starts from 1)
  2. Name (unique , Cannot be Blank, Example : Java SE,Web Programming in Java ,Spring Boot , Spring Cloud, Oracle DB , MySql DB )
  3. Category (Enum, Example: JAVA,DBT)
  4. Start Date (Cannot be Blank)
  5. End Date (Cannot be Blank)
  6. Fees (Cannot be Blank)
  7. Marks (Cannot be Blank)

Student Attributes

• Student has the following attributes:
  1. Student id (unique identifier for each Student , auto generated, starts from 1) - primary key
  2. student name (Cannot be Blank)
  3. Email (Cannot be Blank)
  4. Password (Cannot be Blank)
  5. Marks
  6. Course id - Foreign key

Requirements

• Use MySQL Relational Database to save resource.
• There should be Validation on Create & Update Payload.
  • For example:
    1. End Date cannot be before Start Date.
    2. Name should not be blank.
    3. None of the fields in Course table is Nullable.