Future Study Hub

PROJECT

Future Study Hub

Submitted By,

Preet Vachhani 202203100110096,

Manthan Sinojiya 202203100110112,

Sujal Hirpara 202203100110117,

Dharam Kathiriya 202203100110162

Guided

By,

Pooja

Patel

For partial fulfillment of the requirements

For the Degree of Bachelor of Computer Application

B.V. Patel Institute of Computer Science,

Uka Tarsadia University.

April, 2024.
 Future Study Hub
DECLARATION

We hereby declare that the project titled “Future Study Hub” is fully implemented
by us. It is neither paid nor copied. Even though, later on, in case of any
infringement found for this project work, we are solely responsible for the same
and understand that as per UGC norms, the University can revoke the degree
conferred to us.

Enrolment Number Name Signature

202203100110096 Preet Vachhani
202203100110112 Manthan Sinojiya
202203100110117 Sujal Hirpara
202203100110162 Dharam Kathiriya

Date: Signature:
 Future
Work StudyCertificate
Sufficiency Hub
As a guide, I assure you that the project work presented by the team is sufficient and
qualitative according to the specified time duration and team size.

Guide Name: - Pooja Patel

Date: Signature:
1 Future Study Hub
Project Course Awareness:.................................................................................................. 1
1.1 Objective:........................................................................................................................... 1
2 Project Definition Selection:............................................................................................... 1
2.1 Definition:.......................................................................................................................... 1
2.1.1 Distinct functionality in each system:.......................................................................1

3 Proposed System Requirement Analysis:.......................................................................2

3.1 Tools and Technology:.................................................................................................. 2
3.1.1 Tools:....................................................................................................................................2
3.1.2 Technology:........................................................................................................................2

3.2 Definition:.......................................................................................................................... 2
3.3 Purpose:............................................................................................................................. 2
3.4 Scope:.................................................................................................................................. 2
3.5 User’s Functional requirements:..........................................................................3
3.6 Non-functional requirements:.................................................................................... 6
3.7 Users of the system with their characteristics:.....................................................6
3.7.1 Number of users:..............................................................................................................6

4 Conceptual Diagram Design:............................................................................................... 7

4.1 Use case Diagram:........................................................................................................... 7
4.1.1 List of Users:.......................................................................................................................7
4.1.2 Draw Use case Diagram:...............................................................................................7

4.2 Activity Diagram:.......................................................................................................... 10

5 System Model:....................................................................................................................... 13
5.1 Prototyping Model Implementation for Our Project:.......................................13
6 Database Design:.................................................................................................................. 15
6.1 Table with description includes attributes, data type, size, and
constraints:................................................................................................................................
6.2 Number of tables:......................................................................................................... 20
7 User Interface Design.......................................................................................................... 21
7.1 Screenshot of Homepage:.......................................................................................... 21
7.1.1 Used navigation control with justification:..........................................................21

7.2 Screenshot of UI:........................................................................................................... 22

8 Dashboard:............................................................................................................................. 26
9 Test Case:................................................................................................................................ 28
 Future Study Hub
1 Project Course Awareness: -
1.1 Objective: - The system aims to help candidates prepare for the IELTS exam
by offering classes, study materials, sample questions, and practice tests,
enabling them to enhance their English language skills and increase their
chances of success in the exam.

2 Project Definition Selection: -

2.1 Definition: - Future Study Hub is an online educational platform that helps
individuals in planning their future settlement in any country of their choice.
System offers classes and provide information about countries that are good
for pursuing higher education. System offers study materials, sample
questions, and practice tests to help candidates prepare for each section of
the IELTS exam.

2.1.1 Distinct functionality in each system: -

1. Student Visa Guidance: - IDP offers visa assistance to students who are
planning to study abroad. This includes help with applying for visas,
understanding visa requirements, and navigating the visa process.

2. Personalized counseling: - LEAP SCHOLAR offers personalized counseling

to students who are interested in studying abroad. The counseling service
includes help with choosing a university, applying for scholarships, and
preparing for the study abroad experience.

3. Manage Scholarship: -IDP offers a scholarship search engine that helps

students find scholarships that they are eligible for.

202203100110096, 202203100110112, 202203100110117, 202203100110162 1

 Future
3 Proposed Study
System Hub
Requirement Analysis: -
3.1 Tools and Technology: -
3.1.1 Tools: -
1. XAMPP
2. VS CODE

3.1.2 Technology: -
1. PHP
2. HTML
3. CSS
4. Bootstrap
5. JavaScript
6. MySQL

