Dbms Sce

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 19

BRACT’s Vishwakarma Institute of Information Technology

PROJECT REPORT ON

INTERNSHIP MANAGEMENT SYSTEM


DEPARTMENT OF

COMPUTER SCIENCE AND

ENGINEERING

(ARTIFICIAL INTELLIGENCE AND MACHINE


LEARNING)

Sr No. Name Email Id

1 Tanishk Singh [email protected]

2 Vipul Khandelwal [email protected]

Under Guidance of

Dr. Rutuja Kadam

1 Top of the
Document
INDEX:

ABSTRACT.................................................................................................................................................3
INTRODUCTION:.......................................................................................................................................4
METHODOLOGY......................................................................................................................................5
OBJECTIVES...............................................................................................................................................7
ER DIAGRAM:............................................................................................................................................9
UML DIAGRAMS:...................................................................................................................................11
SCREENSHOTS OF GUI:.........................................................................................................................14
FUTURE SCOPE.......................................................................................................................................18
CONCLUSION:.................................................................................................................19

2 Top of the
Document
ABSTRACT :
The Internship Management System (IMS) is a pivotal tool devised
to efficaciously orchestrate the intricate processes entailed in
administering internship programs within an organizational
framework. This project report delineates the development and
deployment of IMS, tailored to optimize the orchestration of intern
matching, monitoring, and support mechanisms, thereby augmenting
the internship experience for both interns and participating entities.
Through the adept utilization of contemporary technology and
methodological precision, IMS aims to streamline the intern
lifecycle, rendering it an indispensable asset in contemporary
organizational contexts.

3 Top of the
Document
INTRODUCTION:

Internship programs serve as a pivotal conduit bridging


academic theory with real-world applicability, affording
students invaluable opportunities to translate conceptual
knowledge into practical proficiency. However,
managing internship programs often poses formidable
challenges, encompassing multifaceted processes
including intern matching, onboarding, performance
assessment, and feedback management. The Internship
Management System expounded herein endeavors to
surmount these obstacles by furnishing a centralized
platform to navigate the complexities inherent in
managing internships comprehensively.

4 Top of the
Document
METHODOLOGY:

Requirement Analysis:

The initial phase involves comprehensive stakeholder engagement to discern the overarching
requirements and functionalities expected of the internship management system. This process
entails eliciting input from interns, organizational stakeholders, administrators, and other
pertinent parties to ascertain the full spectrum of system requisites.

System Design:
Subsequent to requirements gathering, the system design phase ensues, wherein
the architectural blueprint of IMS is conceptualized and delineated. This phase
encompasses the creation of system diagrams, such as the Entity-Relationship (ER)
diagram and Unified Modeling Language (UML) diagrams, to elucidate the system's
structure, components, and interactions.

Design Phase:

User Interface Design:


Produce wireframes and mockups of the website's user interface, emphasizing
easy-to-use navigation, logical arrangement, and eye-catching styling. Take
stakeholder input into consideration to improve the design concepts.

Database Design:
Create the database schema needed to hold user data, course information, research
publications, faculty biographies, and other pertinent data. Describe the connections
between various database objects and set limits on data integrity. Phase of Development

Development Phase:

Frontend:
Use HTML, CSS, JavaScript, jQuery, and Bootstrap to implement the website'sfrontend
elements. Create web pages that are responsive to various screen sizes and devices. Based
on the authorized design principles, incorporate interactive features, navigation menus,
and design components.

5 Top of the
Document
Backend:
On the backend, the website employs SQL (Structured Query Language) for database
management. SQL enables efficient storage, retrieval, and manipulation of data, crucial
for handling faculty profiles, research publications, and course information.

Connectivity:
The connectivity between the frontend and backend is facilitated by PHP (Hypertext
Preprocessor), a server-side scripting language. PHP interacts with the SQL database,
processes user requests, and dynamically generates HTML content to be displayed on the
website. XAMPP, a free and open-source cross-platform web server solution, is utilized
to create a local development environment, ensuring seamless integration and testing of
PHP scripts with the Apache server, MySQL database, and other components.

Testing and Quality Assurance:

Rigorous testing procedures are integral to ensure the reliability, functionality, and
performance of the internship management system. Various testing methodologies, including unit
testing, integration testing, and user acceptance testing, are employed to identify and rectify any
defects or discrepancies in the system.

Deployment and Launch:

