COLLEGE MANAGEMENT SYSTEM

Overview-
College Management System deals with all kind of student details, academic related
reports, college details, course details, curriculum, batch details and other resource related
details too. It tracks all the details of a student from the day one to the end of his course
which can be used for all reporting purpose.
The College management system is an automated version of manual Student Management
System. It can handle all details about a student. The details include college details, subject
details, student personnel details, academic details, exam details etc... In case of manual
system, they need a lot of time, manpower etc

Synopsis
Introduction
The "College Management System has been developed to override the problems prevailing in the
practicing manual system. This software is supported to eliminate and in some cases reduce the
hardships faced by this existing system. Moreover thissystem is designed for the particular need
oothe company to carry out operations in asmooth and effective manner

The application in reduced as much as possible to avoid errors while entering the data.It also
provides error message while entering invalid data. No formal knowledge is needed for the user to
use this system. Thus by this all it proves it is user-friendly College Management System, as
described above, can lead to error free, secure,reliable and fast management system, it can assist
the user to concentrate on theirother activities rather to concentrate on the record keeping Thus it
will help organizationin better utilization of resources.

Every organization, whether big or small, has challenges to overcome and managing the
information of Course College, Faculty, Exam, Students Every College Management System has
different College needs, therefore we design exclusive employee management systems that are
adapted to your managerial requirements This is designed to assist in strategic planning, and will
help you ensure that your organization is equipped with the right level of information and details
for your future goals. Also, for those busy executive who are always on the go, our systems come
with remote access features, which will allow you to manage your workforce anytime, at all times.
These systems will ultimately allow you to better manage resources
 Specifications
 The various searching facilities are available in this college management system such

as searching the book and author name in the library table.

 A lecturer can able to see the records of all the students as well as the lecturer

himself.

 It also shows proctor details of the studen.

 It can add new students data.

 The improvement of updating and editing records is possible by using the data base

management system.

Available features

 LOGIN PAGE

 SIGN IN PAGE FOR OLD STUDENTS AND FACULTIES

 SIGN UP PAGE FOR NEW STUDENTS AND FACULTIES

 STUDENTS DETAILS

 FACULTIES DETAILS

 STUDENT PROFILE

 FACULTY PROFILE

 STUDENT RECORDS

 FACULTY RECORDS

 MESS MENU

 PROGRAM DETAILS

 CLUBS DETAILS

 LIBRARY DETAILS
Input Data and Validation of Project
on College Management System
 All the fields such as College, Batch, Students are validated and does

not take invalid values

 Each form for College, Course, Exam cannot accept blank value fields

 Avoiding errors in data

 Controlling amount of input

 integration of all the modules/forms in the system.

 Preparation of the test cases.

 Preparation of the possible test data with all the validation checks

 Actual testing done manually

 Recording of all the reproduced errors.

 Modifications done for the errors found during testing.

 Prepared the test result scripts after rectification of the errors.

 Functionality of the entire Module form

 Validations for user input

 Checking of the Coding standards to be maintained during coding

 Testing the module with all the possible test data.

 Features Of College Management
System Are as Follows:
• Provides the searching facilities based on various factors. Such as
College, Course, Batch, Session

• It tracks all the information of Faculty, Student, Batch etc.Manage

the information of Faculty

• Shows the information and description of the College, Course. All

the fields such as College, Course, Session are validated and does not
take invalid values

• It generates the report onCollege, Faculty, Student

• Provide filter reports on Course,Batch,Session

• It generates the report on College, Faculty,StudentProvide filter

reports on Course, Batch, Session

• You can also export the report into csv format for College, Faculty,
Session

• To increase effi ciency of managing the College, Faculty

• It deals with monitoring the informationand transactions of

BatchManage the information of CollegeEditing, adding and updating
of Records is improved which results in proper resource management
of collegedata
 Manage the information of Batch Integration of all records of Session.
 Modules of College Management
System:
• College Management Module: Used for managing the College
details Students Module: Used for managing the details of
StudentsExam Module: Used for managing the details of Exam

• Course Management Module: Used for managing the information

and details ofthe Courses

• Balch Module Used for managing the Batch detailsFaculty Module:

Used for managing the faculty information Login Module: Used for
managing the login details