3.2 Definition: - Future Study Hub is an online educational platform that helps
individuals in planning their future settlement in any country of their choice.
System offers classes and provide information about countries that are good
for pursuing higher education. system offers study materials, sample
questions, and practice tests to help candidates prepare for each section of
the IELTS exam.
3.3 Purpose: - The purpose of our system, Future Study Hub, is to provide
comprehensive online resources and tools for individuals preparing for the
IELTS exam. We aim to equip users with study materials, practice tests,
interactive learning modules, and personalized feedback to enhance their
language skills and excel in the IELTS exam. Our platform strives to
empower users with the knowledge and confidence they need to achieve
their desired scores and pursue their academic and professional aspirations.
3.4 Scope: -
 System Functionality Scope: -
1. Expert Support: - Access to qualified IELTS trainers for guidance, doubt
clarification, and study plan development. Q&A sessions, discussion forums,
and community interactions for peer learning.

202203100110096, 202203100110112, 202203100110117, 202203100110162 2

 Future Study Hub
2. Real Exam Simulations: - Simulated exam experiences with timed tests,
official instructions, and strict adherence to exam formats.

3. Personal Achievement Dashboard: - Each user has a personalized

dashboard highlighting their achievements, progress, and earned badges.

 System scope: -
 In this semester System scope is limited to Gujarat state of India.

3.5 User’s Functional requirements: -

1. Admin: -
1. User Registration and Profiles: - Admin can create accounts,
providing necessary details such as name, contact information, and
preferred study goals.

2. Manage Users Profile: - Administrators to oversee and modify user

accounts. Administrators can access and update user information,
including personal details, preferences, and access permissions,
ensuring efficient management and customization of user profiles to
meet individual needs.

3. Manage Exam Schedule: - Users can access full-length, timed

practice exams that closely mimic the format and conditions of the
actual IELTS exam. This feature allows candidates to experience the
exam environment and manage their time effectively.

4. View Feedback: - Admin can see all student’s feedbacks.

202203100110096, 202203100110112, 202203100110117, 202203100110162 3

 2. Teacher: - Future Study Hub
1. User Registration and Profiles: -Admin can create accounts,
providing necessary details such as name, contact information, and
preferred study goals.

2. View Student Profile: - Teachers can now access and review

detailed profiles of their students within the platform. This
functionality enables teachers to gain insights into students'
progress, performance, and individual learning needs, facilitating
personalized guidance and support.

3. Manage Lesson: - Teachers have the capability to organize and

manage their lessons effectively through this feature. They can
create, edit, and schedule lessons, as well as track attendance,
assignments, and progress.

4. Provide Materials: - Teachers can upload and share educational

materials, resources, content relevant to their lessons. This
functionality empowers teachers to enrich the learning experience
by offering additional study materials, reference documents,
multimedia resources, and interactive exercises to support
students' comprehension and skill development.

5. Monitor Student Progress: - The system will enable users to track

their progress by providing performance analytics, scores, and
recommendations for further improvement.

6. View Feedback: - Teacher can see all student’s feedbacks.

202203100110096, 202203100110112, 202203100110117, 202203100110162 4

 3. Student: - Future Study Hub
1. User Registration and Profiles: -Student can create accounts,
providing necessary details such as name, contact information, and
preferred study goals.

2. Access Study Materials: - Students now have the ability to access a

comprehensive repository of study materials directly from the
platform. This functionality grants students access to a diverse
range of educational resources, including notes, e-books, videos,
and practice exercises, tailored to support their learning objectives
and exam preparation. By providing convenient access to study
materials, this feature enhances students' academic performance
and facilitates self-paced learning.

3. Access Learning Modules: - Interactive modules will be available

in all four sections of the IELTS exam: Listening, Reading, Writing,
and Speaking.

4. Give IELTS Practice Test: - The system will offer online mock
exams that closely resemble the actual IELTS exam format.

5. View Own Progress: - The system will enable users to track their
progress by providing performance analytics, scores, and
recommendations for further improvement.

6. Provide Feedback: - Users can submit their writing and speaking

tasks for evaluation by IELTS instructors or tutors. They will receive
detailed feedback, suggestions for improvement, and tips for
achieving higher scores.

202203100110096, 202203100110112, 202203100110117, 202203100110162 5

 Future Study Hub
3.6 Non-functional requirements: -

1. Security: - User data, including personal information and progress tracking,

should be securely stored and protected from unauthorized access.

3.7 Users of the system with their characteristics: -

1. Admin: - These individuals would manage the platform, handle technical
issues, and provide customer support. Their number might be relatively
small compared to the user base.

2. Student: - Students are seeking IELTS exam preparation and higher

education planning.

3. Teacher: - The teacher is responsible for creating and delivering courses.

They can also grade assignments, answer student questions, and provide
feedback.

3.7.1 Number of users: -

1. Admin
2. Teacher
3. Student

202203100110096, 202203100110112, 202203100110117, 202203100110162 6

 4 Future Study
Conceptual Hub Design: -
Diagram
4.1 Use case Diagram: -
4.1.1 List of Users: -
1. Admin
2. Teacher
3. Student