Upon successful completion of testing and quality assurance procedures, the internship
management system is deployed into the production environment. This phase involves the installation,
configuration, and setup of the system infrastructure, ensuring seamless integration with existing
organizational frameworks and IT infrastructure.

Post-Deployment Support:

Following deployment, ongoing support and maintenance are provided to address any issues,
updates, or enhancements required for the internship management system. This entails the provision of
technical assistance, bug fixes, and system optimizations to ensure the continued efficacy and reliability
of IMS in meeting organizational needs.

6 Top of the
Document
Fig.flowchart for the process

7 Top of the
Document
OBJECTIVES:
To engender an intuitive user interface conducive to seamless
interaction for interns, organizations, and administrators alike.

To automate the intern matching process predicated upon


discernible criteria encompassing skill proficiencies, academic
inclinations, and temporal availability.

To provision comprehensive instrumentation for monitoring intern


progress, including task allocation, performance evaluations, and
feedback solicitation.

To facilitate efficacious communication and collaboration among


interns, supervisors, and administrative personnel.

To fortify data sanctity, confidentiality, and integrity through the


deployment of robust authentication, authorization,
and encryption protocols.

8 Top of the
Document
ER DIAGRAM:

9 Top of the
Document

• Employer:
• Attributes: id (primary key), nameOfCompany, aboutCompany, email, password, address1,
address2, city, state, zipcode, phone, country, ip, date.
• Description: This entity represents employers who have posted internships on the platform. Each
employer has a unique identifier (id) and provides details about their company, including its name,
description, contact information, and location.
• Internships:
• Attributes: id (primary key), emp_id (foreign key referencing Employer.id), category, postedOn,
applyBy, nameOfCompany, aboutCompany, aboutInternship, location, perks, duration, stipend,
positions, whoCanApply, featured, deleted.
• Description: This entity represents internships posted by employers. Each internship has a unique
identifier (id) and is associated with an employer (emp_id). It contains details such as the internship
category, posting and application deadlines, internship description, location, perks, duration, stipend,
available positions, eligibility criteria, and status (featured/deleted).
• Applications:
• Attributes: id (primary key), cus_id (foreign key referencing Customers.id), int_id (foreign key
referencing Internships.id), applied.
• Description: This entity represents internship applications submitted by customers. Each
application has a unique identifier (id) and is associated with a customer (cus_id) and an
internship (int_id). It includes a flag (applied) indicating whether the application has been
submitted.
• Users:
• Attributes: id (primary key), full_name, email, password, permission, join_date, last_login.
• Description: This entity represents users who have registered on the platform. It includes both
customers and employers. Each user has a unique identifier (id) and provides login credentials,
personal details, permissions, and login activity

The relationships between these entities are as follows:


• Customers and Applications: One-to-Many (A customer can submit multiple internship applications.)
• Employers and Internships: One-to-Many (An employer can post multiple internships.)
• Internships and Applications: One-to-Many (An internship can receive multiple applications.)
• Users and Customers: One-to-One (Each user can be associated with only one customer.)
• Users and Employers: One-to-One (Each user can be associated with only one employer.)

10 Top of the
Document
11 Top of the
Document
12 Top of the
Document
13 Top of the
Document
SCREENSHOTS OF GUI:

14 Top of the
Document
15 Top of the
Document
16 Top of the
Document
17 Top of the
Document
FUTURE SCOPE:

The future trajectory of IMS encompasses:

Integration of AI and machine learning algorithms to proffer personalized internship recommendations


and granular performance analytics.
Facilitation of remote internship management leveraging virtual collaboration tools and
telecommuting provisions.
Implementation of blockchain technology to bolster credential verification and preempt
instances of fraudulent representation.
Expansion of the system's purview to encompass international internship placements and cross-
cultural exchange initiatives.
Augmentation of career development resources, including resume optimization utilities,
interview acumen guides, and networking enablers.

18 Top of the
Document
CONCLUSION:

the Internship Management System stands as a vanguard innovation poised to revolutionize the
landscape of internship administration within organizational precincts. Through judicious utilization of
cutting-edge technology, methodological rigor, and a steadfast commitment to user- centric design, IMS
emerges as a quintessential instrumentality in navigating the dynamic contours of contemporary
internship paradigms. By espousing a culture of perpetual refinement and adaptability, IMS is poised to
etch an indelible imprint upon the modus operandi underpinning internship administration, ushering forth
an epoch of unparalleled efficacy and innovation in this pivotal domain.

19 Top of the
Document

You might also like