Dbms Sce
Dbms Sce
Dbms Sce
PROJECT REPORT ON
ENGINEERING
Under Guidance of
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:
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:
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.
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.
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.
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
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:
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