4.1.2 Draw Use case Diagram: -

 Admin: -

 Figure 1: UCD for Admin

202203100110096, 202203100110112, 202203100110117, 202203100110162 7

  Teacher: - Future Study Hub

 Figure 2: UCD for Teacher

202203100110096, 202203100110112, 202203100110117, 202203100110162 8

  Student: - Future Study Hub

 Figure 3: UCD for Student

202203100110096, 202203100110112, 202203100110117, 202203100110162 9

 4.2 Activity Diagram: - Future Study Hub

 Login: -

Figure 4: AD for Login

202203100110096, 202203100110112, 202203100110117, 202203100110162 10

  Registration: - Future Study Hub

Figure 5: AD for Registration

202203100110096, 202203100110112, 202203100110117, 202203100110162 11

 Future Study Hub
 Material File Upload: -

Figure 6: AD for Material File Upload

202203100110096, 202203100110112, 202203100110117, 202203100110162 12

 Future StudyModel:
5 System Hub -

5.1 Prototyping Model Implementation for Our Project: -

1. Model Overview: - In the context of "Future Study Hub," a prototyping

system model can be defined as a preliminary version or mock-up of the
actual system, aimed at validating key functionalities, user interactions, and
design aspects before proceeding to full-scale development. The prototyping
system model serves as a visual representation or simulation of the final
system, allowing stakeholders to provide feedback, identify potential issues,
and refine requirements early in the development process.

2. Reason: -
1. Basic Functionality Representation: - The prototyping system
model includes essential functionalities such as user registration,
login, profile management, access to study materials, practice tests,
feedback submission, and progress tracking. These functionalities
provide a foundation for user interactions and system navigation.

2. User Interface Design: - The prototype features a user-friendly

interface with navigation controls, input fields, buttons, and
interactive elements resembling the final system's design. It focuses
on usability, simplicity, and intuitiveness to enhance user experience.

3. Limited Functionality Implementation: - While the prototype

demonstrates core functionalities, it may not fully implement
backend processes or database interactions. Instead, it utilizes
simulated data or simplified algorithms to mimic system behaviour
and responses.

202203100110096, 202203100110112, 202203100110117, 202203100110162 13

 Future Study Hub
4. Rapid Iterative Development: - The prototyping system model
follows an iterative development approach, allowing for quick
modifications, additions, or refinements based on stakeholder
feedback. It facilitates agile development practices and fosters
collaboration between developers, designers, and end-users.

5. Feedback Collection Mechanism: - The prototype includes

mechanisms for collecting user feedback, comments, and suggestions
during usability testing sessions or demonstrations. This feedback is
crucial for identifying usability issues, improving user flows, and
validating system requirements.

202203100110096, 202203100110112, 202203100110117, 202203100110162 14

 Future
6 Database Design: - Study Hub

6.1 Table with description includes attributes, data type, size, and constraints: -

 admin
Field Name Data Type Constraints Description Example Values
admin_id int(11) NOT NULL, Unique identifier 1, 2, 3
PRIMARY KEY, for the
UNIQUE administrator
admin_name varchar(100 NOT NULL Name of the John Doe, Jane
) administrator Smith
email varchar(100 NOT NULL, Email address of [email address
) UNIQUE the administrator removed], [email
address removed]
password varchar(15) NOT NULL Password of the admin123
administrator

 courses
Field Name Data Type Constraints Description Example Values
course_id int(11) NOT NULL, PRIMARY Unique identifier 1, 2, 3
KEY, for the course
AUTO_INCREMENT
course_name varchar(100) NOT NULL Name of the Introduction to
course Programming,
Database
Management
module_id int(11) NOT NULL ID of the 1, 2, 3
module the
course belongs
to
year year(4) NOT NULL Year the course 2023, 2024
was offered
month varchar(20) NOT NULL Month the January, February,
course was March
offered
price decimal(10,2 NOT NULL Price of the 500.00, 1000.00
) course
description varchar(255) DEFAULT NULL Description of Course covers basic
the course programming
concepts

202203100110096, 202203100110112, 202203100110117, 202203100110162 15

  exam Future Study Hub

Field Name Data Type Constraints Description Example

Values
exam_id int(11) NOT NULL, PRIMARY Unique identifier 1, 2, 3
KEY, for the exam
AUTO_INCREMENT
exam_name varchar(100) NOT NULL Name of the Midterm
exam Exam, Final
Exam
exam_date datetime NOT NULL Date and time 2023-12-25
of the exam 10:00:00
total_marks int(11) NOT NULL Total marks for 100
the exam
passing_mark int(11) DEFAULT NULL Passing marks 60
s for the exam
description varchar(255) DEFAULT NULL Description of Covers
the exam topics from
chapters 1-5
student_id int(11) DEFAULT NULL ID of the 1, 2, 3
student who
took the exam
sub_id int(11) DEFAULT NULL ID of the subject 1, 2, 3
the exam is for

 feedback
