Online Seminar Hall and Auditorium Booking System

The Online Seminar Hall and Auditorium Booking System is divided into four main modules. Each and every module performs a particular work. Those 4 modules are

  1. Maintenance of user and seminar hall
  2. Booking the seminar hall
  3. Approval and Rejection by In-charge
  4. Role of Principal

Maintenance of user and seminar hall

It consists of Signup, Login and update details of the seminar halls, users. The Administrator creates a separate account for each Department, Seminar hall in-charges, other cells like placement and training, EMDC etc., and Principal.

Booking the seminar hall

Each department has the username and password to book the seminar hall for their requirement. Through this they can view the available dates of particular seminar hall and also the facilities in the hall like capacity, mic’s, projector, marker board etc., This provides user-friendly environment while booking the seminar hall it gives suggestion regarding the selection of seminar hall based on the capacity and availability. The concern department head can view the list of the request. The acceptance and rejection can be viewed by the user through that log in or even by the email id.

Approval and Rejemailon by In-charge

The role of seminar hall in-charge is to check the request came to the seminar hall. When in-charges login into their account the list of new requests are displayed in their page as shown. The request can be either accepted or rejected based on the priority of the request. If more than one request is made for the same seminar hall on the same date after granting approval to a particular request by seminar hall in-charge, the remaining requests are automatically rejected and the email is sent to the bookie and also it is notified on their page.

Module – IV: Role of Principal

The Principal can view the entire process which is happening on the website and can fetch the data from the past to present who all are used the seminar hall. In an emergency case, he can reject the accepted request and the email will be sent to the booker as well as the seminar hall in-charge by suggesting alternate seminar halls.

User Registration Form

This form contains new user Registration Fields. Admin will take the role of this process to register user details. Here all the fields are validated using JavaScript Validation.


Signup Form

Login Form
The user can enter username and password. These Fields are mandatory. Both fields are validated using PHP. Login option given separated for four types of users.

Checking Availability

To check the availability of the seminar hall by Booker

Checking the availability
Availability Details
Seminar hall Booking FormIt contains all required fields for booking seminar halls like booking date, session, Booker name, dept, etc., Here all the fields are validated using JavaScript validation. For date picker, we are using ‘jQuery Date Picker’.

It contains all required fields for booking seminar halls like booking date, session, booker name, dept, etc., Here all the fields are validated using JavaScript validation. For date picker, we are using ‘jQuery Date Picker’.

Booking Form

Booking suggestion form

OUTPUT DESIGN

It contains a list of users on this system.

Administrator portal

Seminar hall Incharge Portal

It lists out the request came for the seminar hall with Booker details.In-charges approve the request based on the priority based on First Come First Serve order based on booking id or booking date and time.

Seminar hall in-charge portal

Usage details
It is Users availability checking page. On this user can check the availability of particular seminar halls.

Usage details

User page-Request details

It contains a list of requests have been sent to the seminar halls, viewed by the Head of the Departments.

Rejection of Acceptance

Notification of Approval Rejection

Usage details –principal portal

From this page, Principal can view the entire process which is happening on the website and can fetch the data from the past to present who all are used the seminar hall.

Acceptance rejection page

It shows the acceptance rejection page details, it can be viewed by principal

Admin portal

Principal portal

SYSTEM IMPLEMENTATION

The project is developed and hosted in our Engineering College web server. It is going to use by our college. Users can access this website by using the intranet. It helps users by reducing manual works. It will be a User-friendly website.

CONCLUSION

The project entitled “Seminar Hall and Auditorium Booking System” was successfully executed.  This system replaces the existing system with more features.  The system provides security to user documents.

However, the possibilities for innovation are infinite and scope for development is innumerable. The future extension can be made to provide more option in this application.

FUTURE ENHANCEMENT

Good amount of user friendliness has been incorporated in this system. It is possible to exploit these features to get the details of not only seminar hall but also the total number of blocks and which contains the total list of the hall in a block wise.  The process is suitable to extend the kind of task and the number of more process.

Download Seminar Hall booking System PHP project.

Easy Resource Utilization System