• Users Module: Used for managing the users of the system

Objective Of College Management

System
 The main objective of the College Management System is to manage
the details ofCollege, Faculty, Course, Batch, Session.

 It manages all the information about College, Student, Session,

College. The project is totally built at administrative end and thus
only the administrator is guaranteed the ac cess. The purpose of the
project is to build an application program to reduce the manual work
for managing the College, Faculty, Student, Course. It tracks all the
details about the Course, Batch, Session.

 LOGIN PAGE

CODE
<?php include('server.php') ?>

<!DOCTYPE html>
<html lang="en" >
<head>
<meta charset="UTF-8">
<title>GIET UNIVERSITY</title>
<link rel='stylesheet' href='https://fonts.googleapis.com/css?
family=Open+Sans'><link rel="stylesheet" href="LoginCSS/login.css">
<script type="text/javascript" src="LoginJS/login.js"></script>

</head>
<body>
<p class="tip"></p>
<div class="cont">
<div class="form sign-in">
<h2>User Login</h2>
 <form method="post" action="login.php" id="sign_in_form">

<label id="email">
<span>Email</span>
<input type="email" name="email" id="signin_email"
placeholder="@giet.edu" required pattern="(.+@giet.edu)"
title="Please enter an email with giet extension" /><br>
</label>
<label>
<span>Password</span>
<input type="password" name="password" id="signin_password"
pattern=".{5,15}" required title="5 to 15 characters"
placeholder="**********" />
</label>
<a href="forgot.html"><p class="forgot-pass">Forgot
password?</p></a>
<button class="submit" id="sign_in" name="login_student">Sign
In</button>
<a href = "lecturer_login.php"><button type="button" class="fb-
btn"><span>Continue as lecturer</span></button></a>
</form>
</div>

<div class="sub-cont">
<div class="img">
<div class="img__text m--up">
<h2>New here?</h2>
<h2>Register Now!</h2>
</div>
<div class="img__text m--in">
<h3>If you already have an account, Sign in!</h3>
</div>
<div class="img__btn">
<span class="m--up">Sign Up</span>
<span class="m--in">Sign In</span>
</div>
</div>
<div class="form sign-up">
<!--<h2 id="regtext">Register</h2>-->
<form method="post" action="login.php" id="register_form">
<label>
<span>Name</span>
<input type="text" name="name" id="fullname" pattern=".{3,}" required
title="min character is 3" placeholder="Enter your name" required><br>
</label>
<label>
<span>Email</span>
<input type="email" name="email" id="signup_email"
placeholder="example@giet.edu" required pattern="(.+@giet.edu)"
title="Please enter an email with giet extension"><br>
</label>
<label>
<span>Password</span>
<input type="password" name="password_1" id="signup_password"
pattern=".{5,15}" required title="5 to 15 characters"
placeholder="**********" ><br>
</label>

<label>
<span>Confirm Password</span>
<input type="password" name="password_2" id="confirm_password"
pattern=".{5,15}" required title="5 to 15 characters"
placeholder="**********" ><br>
</label>

<label>
<span>Phone Number</span>
<input type="tel" id="phone" name="phone" placeholder="Enter your
phone number" required><br><br>
</label>
<label id="account">
<span>Account type</span>
<select name="acc_type">
<option value="student" >Student</option>
<option value="lecturer">Lecturer</option>
</select>
</label>
<button class="submit" name="register_user" onclick="Validate()"
>Sign Up</button>
</form>
</div>
</div>
</div>
<a class="icon-link">
<img
src="https://th.bing.com/th/id/OIP.FIPVJy6AYZ1mSQUNozsUAAAAAA
?pid=ImgDet&rs=1">
</a>
<script type="text/javascript" src="LoginJS/script.js"></script>
</body>
</html>
LECTURE LOGIN

CODE
Lecturer login.php

<?php include('server.php') ?>