Field Name Data Type Constraints Description Example
Values
feedback_id int(11) NOT NULL, PRIMARY Unique identifier 1, 2, 3
KEY, for the feedback
AUTO_INCREMENT
student_id int(11) DEFAULT NULL ID of the student 1, 2, 3
who provided
the feedback
teacher_id int(11) DEFAULT NULL ID of the teacher 1, 2, 3
the feedback is
for
feedback_text varchar(255) DEFAULT NULL Text of the The course
feedback was very
informative.
feedback_dat date DEFAULT NULL Date the 2023-12-25
e feedback was
provided

202203100110096, 202203100110112, 202203100110117, 202203100110162 16

 Future Study Hub

 invoices
Field Name Data Type Constraints Description Example
Values
invoice_id int(11) NOT NULL, PRIMARY Unique 1, 2, 3
KEY, identifier for
AUTO_INCREMENT the invoice
student_id int(11) NOT NULL ID of the 1, 2, 3
student the
invoice is for
invoice_date datetime NOT NULL Date and time 2023-12-
the invoice 25
was generated 10:00:00
due_date datetime NOT NULL Due date for 2023-12-
the invoice 31
10:00:00
total_amount double NOT NULL Total amount 500.00
due on the
invoice
status varchar(100) NOT NULL Status of the unpaid,
invoice (e.g., paid
unpaid, paid,
overdue)
course_id int(11) DEFAULT NULL ID of the 1, 2, 3
course the
invoice is for

202203100110096, 202203100110112, 202203100110117, 202203100110162 17

  li_quiz Future Study Hub
Field Name Data Type Constraints Description Example Values
id int(11) NOT NULL, PRIMARY Unique identifier 1, 2, 3
KEY, for the listening
AUTO_INCREMENT quiz
audio_path varchar(255) DEFAULT NULL Path to the audio/quiz1.mp3
audio file for the
quiz
img_path varchar(255) DEFAULT NULL Path to the image/[Link]
image file for
the quiz
question varchar(255) NOT NULL Question for the What is the capital
quiz of France?
option1 varchar(255) NOT NULL Option 1 for the Paris
quiz
option2 varchar(255) NOT NULL Option 2 for the London
quiz
option3 varchar(255) NOT NULL Option 3 for the Berlin
quiz
option4 varchar(255) NOT NULL Option 4 for the Rome
quiz
correct_answer varchar(255) NOT NULL Correct answer Paris
for the quiz
quiz_id int(11) NOT NULL ID of the quiz 1, 2, 3
the question
belongs to

 material
Field Name Data Type Constraints Description Example Values
material_id int(11) NOT NULL, PRIMARY Unique 1, 2, 3
KEY, identifier for
AUTO_INCREMENT the material
material_nam varchar(100 NOT NULL Name of the Lecture Notes,
e ) material Assignment 1
description varchar(255 DEFAULT NULL Description of Notes on Chapter 2
) the material
sub_id int(11) DEFAULT NULL ID of the 1, 2, 3
subject the
material is for
pdf_path varchar(255 DEFAULT NULL Path to the pdf/lecture_notes.pdf
) PDF file for
the material

202203100110096, 202203100110112, 202203100110117, 202203100110162 18

 Future Study Hub
 module
Field Name Data Type Constraints Description Example
Values
module_id int(11) NOT NULL, Unique 1, 2, 3
PRIMARY KEY, identifier for
AUTO_INCREMENT the module
module_name varchar(30) NOT NULL Name of the Introduction to
module Programming,
Database
Management
description varchar(255 DEFAULT NULL Description Covers basic
) of the programming
module concepts

 notice
Field Name Data Type Constraints Description Example Values
id int(11) NOT NULL, PRIMARY Unique 1, 2, 3
KEY, identifier for
AUTO_INCREMENT the notice
noticeTitle varchar(255) DEFAULT NULL Title of the Important
notice Announcement
noticeDetails mediumtext DEFAULT NULL Details of the The upcoming
notice exam has been
rescheduled.
Date timestamp NULL DEFAULT Date and 2023-12-25
current_timestamp() time the 10:00:00
notice was
created

 onetimepassword

Field Data Type Constraints Description Example

Name Values

id int(11) NOT NULL, PRIMARY Unique identifier for 1, 2, 3

KEY, AUTO_INCREMENT the one-time
password
mail varchar(255 NOT NULL Email address [email
) associated with the address
one-time password removed]
otp varchar(255 NOT NULL One-time password 123456
)

202203100110096, 202203100110112, 202203100110117, 202203100110162 19

 Future Study Hub

202203100110096, 202203100110112, 202203100110117, 202203100110162 20

 Future Study Hub
 payment