This Easy Resource Utilization System project aims to development of booking seminar halls and auditoriums in our college through online. It reduces the traditional/manual maintenance system. It creates a user-friendly website for users.

Here, four types of users are available like Principal, Administrator, Seminar hall in-charge and Head of Departments or Booker. Booker can check seminar hall availability, booking and viewing the status through online. Any faculty can reserve the seminar hall and auditorium based on the availability.

In this system, the seminar hall in-charges can view the requests and accept the request(s) according to the priority and also view the usage reports and status for a particular period. Administrator plays a vital role to maintain complete details of all the users, hall details and he/she is the only authorized person to update all details.

The principal can view all user details and usage details of seminar halls. Other users can only view the details of the seminar halls. Each event like seminar hall booking, cancellation of seminar hall will be intimated to the concern seminar hall in-charge, bookie, and Heads of the department through E-mail. Ultimately this project helps to utilize the seminar hall in an easy way.

PROJECT OVERVIEW

The project is developed for the requirement of our Kongu Engineering College. It is used to book the seminar hall through the online. Four roles are available for this project i.e., Principal, Administrator, Seminar hall In-charge and Hod. Booker can reserve the conference/seminar halls and auditorium easily.

Hall in-charges can accept and reject request came for the seminar hall. The principal can view the entire user, in-charge and usage details and he can reject the approval of hall in-charge. The administrator is responsible for users and hall details maintenance.

The project is developed and hosted in our Kongu Engineering College web server and linked to www.kongu.edu.

In the first step, the administrator has to provide the user id, password for the principal, seminar hall in-charges, Hod’s in order to avoid unwanted users to access the file, the second step Booker can book the seminar hall which is required, third step is hall in-charge can approve/reject the request of Booker. The final step is principal can view the usage details of the hall and also he has the rights to cancel the approval of hall in-charge which is accepted.

OBJECTIVES

• It is mainly to implement for departments to book seminar hall through online instead of carrying out documents and maintaining it.
• To reduce the effort of maintaining documents of seminar hall usage.
• It is the effective way of using the college resources properly.

SYSTEM ANALYSIS

EXISTING SYSTEM

This seminar hall booking is done only through the process on paper which means the process done through manual maintenance system.

Drawbacks

• Checking availability of seminar halls.
• Checking the capacity of seminar halls.
• Viewing the detail of the seminar halls.
• Phone conversations with seminar hall in-charges.
• Time wastage for the Booker.
• Mental stress to the booker.
• Non-availability of the technician.
• Booking form maintenance by the in-charge.

PROPOSED SYSTEM

This application entirely based on the online process as we can view the status of all seminar halls. It mainly reduces the effort and time of the Booker and hall in-charge. Based on the priority of request hall in-charges can easily accept or reject the request.

FEASIBILITY STUDY

This application is proposed by our principal as it is a valid one, which is a must for Kongu Engineering College as for the seminar hall booking process. This is efficiently done and helpful for all the faculty and HOD of the entire department. The drawbacks mentioned above in the current/ existing system will not reflect the proposed system.

SYSTEM SPECIFICATIONS

HARDWARE REQUIREMENTS

Processor: Intel Pentium i3 1.3 GHz
RAM: 4 GB
Hard Disk: 320 GB
Monitor: 17inch color display
Key Board: standard 104 Keys
Mouse: 4Button Scroll

SOFTWARE REQUIREMENTS

Operation System: Windows 7
Front End : HTML, PHP
Back End: MySQL
Scripting Languages: JavaScript and jQuery, PHP
Web server: XAMPP server 1.8.1

DATABASE DESIGN

A Project Report on E-learning

Preface

  • This Website is Provide to the E-Learning in Higher Secondary School.
  • This E-learning Website Can be Also Provide Information About Question.
  • The User can get the Online Learning about Question.
  • This is a static dynamic website designed to E-learning.
  • The User can also fill own registration form.

Acknowledgement