<!DOCTYPE html>
<html lang="en" >
<head>
<meta charset="UTF-8">
<title>GIET UNIVERSITY LECTURER LOGIN PAGE</title>
<linkrel='stylesheet' href='https://fonts.googleapis.com/css?
family=Open+Sans'><link rel="stylesheet"
href="LoginCSS/AdminLogin.css">
</head>
<body>
<!-- partial:index.partial.html -->
<p class="tip"></p>
<div class="cont">
<div class="form sign-in">
<form method="post" id="admin_login" action="lecturer_login.php">
<h2>Lecturer Login </h2>
<label>
<span>Email</span>
<input type="email" name="email" id="admin_signin_email"
placeholder="lecturer@giet.edu" required pattern="(.+@giet.edu)"
title="Please enter an email with giet extension"><br>
</label>
<label><span>Password</span>
<input type="password" name="password"
id="admin_signin_password" pattern=".{5,15}" required title="5 to 15
characters" placeholder="**********" ><br>
</label>
<button class="submit" name="login_lecturer">Sign In</button>
</form>
<a href = "login.php"><button class="fb-btn"><span>Continue as
student</span></button></a>
</div></div><a class="icon-link"><img
src="https://th.bing.com/th/id/OIP.FIPVJy6AYZ1mSQUNozsUAAAAAA
?pid=ImgDet&rs=1"></a><!-- partial --</body>
</html>
 Student login

Student index.php
code
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-
scale=1, shrink-to-fit=no">
<title>GIETU</title>
<link rel="stylesheet"
href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstr
ap.min.css" integrity="sha384-
Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW
/dAiS6JXm" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js"
integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJw
FDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script
src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/po
pper.min.js" integrity="sha384-
ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXus
vfa0b4Q" crossorigin="anonymous"></script>
<script
src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap
.min.js"
integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1
MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-light bg-light">
<a class="navbar-brand" href="student_index.php">GIETU</a>
<button class="navbar-toggler" type="button" data-toggle="collapse"
data-target="#navbarText" aria-controls="navbarText" aria-
expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarText">
<ul class="navbar-nav mr-auto">
<li class="nav-item">
<a class="nav-link" href="university.php">University</a>
</li>
<li class="nav-item">
<a class="nav-link" href="student.php">Student</a>
</li>
<li class="nav-item">
<a class="nav-link" href="profile.php">Profile</a>
</li>
</ul>
</div>
<a class="navbar-brand"></a>
<form method="post" action="login.php" class="form-inline">
<button type="submit" name="log_out" class="btnbtn-default btn-
sm">

<span class="glyphiconglyphicon-log-out"></span> Log out</button>