Field Name Data Type Constraints Description Example
Values
payment_id int(11) NOT NULL, Unique 1, 2, 3
PRIMARY KEY, identifier for
AUTO_INCREMENT the payment
student_id int(11) DEFAULT NULL ID of the 1, 2, 3
student who
made the
payment
amount double NOT NULL Amount of 500.00,
the payment 1000.00
payment_dat datetime DEFAULT NULL Date and 2023-12-
e time the 25
payment was 10:00:00
made
status varchar(100 DEFAULT NULL Status of the successful,
) payment failed
(e.g.,
successful,
failed)
method_id int(11) DEFAULT NULL ID of the 1, 2, 3
payment
method used
course_id int(11) DEFAULT NULL ID of the 1, 2, 3
course the
payment is
for

 payment_methods
Field Name Data Type Constraints Description Example
Values
method_id int(11) NOT NULL, PRIMARY Unique 1, 2, 3
KEY, identifier for
AUTO_INCREMENT the payment
method
method_name varchar(100) NOT NULL Name of the Credit
payment Card,
method Debit Card
description varchar(255) DEFAULT NULL Description of Payment
the payment using a
method credit card

202203100110096, 202203100110112, 202203100110117, 202203100110162 21

 Future Study Hub
 progress
Field Name Data Constraints Description Example
Type Values
id int(11) NOT NULL, PRIMARY Unique identifier 1, 2, 3
KEY, for the progress
AUTO_INCREMENT record
student_id int(11) DEFAULT NULL ID of the student 1, 2, 3
video_id int(11) DEFAULT NULL ID of the video 1, 2, 3
watched_duratio float DEFAULT NULL Duration of the 1.5, 3.0
n video watched
last_watched timestamp NOT NULL DEFAULT Timestamp of the 2023-12-25
current_timestamp() last time the 10:00:00
video was
watched

 quiz
Field Data Type Constraints Description Example
Name Values
quiz_id int(11) NOT NULL, PRIMARY Unique identifier for 1, 2, 3
KEY, AUTO_INCREMENT the quiz
title varchar(255) NOT NULL Title of the quiz Midterm
Quiz, Final
Quiz
module_id int(11) NOT NULL ID of the module 1, 2, 3
the quiz belongs to
sub_id int(11) NOT NULL ID of the subject 1, 2, 3
the quiz is for
total int(11) NOT NULL Total number of 10
questions in the
quiz
right_mark int(11) NOT NULL Marks awarded for 1
each correct
answer
wrong int(11) NOT NULL Marks deducted for 0
each incorrect
answer

202203100110096, 202203100110112, 202203100110117, 202203100110162 22

 Future Study Hub
 re_quiz
Field Name Data Type Constraints Description Example Values
id int(11) NOT NULL, Unique 1, 2, 3
PRIMARY KEY, identifier for
AUTO_INCREMENT the reading
comprehensio
n quiz
title varchar(255) NOT NULL Title of the Reading
reading Comprehension Quiz
comprehensio
n quiz
img_path varchar(255) NOT NULL Path to the image/reading_quiz.jpg
image file for
the quiz
text varchar(255) NOT NULL Text of the The passage
reading discusses...
passage
option1 varchar(255) NOT NULL Option 1 for Option A
the quiz
option2 varchar(255) NOT NULL Option 2 for Option B
the quiz
option3 varchar(255) NOT NULL Option 3 for Option C
the quiz
option4 varchar(255) NOT NULL Option 4 for Option D
the quiz
correct_answe varchar(255) NOT NULL Correct answer Option A
r for the quiz
quiz_id int(11) NOT NULL ID of the quiz 1, 2, 3
the question
belongs to

202203100110096, 202203100110112, 202203100110117, 202203100110162 23

 Future Study Hub
 student
Field Name Data Type Constraints Description Example
Values
student_id int(11) NOT NULL, PRIMARY Unique identifier 1, 2, 3
KEY, for the student
AUTO_INCREMENT
student_name varchar(100 NOT NULL Name of the John Doe, Jane
) student Smith
email varchar(100 NOT NULL, UNIQUE Email address of [email address
) the student removed], [email
address
removed]
dob date NOT NULL Date of birth of 1995-01-01
the student
password varchar(8) NOT NULL Password of the admin123
student
contact_no int(11) NOT NULL Contact number 1234567890
of the student
gender varchar(7) NOT NULL Gender of the Male, Female
student
enrollment_dat date DEFAULT Date the student 2023-12-25
e current_timestamp() enrolled
validation varchar(50) NOT NULL Validation code 123456
for the student
module_id int(11) DEFAULT NULL ID of the module 1, 2, 3
the student is
enrolled in

 subject