We are very grateful and thankful to professors of my college. who give me a good guidance and gives suggestion about each and every topic which we study and research. They give me guidance about my current E-learning project.
We also thankful to my friends. who give me support to help to complete this project. And solve my all difficulties.
We are taking this opportunity to express our gratefulness to the principal and All staff.

We also express our hearty thankfulness to all out friendly classmate and that entire person who has directly helped us in the preparation of this project.

Thank you to all person involved in this E-learning project.

Drawback of Existing System

  • As Current System is Window base So It’s Very Difficult.
  • Time-consuming Problem.
  • Only One Person is work at a time.
  • Difficult to Work For E-Learning Time Duration.

Need for new System

  • To E-learning Process Work Is Fast.
  • Reduce The Time Period for E-learning.
  • Paper work to be Remove.
  • Information stored in the database, which provides data security.

Tools & Technology

Software Requirement

1. FRONTEND:- PHP Version 5.2.6.
2. BACKEND:- My SQL.
3. BROWSER:- Google Chrome & Mozilla Firefox.

Hardware Requirement

1. Pentium(R) Dual-Core CPU.
2. 512 MB RAM for windows XP/windows7/windows8.
3. 20 GB HDD.

Data Flow Diagram

Context Level DFD

0 Level DFD for User

First Level DFD For Admin

Second Level DFD For Admin

Hierarchy Diagram

Data Dictionary

Registration Table

Sr No   Field Name     Field Type                   Field Size      Constraints
1 User_Id Int 06     A.I/P.K
2 Name Varchar 20 Not  Null
3 Address Varchar 50 Not  Null
4 Country Varchar 25 Not  Null
5 Email Varchar 30   Is_Unique
6 Password Varchar 20 Not  Null
7 Birth date Date Not  Null
8 Gender Varchar 6 Not Null
9 Pincode Int 6 Not  Null
10 Mobile Varchar 10 Not  Null

User Login Table

Sr. no Field Name Field Type Field Size Constraints
1    User_Id Int 6 A.I/P.K
2 Email Varchar 30 Not Null
3      Password Varchar 20 Not Null

Admin Login Table

Sr. no Field Name Field Type Field Size Constraints
1 Id Int 6 A.I/P.K
2 Email Varchar 30 Not Null
3      Password Varchar 20 Not Null

Feedback Table

Sr. no Field Name Field Type Field Size Constraints
1 Id Int 6 A.I/P.K
2  Name Varchar 20 Not Null
3 Email Varchar 30
4   Comment Text Not Null

Add Question Table

Sr. no Field Name Field Type Field Size Constraints
1 Id Int 10 A.I/P.K
2 Q_ Name Varchar 200 Not Null
3 Q_Category Varchar 50 Not Null
4 Q_Cont Text Not Null

Form Design

Home Page


  • About Us Page
  • Education Page
  • Registration Page
  • Contact Us Page
  • User Login Page
  • Course Home Page
  • B.C.A Page
  • B.com Page
  • B.A Page
  • Admin Login Page
  • Admin Home Page
  • Registration Report
  • Login Report
  • Feedback Report
  • Change Admin Password
  • Add Question Page

Bibliography

During the development of E-learning project, We have gone through the following books and websites.

Books:-

• HTML, JavaScript, DHTML and PHP
• HTML using CSS

Websites:-

• Www.Google.com
• Www.W3schools.com
• Www.pustakalaya.com

A Project Report on Online Score System

Team Information

The administrator Can Add/Update the teams With the details and the user can view the overall information of the

  • the team detail module allows the user to browser The details of the team profile and management.
  • Team module allows user to browse different teams
  • where only one team can be selected at a time and get the detail
  • when selected on a particular team.

This module gives the detail of team such as team logo, team name, team information, team captain, address, contact no show match details

Player Details

this will come under team information which gives the basic details about the players.

  • allow the user to have a glimpse of the player’s profile.
  • it give the personal details of a player with their batting style, bowling style and his position in the team along with their achievements

Batting Performance

  • It gives the batsman profile, statistic, and summary of his batting performance in his current and previous matches that he had played.

Bowling Performance

  • It gives the bowling profile, statistics, and summary of his bowling performance in his current and previous matches that he had played.

