COLLAGE PLACEMENT MANAGEMENT SYSTEM.pptx

DataBase management System

1. COLLAGE PLACEMENT MANAGEMENT SYSTEM

2. Micro project COLLAGE PLACEMENT MANAGEMENT SYSTEM SUBMITED BY:- ARCHIT KADU SOHAM DAINE AYUSH MANDERKAR CHAITANYA CHOPADE DEPARTMENT ON COMPUTER SCIENCE

3. INDEX Introduction Database Requirements Existing system Proposed system System architecture Class diagram Activity diagram System requirement Conclusion

4. INTRODUCTION The College Placement Management System is a DBMS-based project designed to simplify and streamline the process of managing student placements within a college or university. The traditional approach to handling placement-related data—such as student details, company profiles, job openings, eligibility criteria, and placement results—can be time-consuming and prone to errors when done manually. This project aims to digitize and organize these processes using a structured relational database model. The system enables placement officers to maintain up-to-date records of registered students, participating companies, and job offers. It allows for quick retrieval and manipulation of data through efficient SQL queries, ensuring smooth coordination between students and recruiters. Students can also track their placement status, apply to eligible companies, and receive updates on interview schedules. This project not only demonstrates the practical application of core DBMS concepts such as ER modeling , normalization , SQL queries , and data integrity , but also addresses real-world challenges in managing placement data, making it a valuable tool for educational institutions.

5. Database Requirements The system must store and manage the following types of data: 🔹 Student Data Unique Student ID Name Department/Branch Contact Details (Phone, Email) Academic Information (CGPA, Pass-out Year) 🔹 Company Data Unique Company ID Company Name Job Role Offered Package Offered (in LPA) Eligibility Criteria (minimum CGPA) Job Location Date of Visit/Drive 🔹 Application Data Application ID Student ID (Foreign Key) Company ID (Foreign Key) Date of Application Application Status (Applied / Selected / Rejected)

6. Existing system In most colleges and universities, the placement process is still managed using manual or semi-digital systems , which have several limitations. The existing system typically relies on tools like Excel sheets , email communication , and paper-based records . Placement officers collect student details and company requirements manually and coordinate the entire process without an integrated database. Characteristics of the Existing System Manual Data Entry Student details, academic records, and company criteria are often entered manually into spreadsheets or paper files, increasing the risk of errors and data inconsistency. No Centralized Database There is no single platform to access student applications, company profiles, or placement status. Data is scattered across files and folders. Difficult to Track Applications Tracking which student applied to which company and their status (selected/rejected) is time-consuming and inefficient. Limited Reporting Capabilities Generating reports like lists of eligible students, placed/unplaced students, or company visit schedules is complex and slow. High Dependency on Placement Officers Students depend entirely on placement officers for updates and can't access or update their own application status in real-time. Communication Delays

7. Proposed System The proposed College Placement Management System is a database-driven solution designed to automate and streamline the entire placement process in a college or university. It eliminates the inefficiencies of the existing manual or semi-digital system by implementing a centralized, structured, and easily accessible database. Objectives of the Proposed System Maintain a centralized database of students, companies, and applications. Enable efficient data storage, retrieval, and manipulation using SQL. Ensure data integrity, accuracy, and consistency through normalization and constraints. Simplify the tracking of student applications and placement status . Support generation of quick reports and eligibility lists for placement officers. Provide real-time access to placement data for better decision-making.

8. Key Features of the Proposed System Student Management Store personal and academic information. Automatically check eligibility for companies based on CGPA and other criteria. Company Management Register new companies with job role, package, criteria, and visit date. Store and retrieve company profiles easily. Application Tracking Track which student applied to which company. Update and monitor application status: Applied, Selected, or Rejected. Placement Records Record final placements and generate placed/unplaced student reports. Prevent multiple placements for one student (if required by policy). Report Generation Generate customized reports like: Eligible students for a specific company. Students placed in a particular department. Companies offering the highest packages. Technology Used Database : MySQL / PostgreSQL / SQLite (as per project scope) Frontend (Optional) : C / Python / Web (if required) Backend Logic (Optional) : SQL queries or integration with an application ER Model : Used to design entity relationships before schema creation

9. System architecture +------------------------+ | User Interface (UI) | |------------------------| | - Student Portal | | - Placement Officer UI | +------------------------+ | ↓ +------------------------+ | Application Layer | |------------------------| | - Eligibility Check | | - Application Status | | - Data Validation | +------------------------+ | ↓ +------------------------+ | Database Layer | |------------------------| | - Student Table | | - Company Table | | - Application Table | | - (Optional) Placement | +------------------------+

10. Class diagram | Student | +---------------------+ | student_id : int | | name: string | | cgpa : float | +---------------------+ ▲ | | +---------------------+ | Application | +---------------------+ | application_id : int | | status: string | +---------------------+ ▲ | | +---------------------+ | Company | +---------------------+ | company_id : int | | name: string | | criteria_cgpa : float|

11. System requirement Hardware Requirements Component Minimum Requirement Recommended Requirement Processor Intel Core i3 or equivalent Intel Core i5 or above RAM 2 GB 4 GB or higher Hard Disk 500 MB free space 1 GB free space Display 1024×768 resolution 1366×768 or higher

12. Software Requirements Category Specification Operating System Windows 7 / 8 / 10 / 11, Linux, or macOS Front-End HTML, CSS, JavaScript / PHP / Python Flask / Java Swing (as per your project) Back-End MySQL / Oracle / PostgreSQL / SQLite Server (if web-based) XAMPP / WAMP / Apache Tomcat / Flask Server Database Tool MySQL Workbench / phpMyAdmin Code Editor Visual Studio Code / NetBeans / PyCharm / Eclipse

13. Conclusion The College Placement Management System provides an efficient and organized way to manage all placement-related activities within a college. It reduces the manual work of maintaining student and company records by storing and processing data systematically in a database. Through this system, students can easily register for placements, view available company drives, and track their status, while administrators can manage company details, student eligibility, and placement schedules effectively. This project demonstrates the practical application of Database Management System (DBMS) concepts such as data storage, retrieval, relationships, and normalization. It ensures data consistency, accuracy, and accessibility for all users. Overall, the project helps in streamlining the placement process , saving time and effort for both students and the placement department, and serves as a valuable step toward digital automation in educational institutions.