Field Data Type Constraints Description Example Values
Name
sub_id int(11) NOT NULL, PRIMARY Unique identifier 1, 2, 3
KEY, for the subject
AUTO_INCREMENT
sub_name varchar(100) NOT NULL Name of the Introduction to
subject Programming,
Database
Management
module_id int(11) DEFAULT NULL ID of the module 1, 2, 3
the subject
belongs to
description varchar(255) DEFAULT NULL Description of Covers basic
the subject programming
concepts

202203100110096, 202203100110112, 202203100110117, 202203100110162 24

 Future Study Hub

 teacher
Field Name Data Type Constraints Description Example Values
teacher_id int(11) NOT NULL, PRIMARY Unique identifier 1, 2, 3
KEY, for the teacher
AUTO_INCREMENT
teacher_name varchar(100) NOT NULL Name of the John Doe, Jane
teacher Smith
email varchar(100) NOT NULL, UNIQUE Email address of [email address
the teacher removed], [email
address removed]
contact_no int(11) NOT NULL Contact number 1234567890
of the teacher
gender varchar(7) NOT NULL Gender of the Male, Female
teacher
dob date NOT NULL Date of birth of 1995-01-01
the teacher
validation varchar(100) NOT NULL Validation code 123456
for the teacher
course_field varchar(100) NOT NULL Course field of Computer Science,
the teacher Mathematics
password varchar(30) NOT NULL Password of the admin123
teacher
module_id int(11) DEFAULT NULL ID of the module 1, 2, 3
the teacher
teaches
module_name varchar(20) NOT NULL Name of the Introduction to
module the Programming,
teacher teaches Database
Management
hire_date datetime DEFAULT NULL Date and time 2023-12-25
the teacher was 10:00:00
hired

202203100110096, 202203100110112, 202203100110117, 202203100110162 25

 Future Study Hub

 teacher_requests
Field Name Data Type Constraints Description Example Values
id int(11) NOT NULL, PRIMARY Unique identifier 1, 2, 3
KEY, for the teacher
AUTO_INCREMENT request
teacher_name varchar(100 NOT NULL Name of the John Doe, Jane
) teacher Smith
email varchar(100 NOT NULL, UNIQUE Email address of [email address
) the teacher removed], [email
address removed]
contact_no int(11) NOT NULL Contact number 1234567890
of the teacher
gender varchar(7) NOT NULL Gender of the Male, Female
teacher
dob date NOT NULL Date of birth of 1995-01-01
the teacher
validation varchar(100 NOT NULL Validation code 123456
) for the teacher
course_field varchar(100 NOT NULL Course field of Computer
) the teacher Science,
Mathematics
password varchar(30) NOT NULL Password of the admin123
teacher
module_id int(11) DEFAULT NULL ID of the module 1, 2, 3
the teacher
wants to teach
module_name varchar(20) NOT NULL Name of the Introduction to
module the Programming,
teacher wants to Database
teach Management
hire_date datetime DEFAULT NULL Date and time 2023-12-25
the teacher was 10:00:00
hired

202203100110096, 202203100110112, 202203100110117, 202203100110162 26

 Future Study Hub

 teacher_suggestions
Field Data Constraints Description Example
Name Type Values
id int(11) NOT NULL, PRIMARY Unique identifier 1, 2, 3
KEY, for the teacher
AUTO_INCREMENT suggestion
student_id int(11) DEFAULT NULL ID of the student 1, 2, 3
the suggestion is
for
teacher_id int(11) DEFAULT NULL ID of the teacher 1, 2, 3
who made the
suggestion
suggestion text DEFAULT NULL Suggestion made You should
by the teacher improve your
pronunciation.
timestamp timestamp NOT NULL DEFAULT Timestamp of 2023-12-25
current_timestamp() when the 10:00:00
suggestion was
made
video_id int(11) DEFAULT NULL ID of the video the 1, 2, 3
suggestion is for

 topics
Field Name Data Type Constraints Description Example
Values
topic_numbe int(11) NOT NULL, PRIMARY Unique 1, 2, 3
r KEY, identifier for
AUTO_INCREMENT the topic
topic_name varchar(255) NOT NULL Name of the Programming
topic Fundamentals,
Database Design
description text DEFAULT NULL Description of Covers basic
the topic programming
concepts

202203100110096, 202203100110112, 202203100110117, 202203100110162 27

 Future Study Hub

 transactions

Field Name Data Type Constraints Description Example

Values
transaction_id int(11) NOT NULL, Unique 1, 2, 3
PRIMARY KEY, identifier for
AUTO_INCREMENT the transaction
payment_id int(11) NOT NULL ID of the 1, 2, 3
payment
associated
with the
transaction
transaction_date datetime NOT NULL Date and time 2023-12-25
of the 10:00:00
transaction
amount double NOT NULL Amount of the 500.00,
transaction 1000.00
status varchar(100) NOT NULL Status of the successful,
transaction failed
(e.g.,
successful,
failed)
transaction_referenc varchar(255) NOT NULL Reference TXN123456
e number for the
transaction