Results

  • This module gives the summary that was played.
  • It also gives the overall detailed result of that particular match that was played.
  • Detail such as scores scored by both the teams Over’s completed, loss of wickets.

Gallery

it shows the best captured moments, pictures, video etc… That was taken during the course of the matches.

  • It will dynamic.
  • Here the photo is uploaded which was clicked/recorded by the fans during the matches.
  • The user cannot upload the image here due to censorship issues.
  • Instead, the user is supposed to e-mail the image to admin and then admin uploads it to the website.

Administrator

The administrator is allowed to access all the services in the system. The main objective of the administrator is to add/update the summary of the matches and also to add/update the schedules of the matches.

Users/Visitors

These users will get the full access of the website but they cannot do any changes on the Online Score System website, they can enjoy the services provides by the administrator.

Data Dictionary

ADMIN

No FieldsName DataType Size Constraint
1. id int 3 PK
2. username Varchar 20 Null
3. password Varchar 20 Null

TEAMLIST

No FieldsName DataType Size Constraint
1. id int 3 PK
2. team_name Varchar 20 Null
3. team_logo Varchar 30 Null
4. captain_name Varchar 20 Null
5. Captain_photo Varchar 30 Null
6. Villege Varchar 20 Null
7. Contact Varchar 10 Null

PLAYERLIST

No FieldsName DataType Size Constraint
1. id int 3 PK
2. Player_name Varchar 20 Null
3. Player_photo Varchar 30 Null
4. taem_name Varchar 20 Null
5. age int 2 Null
6. dob date Null
7. Contact Varchar 10 Null

BATSMAN

No FieldsName DataType Size Constraint
1. id int 3 PK
2. match_no Varchar 20 Null
3. Player_name Varchar 20 Null
4. Team_logo Varchar 30 Null
5. Innings Varchar 10 null
6. run Int 3 Null
7. Ball Int 3 null
8. four Int 3 Null
9. six Int 3 Null
10. Wide_run Int 3 Null
11. No_run Int 3 Null
12. lage Int 3 Null
13. By_run Int 3 Null
14. St float Null
15. out_detail Varchar 30 Null
16. Bowler_name Varchar 20 Null
17. Vs_team Varchar 30 null

MATCHLIST

No FieldsName DataType Size Constraint
1. Id int 3 PK
2. Team_name(a) Varchar 20 Null
3. Team_logo(a) Varchar 30 Null
4. Villege(a) Varchar 15 null
5. Team_name(b) Varchar 20 Null
6. Team_logo(b) Varchar 30 null
7. Villege(b) Varchar 15 Null
8. umpire varchar 20 Null
9. Tos Varchar 10 Null
10. Date Date Null

ELEVENPLAYER

No FieldsName DataType Size Constraint
1. id int 3 PK
2. Player_name Varchar 20 Null
3. Team_name Varchar 20 Null
4. Match_no int 3 Null

UMPIRELIST

No FieldsName DataType Size Constraint
1. id int 3 PK
2. umpire_name Varchar 20 Null
3. villege Varchar 20 Null
4. contact int 10 Null

GALLERY

No FieldsName DataType Size Constraint
1. id int 3 PK
2. photo Varchar 100 Null

BOWLER_LIST

No FieldsName DataType Size Constraint
1. id int 3 PK
2. Match_no int 20 Null
3. Team_name Varchar 20 Null
4. Bowler_name Varchar 20 Null
5. Innings Varchar 10 Null
6. Over Float Null
7. Run Int 3 Null
8. Wide_run Int 3 Null
9. No_ballrun Int 3 Null
10. Wicket Int 3 Null
11. Run_out int 3 Null
12. Echonomics Float Null
13. Vs_team Varchar 20 Null
14. Bowler_statas Varchar 20 null

Data Flow Diagrams

Level 1

Snapshot


Live Score Page


Team Page
Schedule Page
Result Page
About Us
Admin side Snapshot

Admin Login
Add Team Page
Add Player Page
Add Match Page
Live Update Batsmanside Page
Live Update Bowler Side Page
Add Umpire Page
Gallery Page