</form>
</nav>
<div class="card text-center">
<div class="card-header">
Featured
</div>
<div class="card-body">
<h5 class="card-title">Announcement to everyone's attention: COVID
19 Lock-down news</h5>
<a href="https://www.india.com/topic/lockdown/" class="btnbtn-
primary" target="_blank">Details</a>
</div>
<div class="card-footer text-muted">
25 days ago
</div>
</div>
</div>
<div class="card text-center">
<div class="card-header">
Featured
</div>
<div class="card-body">
<h5 class="card-title">GIETU Robotistics Club 2021 Application
Form</h5>
<a href="https://forms.gle/kvixhQzA64A2R9x99" class="btnbtn-
primary" target="_blank">Details</a>
</div>
<div class="card-footer text-muted">
2 days ago
</div>
<div class="card-body">
<h5 class="card-title">GIETU PDCS(Personal Development
Commucative Skill) Club Season 8 Live Now</h5>
<h6>Apply NOW(OFFLINE)</h6>
</div>
<div class="card-footer text-muted">
1 days ago
</div> </div> </body>
</html>
 DATABASE CONNECTIVITY
 phpMyAdmin SQL Dump
 version 5.1.1
 htt ps://www.phpmyadmin.net/--
 Host: 127.0.0.1
 Generati on Time: Nov 27, 2021 at 05:59 AM
 Server version: 10.4.21-MariaDB
 PHP Version: 8.0.12
 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
 START TRANSACTION;
 SET ti me zone = "+00:00";
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
 /*!40101 SET NAMES utf 8mb4 */;
 Database: Mebis`

Table structure for table `book`

CREATE TABLE `book` (

`library_name` varchar(255) NOT NULL,

`book_name` varchar(255) NOT NULL,

`author` varchar(255) NOT NULL,

`book_status` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `book`

INSERT INTO `book` (`library_name`, `book_name`, `author`, `book_status`) VALUES('North Campus Library',
'Basics of Database', 'Reda Alhajj', 'Unavailable'),('North Campus Library', 'Harry Pott er', 'J. K. Rowling',
'Available'),

('North Campus Library', 'Lord of The Rings', 'J.R.R Tolkien', 'Available');

-- Table structure for table `course`

CREATE TABLE `course`

( `course_name` varchar(255) NOT NULL,

`AKTS` int(255) NOT NULL,

`class_no` varchar(255) NOT NULL,

`course_type` varchar(255) NOT NULL,

`lecturer` varchar(255) NOT NULL,

`prerequisite` varchar(255) NOT NULL,

`semester` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 Dumping data for table `course`

INSERT INTO `course` (`course_name`, `AKTS`, `class_no`, `course_type`, `lecturer`, `prerequisite`, `semester`)
VALUES

('Algorithm', 8, 'C-210', 'Technical', 'S.K Rathod', 'Data Structures', 'Summer'),

('Calculus 1', 8, 'CZ-16', 'Technical', 'J.K Singh', 'NULL', 'Spring'),

('Calculus 2', 8, 'CZ-16', 'Technical', 'Vinay Thakur', 'Calculus 1', 'Winter'),

('Data Structures', 8, 'C-310', 'Technical', 'Anil kumar Meher', 'Object Oriented Programming', 'Winter'),

('Database', 8, 'C-210', 'Technical', 'Akash Kumar', 'Object Oriented Programming', 'Spring'),

('Introducti on to Programming', 6, 'C-211', 'Technical', 'Rabi Narayan Das', 'NULL', 'Summer'),

('Machine Learning', 6, 'C-313', 'Non-Technical', 'Sunil Rathod', 'NULL', 'Summer'),('Microprocessor', 6, 'C-

210', 'Technical', 'Naveen Sikhera', 'Introducti on to Programming', 'Winter'),('Object Oriented Programming',
8, 'C-212', 'Technical', 'Lohitang Sharma', 'Introducti on to Programming', 'Summer'),

('Probability', 8, 'CZ-12', 'Technical', 'Aham Sharma', 'Calculus 2', 'Spring'),

('Web Design', 8, 'C-315', 'Non technical', 'Debashish Rath', 'NULL', 'Spring');

Table structure for table `dining`

CREATE TABLE `dining` (

`id` int(11) NOT NULL,

`Day` varchar(25) DEFAULT NULL,

`dining_name` varchar(255) NOT NULL,

`soup` varchar(255) NOT NULL,

`main_dish` varchar(255) NOT NULL,

`side_dish` varchar(255) NOT NULL,

`dessert` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 Dumping data for table `dining`
INSERT INTO `dining` (`id`, `Day`, `dining_name`, `soup`, `main_dish`, `side_dish`, `dessert`) VALUES

(1, 'Monday', 'Central Mess', 'Veg Soup', 'Rice,Dal,Ghanto,Veg Fry', 'Dhokla,Green chutney', 'Mysore
pak,Milkcake,Chenapoda'),

(2, 'Tuesday', 'Central Mess', 'Non veg Soup', 'Chicken Biriyani,Raita,Chicken Curry',
'Mughlai,Dhuska,Litt hiChokha', 'Pudding,Ice cream'),

(3, 'Wednesday', 'Central Mess', 'Manchow Soup', 'Roti ,Pulaw,DalFry,Matar Paneer', 'Vada-Sambar',
'Rasgulla'),

(4, 'Thursday', 'Central Mess', 'Veg-Soup', 'Roti ,Rice,Dal,Bhaja,Dry-sbji', 'Dosa,Idli', 'Kheer'),

(5, 'Friday', 'Central Mess', 'Hot&Sour soup', 'Roti ,Rice,Dal,Chicken,Paneer', 'Aaloo Bada', 'Balusahi'),

(6, 'Saturday', 'Central Mess', 'Corn Soup', 'Veg-biryani,Raita', 'Samosa,sbji', 'Milk-cake'),

(7, 'Sunday', 'Central Mess', 'Tomato Soup', 'Roti ,Rice,Fish,Channa-Chola', 'Chicken-Pakoda', 'kheer');

Table structure for table `exam`

CREATE TABLE `exam`

( `course_name` varchar(255) NOT NULL,

`exam_name` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Dumping data for table `exam`

INSERT INTO `exam` (`course_name`, `exam_name`) VALUES

('Algorithm', 'Algorithm Final'),

('Algorithm', 'Algorithm Midterm'),

('Database', 'Database Final'),

('Database', 'Database Midterm');

Table structure for table `lecturer`

CREATE TABLE `lecturer` (

`lecturer_name` varchar(255) NOT NULL,

`website` varchar(255) NOT NULL,

`birthdate` date NOT NULL,

`email` varchar(255) NOT NULL,

`degree` varchar(255) NOT NULL,

`role` varchar(255) NOT NULL,

`course_name` varchar(255) NOT NULL,

`advised_st_id` int(255) NOT NULL,

`department` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 Dumping data for table `lecturer`

INSERT INTO `lecturer` (`lecturer_name`, `website`, `birthdate`, `email`, `degree`, `role`, `course_name`,
`advised_st_id`, `department`) VALUES

('Aham Sharma', '', '2001-12-14', 'ahamsharma@giet.edu', 'Dr', 'lecturer', 'Probability', 110, 'Cse'),

('Akash Kumar', '', '1995-09-13', 'akashkumar@giet.edu', 'Dr', 'lecturer', 'Database', 105, 'Cse'),

('Anil kumar Meher', '', '1990-12-14', 'anilkumarmeher@giet.edu', 'Dr', 'lecturer', 'Data Structures', 104,
'Cse'),

('Debashish Rath', '', '2001-12-14', 'debashishrath@giet.edu', 'Dr', 'lecturer', 'Web Design', 111, 'Cse'),

('J.K Singh', '', '2001-11-10', 'j.ksingh@giet.edu', 'Dr', 'lecturer', 'Calculus 1', 102, 'Cse'),

('Lohitang Sharma', '', '1991-12-14', 'lohitangsharma@giet.edu', 'Dr', 'lecturer', 'Object Oriented

Programming', 109, 'Cse'),

('Naveen Sikhera', '', '1981-04-04', 'naveensikhera@giet.edu', 'Dr', 'lecturer', 'Microprocessor', 108, 'Cse'),

('Rabi Narayan Das', '', '1985-01-01', 'rabinarayandas@giet.edu', 'Dr', 'lecturer', 'Introducti on to

Programming', 106, 'Cse'),

('S.K Rathod', '', '2001-12-14', 's.krathod@giet.edu', 'Dr', 'lecturer', 'Algorithm', 101, 'Cse'),

('Sunil Rathod', '', '1994-07-28', 'sunilrathod@giet.edu', 'Dr', 'lecturer', 'Machine Learning', 107, 'Cse'),

('Vinay Thakur', '', '2000-02-14', 'vinaythakur@giet.edu', 'Dr', 'lecturer', 'Calculus 2', 103, 'Cse');

Table structure for table `program`

CREATE TABLE `program` (

`program_name` varchar(255) NOT NULL,

`est_semester_durati on` int(255) NOT NULL,

`student_id` int(255) NOT NULL,

`other_uni_name` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Dumping data for table `program`

INSERT INTO `program` (`program_name`, `est_semester_durati on`, `student_id`, `other_uni_name`) VALUES

('SENT EXPO', 1, 64160001, 'AICTE'),

('TECH FEST 2021', 2, 64160002, 'IIT Bombay');

 Table structure for table `student`

CREATE TABLE `student` (

`student_id` int(255) NOT NULL,

`name` varchar(255) NOT NULL,

`birthdate` date NOT NULL,

`course_code` varchar(255) NOT NULL,

`advisor_name` varchar(255) NOT NULL,

`degree` varchar(255) NOT NULL,

`scholarship` varchar(255) NOT NULL,

`grade` int(255) NOT NULL,

`emp_type` varchar(255) NOT NULL,

`department` varchar(255) NOT NULL,

`email` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Dumping data for table `student`

INSERT INTO `student` (`student_id`, `name`, `birthdate`, `course_code`, `advisor_name`, `degree`,

`scholarship`, `grade`, `emp_type`, `department`, `email`) VALUES

(64160001, 'Snehal Harsh', '2002-11-09', 'Database', 'Anil Kumar Meher', 'Undergrad', 'Full Scholarship', 3,
'Advanced Programming TA', 'Computer Science & Engineering', '20cse035@giet.edu'),

(64160002, 'Priya Khetan', '2002-10-20', 'Algorithm', 'Anil Kumar Meher', 'Undergrad', 'Full Scholarship', 3,
'Probability TA', 'Computer Science & Engineering', '20cse052@giet.edu'),

(64160018, 'Aayush Padhy', '1997-06-09', 'Machine Learning', 'Anil Kumar Meher', 'Grad', 'Half Scholarship',
1, 'NULL', 'Computer Science & Engineering', '20cse059@giet.edu'),

(64160022, 'Ananya', '1998-06-16', 'Microprocessor', 'Anil Kumar Meher', 'Phd', 'Half Scholarship', 4,
'Probability TA', 'Computer Science & Engineering', '20cse063@giet.edu');

Table structure for table `student book`

CREATE TABLE `student_book` (

`student_id` int(255) NOT NULL,

`book_name` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 Dumping data for table `student book `

INSERT INTO `student_book` (`student_id`, `book_name`) VALUES

(64160001, 'Lord of The Rings'),

(64160002, 'Harry Pott er');

Table structure for table `student club`

CREATE TABLE `student_club` (

`club_name` varchar(255) NOT NULL,

`leader_id` int(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Dumping data for table `student club`

INSERT INTO `student_club` (`club_name`, `leader_id`) VALUES

('GIETU Roboti sti cs Club 2021', 64160014),

('NSS', 62160008),

('PDSC CLUB SEASON 8\n', 63150012),

('RSS(RASTRIYA SWAYAM SEWAK SANG)\n', 61170008);

Table structure for table `student_club_Participants`

CREATE TABLE `student_club_parti cipants` (

`leader_id` int(11) NOT NULL,

`parti cipant_id` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Dumping data for table `student_club_participants`

INSERT INTO `student_club_parti cipants` (`leader_id`, `parti cipant_id`) VALUES

(61170008, 64160001),

(63150012, 64160002),

(64160014, 64160002);
 Table structure for table `student_current_course`

CREATE TABLE `student_current_course` (

`course_name` varchar(255) NOT NULL,

`student_id` int(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Dumping data for table `student_current_course`

INSERT INTO `student_current_course` (`course_name`, `student_id`) VALUES

('Algorithm', 64160002),

('Database', 64160001);

Table structure for table `student exam`

CREATE TABLE `student_exam` (

`exam_name` varchar(255) NOT NULL,

`student_id` int(255) NOT NULL,

`grade` int(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Dumping data for table `student exam`

INSERT INTO `student_exam` (`exam_name`, `student_id`, `grade`) VALUES

('Algorithm Final', 64160002, 80),

('Algorithm Midterm', 64160002, 90),

('Database Final', 64160001, 95),

('Database Midterm', 64160001, 85);

 Table structure for table `student_past_courses`

CREATE TABLE `student_past_courses` (

`student_id` int(255) NOT NULL,

`course_name` varchar(255) NOT NULL,

`fi nal_grade` int(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Dumping data for table `student_past_courses`

INSERT INTO `student_past_courses` (`student_id`, `course_name`, `fi nal_grade`) VALUES

(64160001, 'Introducti on to Programing', 87),

(64160001, 'Object Oriented Programming', 86),

(64160002, 'Data Structures', 70),

(64160002, 'Introducti on to Programming', 89),

(64160002, 'Object Oriented Programming', 98);

Table structure for table `visitor`

CREATE TABLE `visitor` (

`email` varchar(255) NOT NULL,

`name` varchar(255) NOT NULL,

`password` varchar(255) NOT NULL,

`phone` varchar(255) NOT NULL,

`type` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 Dumping data for table `visitor`

INSERT INTO `visitor` (`email`, `name`, `password`, `phone`, `type`) VALUES

('20cse035@giet.edu', 'Snehal Harsh', '25f9e794323b453885f5181f1b624d0b', '362958625', 'student'),

('20cse038@giet.edu', 'Piyush', 'd978add609ef1436acfa20d3ca06fc9e', '348946864', 'lecturer'),

('20cse044.aniketkumar@giet.edu', 'Aniket Kumar', '25f9e794323b453885f5181f1b624d0b', '7257906006',

'student'),

('20cse052@giet.edu', 'Priya Khetan', '25f9e794323b453885f5181f1b624d0b', '8260892367', 'student'),

('20cse059@giet.edu', 'Aayush Padhy', '16309356b4f0361240665680a7c95c1f', '9337300846', 'student'),

('20cse063@giet.edu', 'Ananya', 'f016313d09c1a933e8a99afc5129769d', '3458395033', 'student'),

('ahamsharma@giet.edu', 'Aham Sharma', '25f9e794323b453885f5181f1b624d0b', '94315879154',

'lecturer'),

('akashkumar@giet.edu', 'Akash Kumar', '25f9e794323b453885f5181f1b624d0b', '843974828', 'lecturer'),

('anilkumarmeher@giet.edu', 'Anil kumar Meher', '25f9e794323b453885f5181f1b624d0b', '8492579516',

'lecturer'),

('debashishrath@giet.edu', 'Debashish Rath', '25f9e794323b453885f5181f1b624d0b', '9748156748',

'lecturer'),

('j.ksingh@giet.edu', 'J.K Singh', '25f9e794323b453885f5181f1b624d0b', '848951795', 'lecturer'),

('lohitangsharma@giet.edu', 'Lohitang Sharma', '25f9e794323b453885f5181f1b624d0b', '7481691258',

'lecturer'),

('naveensikhera@giet.edu', 'Naveen Sikhera', '25f9e794323b453885f5181f1b624d0b', '2498563478',

'lecturer'),

('rabinarayandas@giet.edu', 'Rabi Narayan Das', '25f9e794323b453885f5181f1b624d0b', '1484195415',

'lecturer'),

('s.krathod@giet.edu', 'S.K Rathod', '25f9e794323b453885f5181f1b624d0b', '5874887419', 'lecturer'),

('sunilrathod@giet.edu', 'Sunil Rathod', '25f9e794323b453885f5181f1b624d0b', '9417282685', 'lecturer'),

('vinaythakur@giet.edu', 'Vinay Thakur', '25f9e794323b453885f5181f1b624d0b', '8492789465', 'lecturer');

Indexes for table `book`

ALTER TABLE `book`

ADD PRIMARY KEY (`library_name`,`book_name`,`author`);

Indexes for table `course`

ALTER TABLE `course`

ADD PRIMARY KEY (`course_name`);

 Indexes for table `dining`

ALTER TABLE `dining`

ADD PRIMARY KEY (`id`);

Indexes for table `exam`

ALTER TABLE `exam`

ADD PRIMARY KEY (`course_name`,`exam_name`);

Indexes for table `lecturer`

ALTER TABLE `lecturer`

ADD PRIMARY KEY (`email`);

Indexes for table `program`

ALTER TABLE `program`

ADD PRIMARY KEY (`program_name`);

Indexes for table `student`

ALTER TABLE `student`

ADD PRIMARY KEY (`student_id`);

Indexes for table `student_book`

ALTER TABLE `student_book`

ADD PRIMARY KEY (`student_id`,`book_name`);

Indexes for table `student_club`

ALTER TABLE `student_club`

ADD PRIMARY KEY (`club_name`);

 Indexes for table `student_club_participants`

ALTER TABLE `student_club_parti cipants`

ADD PRIMARY KEY (`leader_id`,`parti cipant_id`);

Indexes for table `student_current_course`

ALTER TABLE `student_current_course`

ADD PRIMARY KEY (`course_name`);

Indexes for table `student_exam`

ALTER TABLE `student_exam`

ADD PRIMARY KEY (`exam_name`,`student_id`);

Indexes for table `student_past_courses`

ALTER TABLE `student_past_courses`

ADD PRIMARY KEY (`student_id`,`course_name`);

Indexes for table `visitor`

ALTER TABLE `visitor`

ADD PRIMARY KEY (`email`);

AUTO_INCREMEN for table `dining`

ALTER TABLE `dining`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

COMMIT;
-Thank you