202203100110096, 202203100110112, 202203100110117, 202203100110162 28

 Future Study Hub

 videos

Field Name Data Type Constraints Descriptio Example Values

n
video_id int(11) NOT NULL, Unique 1, 2, 3
PRIMARY KEY, identifier for
AUTO_INCREMENT the video
video_title varchar(255) NOT NULL Title of the Introduction to Programming
video
description text DEFAULT NULL Description Video covers basic programming
of the video concepts
subject int(11) NOT NULL ID of the 1, 2, 3
subject the
video is for
module int(11) NOT NULL ID of the 1, 2, 3
module the
video
belongs to
topic_numbe int(11) NOT NULL ID of the 1, 2, 3
r topic the
video is
related to
video_path varchar(255) NOT NULL Path to the video/introduction_to_programming.mp4
video file
teacher_id int(11) NOT NULL ID of the 1, 2, 3
teacher who
uploaded
the video
created_at timestamp NOT NULL Timestamp 2023-12-25 10:00:00
DEFAULT of when the
current_timestamp() video was
created

202203100110096, 202203100110112, 202203100110117, 202203100110162 29

 Future Study Hub

 wr_quiz

Field Name Data Type Constraints Description Example Values

id int(11) NOT NULL, PRIMARY KEY, Unique identifier 1, 2, 3
AUTO_INCREMENT for the writing quiz
question varchar(255 NOT NULL Question for the Write an essay on
) writing quiz the topic of climate
change.
option1 varchar(255 NOT NULL Option 1 for the Option A
) quiz
option2 varchar(255 NOT NULL Option 2 for the Option B
) quiz
option3 varchar(255 NOT NULL Option 3 for the Option C
) quiz
option4 varchar(255 NOT NULL Option 4 for the Option D
) quiz
correct_answer varchar(255 NOT NULL Correct answer for Option A
) the quiz
quiz_id int(11) NOT NULL ID of the quiz the 1, 2, 3
question belongs
to

6.2 Number of tables: -

 Total Tables

202203100110096, 202203100110112, 202203100110117, 202203100110162 30

 Future
7 UserStudy Hub
Interface Design
7.1 Screenshot of Homepage: -

Figure 7: Home Page

7.1.1 Used navigation control with justification: - The navigation bar at the top
of the page helps users interact with the website more easily. It has links to
important sections like "Home," "Exam," "IELTS," and "Material." This makes
it quick and simple for users to move around the website and find
information they need. The navigation bar makes it easier for users to use
the website and find what they're looking for.

202203100110096, 202203100110112, 202203100110117, 202203100110162 31

 7.2 Screenshot of UI: - Future Study Hub
1. Sign Up Page: -

Figure 8: Sign Up Page

 Purpose of the UI: - The purpose of the signup page for Future Study
Hub is to collect essential user information, such as name, email,
password, phone number, gender and file upload to create a new user
account and enable access to the system services. After click submit
button filled all data store in our system’s database.

202203100110096, 202203100110112, 202203100110117, 202203100110162 32

  Future Study Hub
Used control with justification: -
o Text Input Fields (User Name, Email, Password, Phone No,
Gender, File Upload): - These blank spaces are where you type
in important information like your name, email, and password.
They are important because we need this data to set up your
account.
o "Sign Up" Button: - When you click on this button, it's like
saying, "I'm ready!" It's the start button for signing up.
o Login Here Link: - If you already have an account, you can click
on this to go to the login page. It's a way for people who are
already members to get back in.

202203100110096, 202203100110112, 202203100110117, 202203100110162 33

 2. Login Page: - Future Study Hub

Figure 9: Login Page

 Purpose of the UI: - The purpose of the login page for Future Study Hub is
to allow users to access their accounts by entering their email address and
password, while the "Forgot Password" feature is designed to help users
reset their forgotten passwords and regain access to their accounts.
 Used control with justification: -
o Email and Password Fields: - These are where users type in their
email and password. They're important because we need this
information to let users log in.
o Submit Button: - When users click this button, it's like saying, "I'm
ready to log in." It's important because it starts the login process once
they've entered their email and password.

202203100110096, 202203100110112, 202203100110117, 202203100110162 34

 3. Course: - Future Study Hub

Figure 10: Courses

 Purpose of the UI: - The purpose of subjects is providing a user-friendly

interface for managing academic and general subjects efficiently. It offers
features like to select subject and open that subject along with essential
details such as subject name, description, and associated modules.

202203100110096, 202203100110112, 202203100110117, 202203100110162 35

 Future
8 Study Hub -
Dashboard:

 Admin Dashboard: -

 Student Registration Report Date Wise: -