A Project Report On Online Certified Course

 Preface

  • This Online Certified Course Website is Provide to you to learn and get the certificate.
  • This Website Can be Also Provide Information about different types of courses.
  • The User can learn online and get the certificate.
  • This is a static and dynamic website designed
  • The User can registration first and then login and start the course.

Acknowledgement

We are very grateful and thankful to professors of my college. Who give me a good guidance and gives suggestion about each and every topic which we study and research? They give me guidance about my current Online Certified Course project.

We also thankful to my friends. Who give me support to helpful to complete this project? And solve my all difficulties.

We are taking this opportunity to express out gratefulness to the principle and All staff.

We also express our heartily thankfulness to all out friendly classmate and those entire person who have directly helped us in the preparation of this project.

Thank you to all person involve in this Online Certified Course project.

Project Profile

Project Name : Online Certified Courses
Front – end – tool : PHP Version 5.2.6
Back – end – tool : Mysql
Operating System : Windows-7.
Team Size : 2 Students
Project Duration : 3 Months

Software Requirement:-

  • Operating Systems : Microsoft Windows XP (or more)
  • Front End Tool : PHP
  • Back End Tool : Mysql
  • Browser : Chrome, IE, Firefox

Drawback of Existing System

  • As Current System is Window base. So it’s Very Difficult.
  • Time consuming Problem.
  • Only One Person is work at a time.
  • Difficult to Work for learning courses Time Duration.

Need for new System

  • To online certified Process Work Is Fastly?
  • Reduce The Time Period for learning courses.
  • Paper work to be Removing.
  • Information stored in database, which provides data security.

Data Flow Diagram

Context Level Diagram

0’Level DFD for User

O’Level DFD for Admin

DATA Dictionary

REGISTRATION TABLE

SR.NO Field Name Data Type Constraints Description
1 Id Int(5) Auto/Inc Use For id
2 Cust_name Varchar(25) Not Null Use For Name
3 Cust_address Varchar(50) Not Null Use For Address
4 Cust_city Varchar(50) Not Null Use For City
5 Cust_state Varchar(12) Not Null Use For State
6 Cust_country Varchar(10) Not Null Use For Country
7 Cust_email Varchar(50) Not Null Use For Email
8 Cust_password Varchar(15) Not Null Use For Password
9 Cust_dob Date Not Null Use For Birth Date
10 Cust_gender Varchar(6) Not Null Use For Gender
11 Cust_Pincode Int(6) Not Null Use For Pincode
12 Cust_mobile Decimal(10,0) Not Null Use For Mobile

ADMIN LOGIN TABLE

SR.NO Field Name Data Type Constraints Description
1 id Int(11) Auto/Inc Use For id
2 Username Varchar(25) Not Null Use For Username
3 Password Varchar(25) Not Null Use For Password

NEWS TABLE

SR.NO Field Name Data Type Constraints Description
1 id Int(11) Auto/Inc Use For id
2 News Text Not Null Use For News

FEEDBACK TABLE

SR.NO Field Name Data Type Constraints Description
1 Id Int(11) Auto/Inc Use For id
2 Name Varchar(20) Not Null Use For Name
3 Email Varchar(30) Not Null Use For Email Id
4 Mobile Decimal(10,0) Not Null Use For Mobile No
5 Message Varchar(500) Not Null Use For Message

COURSE TABLE

SR.NO Field Name Data Type Constraints Description
1 C_id Int(5) Auto/Inc Use For id
2 Course_Name Varchar(50) Not Null Use For Name
3 Course_category Varchar(50) Not Null Use For Category
4 Course_cont Text Not Null Use For Content
5 Img_Name Varchar(50) Not Null Use For Image Name
6 Image Blob Not Null Use For Image
7 Pdf_name Varchar(100) Not Null Use For Pdf

Form Layout

Home Page
About Us Page
Contact Us Page
Registration Page
Login Page
Business Course Page
Admin Login Page


Admin Home Page


Add Course Page


Update News Page


Admin Change Password


Feedback Suggession Page
Feedback Report
Registration Page