202203100110096, 202203100110112, 202203100110117, 202203100110162 36

 Future Study Hub

 Student Registration Report Date Wise: -

202203100110096, 202203100110112, 202203100110117, 202203100110162 37

 Future
9 Study Hub-
Test Case:
 Add To Material Test Case: -

Example 1 Example 2 Example 3 Example 4

Test Case Id T_01 T_01 T_01 T_01

Test Case
Add Materials Add Materials Add Materials Add Materials
Summary
Related
Requirement RS001 RS002 RS003 RS004
prerequisites 1. XAMPP 1. XAMPP 1. XAMPP 1. XAMPP
Test Step 1. Tester select 1. Tester select 1. Tester select 1. Tester select
Material. Material. Material. Material.
2. Tester click on 2. Tester click on 2. Tester click on 2. Tester click on
add Material add Material add Material add Material
Button for add Button for add Button for add Button for add
material. material. material. material.
3. Tester view, 3. Tester view, 3. Tester view, 3. Tester view,
update, delete update, delete update, delete update, delete
material. material. material. material.

Test Data 1. Selected 1. Selected 1. Selected 1. Selected

Material add Material not add. Material not add. Material not add.
Successfully. 2. On click on add 2. On click on add 2. On click on add
2. On click on add button material button material button material
button material add. not add. add.
add. 3. Upload 3. Upload 3. Upload
3. Upload materials show materials show materials not
materials show and perform any and perform any show and not
and perform any operation on that operation on perform any
operation on that like update or that like update operation on that
like update or delete. or delete. like update or
delete. delete.
Expected Result Add material Add material Add material Add material
show and perform show and perform show and show and perform
operations on operations on perform operations on
them like update them like update operations on them like update
or delete. or delete. them like update or delete.
or delete.
Actual Result Add material Material was not Add button not Uploaded
show and perform selected that’s work so that materials not
operations on why not add. material not add work update or
them like update delete operation.
or delete.
Status Pass Fail Fail Fail

202203100110096, 202203100110112, 202203100110117, 202203100110162 38

  Generate Report: - Future Study Hub
Example 1 Example 2 Example 3 Example 4

Test Case Id T_01 T_01 T_01 T_01

Test Case Generate Report. Generate Report. Generate Report. Generate Report.
Summary
Related
RS001 RS002 RS003 RS004
Requirement
Prerequisites 1. XAMPP 1. XAMPP 1. XAMPP 1. XAMPP
Test Step 1. Tester select 1. Tester select 1. Tester select 1. Tester select
date. date. date. date.
2. Tester click on 2. Tester click on 2. Tester click on 2. Tester click on
generate report generate report generate report generate report
button. button. button. button.
3. Tester view 3. Tester view 3. Tester view 3. Tester view
selected date selected date selected date selected date
report. report. report. report.
Test Data 1. Date select. 1. Date not select. 1. Date select. 1. Date select.
2. click on 2. click on generate 2. click on 2. click on
generate button button report generate button generate button
report generated. generated. report not report generated.
3. selected 3. selected date generated. 3. selected
date report report show. 3. selected date report not
show. date report show.
show.
Expected Result Click on generate Click on generate Click on generate Click on generate
button selected button selected button selected button selected
date report show. date report show. date report date report show.
show.
Actual Result Click on generate Date not selected Click on Selected date not
button selected that’s why click on generate button any data in
date report show. generate button report not database that’s
report not show. generated. why not report
show.
Status Pass Fail Fail Fail

202203100110096, 202203100110112, 202203100110117, 202203100110162 39

  Feedback: - Future Study Hub
Example 1 Example 2 Example 3 Example 4

Test Case Id T_01 T_01 T_01 T_01

Test Case submit feedback submit feedback submit feedback submit feedback
Summary
Related RS001 RS002 RS003 RS004
Requirement
Prerequisites 1. XAMPP 1. XAMPP 1. XAMPP 1. XAMPP
Test Step 1. tester 1. tester 1. tester 1. tester
write write write write
feedback feedback feedback feedback
2. tester 2. tester 2. tester 2. tester
submit submit submit submit
feedback feedback feedback feedback
tester see tester see tester see tester see
feedback that feedback that feedback that feedback that
submitted submitted submitted submitted
successfully successfully successfully successfully
Test Data 1. feedback is 1. feedback 1. feedback 1. feedback
not written written written written
2. submit successfully successfully. successfully.
button is 2. submit button 2. submit 2. submit
work is not work button button is
3. show feedback 3. show feedback work work
on admin on admin 3. feedback 3. show feedback
not on admin
show on admin
Expected Result Show feedback to Show feedback to Show feedback to Show feedback to
admin admin admin admin
Actual Result feedback not show feedback not admin not Show feedback
submit on click on see feedback
button
Status Pass Fail Fail Fail

202203100110096, 202203100110112, 202203100110117, 202203100110162 40