Free Essay

College Management System

In:

Submitted By ekku
Words 5703
Pages 23
SEMINAR ON INDUSTRIAL TRAINING
(June-July, 2013)

COLLEGE MANAGEMENT SYSTEM

Submitted by
EKTA BANSAL
Registration Number: 11002916

Under the Guidance of
MR AMAN SINGH
MANAGING DIRECTOR
NETMAX TECHNOLOGIES
BATHINDA

Discipline of CSE/IT
Lovely Professional University, Phagwara
June-July, 2013.
SEMINAR ON INDUSTRIAL TRAINING
(June-July, 2013)

COLLEGE MANAGEMENT SYSTEM

Submitted by
EKTA BANSAL
Registration Number: 11002916

Under the Guidance of
MR AMAN SINGH
MANAGING DIRECTOR
NETMAX TECHNOLOGIES
BATHINDA

Discipline of CSE/IT
Lovely Professional University, Phagwara
June-July, 2013.
DECLARATION
I hereby declare that I have completed my six weeks summer training at Netmax Technologies Bathinda from June 13 to July 13 under the guidance of MR Aman Singh, M.D of institute. I have worked with full dedication during these six weeks and my learning outcomes fulfill the requirements of training.

(Signature of Student)
Name of Student: Ekta Bansal
Registration Number: 11002916

Date: ___________________

ACKNOWLEDGEMENT
Apart from my efforts, the success of my project depends largely on the encouragement and guidelines of many others. I take this opportunity to express my gratitude to the people who have been instrumental in the successful completion of this project.
We are gratefully in debited to our esteemed guide for the project Mr. Aman Singh of the for his sincere guidance encouragement and priceless support without which it would have been impossible for us to complete the system study, coding and designing of this project. Last but certainly not the least; we are extremely thankful to all of the staff of NETMAX Bathinda for having generously provided us with necessary guidance, encouragement and moral support during the course of the project.

INDEX 1) ORGANIZATION OVERWIEW 2) PROFILE OF THE PROBLEM 3) EXISTING SYSTEM 4) PROBLEM ANALYSIS a) PRODUCT DEFINATION b) FEASIBILITY ANALYSIS i) HARDWARE FEASIBILTY ii) OPERATIONAL FEASIBILITY iii) TECHNICAL FEASIBILITY iv) ECNOMICAL FEASIBILITY 5) SOFTWARE REQUIREMENT ANALYSIS 6) DESIGN c) TABLE AND THEIR RELATIONSHIP d) FLOWCHART 7) SOURCE CODE 8) SCREEN SHOTS 9) GANTT CHART 10) PROJECT LEGACY e) TECHNICAL LESSON LEARNT f) MANAGERIAL LESSON LEARNT 11) BIBLIOGRAPHY

1. ORGANIZATION OVERVIEW
Netmax Technologies, an ISO 9001:2008 Certified Organization was established in 2001 with an aim to provide world class professional training and solutions in Advance Networking, Embedded Systems Design and IT Solutions.
Mission: “To provide world class professional training and solutions in advance networking, embedded systems design and career services for IT professionals as well as electronic system designers”.
Netmax Technologies provides industrial training to B.Tech /MCA / BCA/Diploma students in fields like * Embedded systems * Robotics * PLC and SCADA Automation Technologies, * Advance Networking Technologies(CISCO) * JAVA development * .NET development * PHP programming and Web development * Red hat (RHCE) and Unbent Administration * Microsoft System Administration( MCSE 2003 , MCITP 2008 )
Technology Focus:-
They specialized in building solution around the following key technologies:- * Microsoft * Java * C/C++ * Mobile

Key Alliances:- * Microsoft * IBM * Oracle

2. PROFILE OF THE PROBLEM
I have to create a web based graphical user interface (platform independent and user friendly) which can be fitted into any college system. As you know there are Thousands of college and schools in a city, and there are lakhs of students who came around the works to learn and study. So every college would like to collect all information of Students. The system should provide the detail structure of the college campus and its departments. College Management System synchronizes the working of all the departments. It should looks on all aspects of a college, its students, Departments, marks and other co – curricular activities.
College management system should include following features:- * About college itself * Courses offered * Latest updates * About placement * Student fee management * Student result management * Student batch and program management
Different type of user should include: * Student * Admin
3. EXISTING SYSTEM
Today in college’s student details are entered manually. The student details in separate records are tedious task. Referring to all these records and updating is needed. There is a chance for more manual errors.

Problems in existing system: * It was limited to a single system. * It was less user friendly. * It have lots of manual work, which also include working on spreadsheets and other softwares. * It requires more no of employee for work * It was time consuming process.

Solution to these problems: * The development of the new system contains the following activities, which try to automate the entire process keeping in view of the database integration approach * User friendliness is provided in the application with various controls. * The system makes the overall projects management much easier and flexible. * It can be accessed over the Internet.

4. PROBLEM ANALYSIS
Analysis is a detailed study of the various operation performed by the system and their relationship within and outside of the system. A key question what must be done to solve the problems during analysis data collected on the available files decision pioneers and transaction handled by the present system.
PRODUCT DEFINITION
The problem is to provide the complete information about the college campus. In which the college, students and parents can access the information and will be familiar with college campus. It will provide interactive environment for the staff, students and parents by getting knowledge of student, fees, exams performances etc.
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.Here almost all work is computerized. So the accuracy is maintained. Maintaining backup is very easy. It can do within a few minutes. Our system has two type of accessing modes, administrator and user. Student management system is managed by an administrator. It is the job of the administrator to insert update and monitor the whole process. When a user log into the system. He would only view details of the student. He can't perform any changes.
FEASIBILITY ANALYSIS:-
After studying all the problem solution for the College feasible solution was decided on the basis of:
HARDWARE FEASIBILITY
This project needs one computer with core 2 duo or higher processors. The memory requirement is 3GB RAM ,higer will also do. This is very feasible in this perspective.
SOFTWARE FEASIBILITY
This project can be loaded on any of the system having any of the Windows operating system.

OPERATIONAL FEASIBILITY
The project is easy to maintain and use. So there is no need of special training for the maintenance staff. There will be no resistance from the user side. TECHNICAL FEASIBILITY
Points in concern with the technical feasibility of our proposed system- * The technology i.e. hardware and software which we have used is normally available. It is easy to implement. * Our system is capable for up gradation account to users demand within the budget. * Since our system proposes all the necessary technical resources so it is technically feasible. * The system is easy to maintain and very attractive for user.
We can strongly says that it is technically feasible, since there will not be much difficulty in getting required resources for the development and maintaining the system as well. All the resources needed for the development of the software as well as the maintenance of the same is available in the organization here we are utilizing the resources which are available already. ECONOMICAL FEASIBILITY
Development of this application is highly economically feasible .The organization needed not spend much money for the development of t he system already available. The only thing is to be done is making an environment for the development with an effective supervision. I f we are doing so , we can attain the maximum usability of the corresponding resources .Even after the development , the organization will not be in condition to invest more in t he organization .Therefore , the system is economically feasible. * Hardware and software cost evolved is not too costly. * The technology used for the implementing the system is not expensive
5. SOFTWARE REQUIREMENT ANALYIS
Minimum software requirement for project
FRONT END: PHP
BACK END: MYSQL * Core 2 duo or higher * 256 Mb RAM or higher will do * Network Connections with 100 Mbps transfer rate * Server to control the database to be maintained by software. * 1 Mb cache memory * My sql
6. DESIGN
The most creative and challenging face of the system life cycle is system design. The term design describes a final system and the process by which it is developed. The first step is to determine how the output is to be produced and in what format.
TABLE AND THEIR RELATIONSHIP:
Admin table :

Fees table:

Registration table:

Result table:

Relationship between Tables: ADMIN FEES RESULT

REGISTRATION FEES RESULT

FLOWCHART:Flow chart is a graphical or symbolic representation of a process. Each step in the process is represented by a different symbol and contains a short description of the process step. The flow chart symbols are linked together with arrows showing the process flow direction.
FLOWCHARTS USED IN THIS PROJECT: ADMIN
LOGIN
IF NOT VALID GO BACK
IF VALID UPDATE

STUDENT
LOGIN
IF NOT VALID GO BACK
IF VALID FETCH ,SEE DATA

CONTEXT FLOW DIAGRAM (0 LEVEL DFD) ADMINISTRATOR
COLLEGE MANAGEMENT SYSTEM
DATABASE

ADMINISTRATOR LOGIN
DATABASE

STUDENT COURSE
COURSE DETAIL

STUDENT REGISTER
STUDENT REGISTRATION

7. SOURCE CODE This project is made of various different php pages which is as follow: 1. Home 2. Admin 3. About 4. Contact 5. Placement 6. Change 7. Courses 8. Logout 9. Fee 10. Rslt 11. student 12. Registration 13. Result 14. Config 15. Cpwd 16. Flog 17. Fees CSS: Netmax DATABASE: Netmax

HOME.php: <title>College Management System</title> <link href="css/webvator.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- #navigation a { font:11px Arial, Helvetica, sans-serif; color: #ffffff; text-decoration: none; letter-spacing:.1em; line-height:16px; display:block; padding: 0px 10px; border-right-width: 1px; border-right-style: solid; border-right-color: #ffffff; } #navigation a:hover { color:#106C21; background-image:url(images/hover-gif.gif); font-size:12px; } .search_bg { background-image: url(images/search_bg.gif); width:292px; height:202px; } .menu { height: 33px; width: 2px; font-family: Arial, Helvetica, sans-serif; font-size: 9px; }

.top_nav_text_first { FONT-WEIGHT: normal; FONT-SIZE: 9pt; COLOR: #000000; FONT-FAMILY: Verdana; vertical-align:top; line-height:24px; display:block; padding: 0px 10px; border-right-width: 1px; border-right-style: solid; border-right-color: #000000; } .top_nav_text_last { FONT-WEIGHT: normal; FONT-SIZE: 9pt; COLOR: #000000; FONT-FAMILY: Verdana; vertical-align:top; line-height:24px; display:block; padding: 0px 10px; }

.top_nav_text_white A:link {color: #000000; font-weight:normal; text-decoration: underline} .top_nav_text_white A:visited {color: #000000; font-weight:bold; text-decoration: underline} .top_nav_text_white A:active {color: #000000; font-weight:bold; text-decoration: none} .top_nav_text_white A:hover {color: #000000; font-weight:bold; text-decoration: none;} #navigation a:hover { color:#106C21; background: #ffffff; } #padding { padding:5px; } body { margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; } .time { color: #FFFFFF; font-family: Arial, Helvetica, sans-serif; font-size: 9px; } .textfieldLabel { FONT-WEIGHT: 200; FONT-SIZE: 11px; COLOR: #ffffff; FONT-FAMILY: Arial, Helvetica, sans-serif; list-style-image: url(images/cmn/blt.gif); word-spacing: 1px; } --> </style> <style type="text/css"> #pscroller1{ width: 280px; height: 60px; border: 1px solid WHITE; font-family:Arial, Helvetica, sans-serif; font-size:12px; } .someclass{ //class to apply to your scroller(s) if desired } </style> <body> <table align="center" border="0" cellpadding="0" cellspacing="0" height="100%" width="100%"> <tbody><tr> <td colspan="3" width="50%"></td> <td> <table align="center" border="0" cellpadding="0" cellspacing="0" height="100%" width="100%"> <tbody><tr><td height="50%"></td></tr> <tr> <td align="left" valign="top"> <table align="left" border="0" cellpadding="0" cellspacing="0" height="100%" width="970"> <tbody><tr> <td colspan="3" valign="top"><table width="970" border="0" cellpadding="0" cellspacing="0"> <tbody><tr> <td width="921" align="left" valign="top"><strong><img src="bfcet.jpg" width="968" height="254" alt="webvator.com"></strong></td> </tr> <tr class="menu" bgcolor="#c70000"> <td colspan="2"> <div align="center"> <table id="navigation" align="center" border="0" cellpadding="0" cellspacing="0"> <tbody><tr> <td class="navText" style="padding-left:195px;" align="center" nowrap="nowrap"><strong><a href="home.php" style="font-weight:bolder;font-size:15px;" >HOME</a></strong></td> <td class="navText" align="center" nowrap="nowrap"><strong><a href="about.php"style="font-weight:bolder;font-size:12px;" >ABOUT US</a></strong></td> <td class="navText" align="center" nowrap="nowrap"><strong><a href="courses.php" style="font-weight:bolder;font-size:12px;" >COURSES</a></strong></td> <td class="navText" align="center" nowrap="nowrap"><strong><a href="placements.php" style="font-weight:bolder;font-size:12px;" >PLACEMENTS</a></strong></td> <td class="navText" align="center" nowrap="nowrap"><strong><a href="flog.php" style="font-weight:bolder;font-size:12px;" >LOGIN</a></strong></td> <td class="navText" align="center" nowrap="nowrap"><strong><a href="contact.php" style="font-weight:bolder;font-size:12px;" >CONTACT US</a></strong></td> <td class="navText" align="center" nowrap="nowrap"><strong><a href="registration.php" style="font-weight:bolder;font-size:12px;" >REGISTRATION</a></strong></td> </tr> </tbody></table> </div> </td> </tr> </tbody></table> <strong> <script src="js/urchin.js" type="text/javascript"> </script> <script type="text/javascript"> _uacct = "UA-3063738-10"; urchinTracker(); </script> </strong></td> </tr> <tr> <td style="border-left: 1px solid rgb(16, 108, 33);background:-webkit-gradient(linear, 80% 20%, 10% 21%, from(#FFD9D3), to(#AA0000))" align="left" background="images/rightbg.png" valign="top" width="203"> <table align="left" border="0" cellpadding="0" cellspacing="0"> <tbody><tr> <td> <table align="center" border="0" cellpadding="0" cellspacing="1" width="100%"> <tbody><tr><td height="2"></td></tr> <tr> <td style="border: 1px solid rgb(208, 208, 198);" width="180"> <div id="calendarDiv" name="calendarDiv" style="width:180px;"> <table id="Table3" align="center" border="0" cellpadding="2" cellspacing="0" width="180"> <tbody><tr> <td align="center"><p><strong>Follow us on Twitter</strong></p> </td> </tr> </tbody></table> </div></td> </tr> <tr><td height="2"></td></tr> <tr> <td style="border: 1px solid rgb(208, 208, 198);" bgcolor="white" width="180"><strong><a href="home.php"><img src="images/webvator-slice9.jpg" width="182" height="121" border="0"></a> </strong> <table align="center" border="0" cellpadding="1" cellspacing="0" width="100%"> <tbody><tr> <td align="center"><strong>Follow us on Facebook</strong></td> </tr> <tr><td height="10"> </td></tr> </tbody></table> </td> </tr> </tbody></table> </td> </tr> </tbody></table> </td> <td valign="top"> <strong> <!------------- main content starts here -----------------------> </strong> <table align="center" border="0" cellpadding="0" cellspacing="0" width="645"> <!-- main article starts here --> <tbody><tr> <td class="border_left_right_box"> <table align="left" border="0" cellpadding="0" cellspacing="2"> <tbody><tr><td height="3"></td></tr> <tr> <td><strong><img src="images/webvator-slice1.jpg" style="border: 1px solid rgb(204, 204, 204);" height="197" width="260"></strong></td> <td width="3"></td> <td valign="top"> <table align="center" border="0" cellpadding="0" cellspacing="2"> <tbody><tr> <td class="home_page_main_article_heading" valign="top" style="color:black">BANSAL INSTITUTE OF ENGINEERING AND TECHNOLOGY </td> </tr> <tr><td height="20"></td> </tr><tr><td class="home_page_main_article_content" valign="top">The college is proud of having a fully computerized, centrally air conditioned and well stocked library having more than 10000 books in all relevant subjects. With subscription to national and international technical journals, it caters to the varied need of students and staff alike. All transactions of books are done through smart cards. The library also subscribes to all latest general and informative current affairs magazines.</td> </tr> <tr> <td class="read_more"> <strong><a class="read_more" href="#" title="Full Story">Read More </a></strong></td> </tr> </tbody></table> </td> </tr> </tbody></table> </td> </tr> <!-- main article ends here --> <tr> <td class="border_left_right_box" bgcolor="#EAEAE0"> <table align="center" border="0" cellpadding="0" cellspacing="2"> <tbody> <tr> <td style="padding-top:10PX;" ><strong> ADMIN.php: <?php session_start(); ?> <?php if(isset($_POST['login'])) { include("config.php"); $user = $_POST['user']; $pass = $_POST['pass']; $result=mysql_query("select * from admin where user='$_POST[user]' && pass='$_POST[pass]'"); $count = mysql_num_rows($result); $row = mysql_fetch_array($result); if($count==1) { $_SESSION['user']=$row['user']; header('Location:fees.php'); } else { print "Invalid username or password"; } mysql_close($con); } ?> <form style="padding-left:190px;padding-top:30px;" action="<?php print $_SERVER['PHP_SELF'];?>" method="post">

Change.php: <?php session_start(); ?> <?php if (isset($_POST['submit'])) { $user=$_SESSION['user']; include("config.php"); $result=mysql_query("update admin set pass='$_POST[npass]' where user='$user' "); mysql_close($con); } ?> <form style="padding-left:150px;padding-top:30px;" enctype="multipart/form-data" action="<?php print $_SERVER['PHP_SELF'];?>" method="post">

Logout: <?php session_destroy(); header('Location:home.php'); ?> Fee.php: <?php session_start(); ?> <form style="padding-left:150px;padding-top:30px;" enctype="multipart/form-data" action="<?php print $_SERVER['PHP_SELF'];?>" method="post"> <?php $email = $_SESSION['email']; include("config.php"); $result1=mysql_query("select * from registration where email='$email'"); print "<center><table border='1' cellpadding='5px' style='border-collapse:collapse;'>"; $row1 = mysql_fetch_array($result1); $rollno = $row1['id']; $result = mysql_query("select * from fees where rollno=$rollno"); while($row=mysql_fetch_array($result)) { ?> <tr> <th>UNI NO</th> <td> <?php print $row['uni']; ?></td> </tr> <tr> <th>ROLL NO</th> <td><?php print $row['rollno']; ?></td> </tr> <tr> <th>TOTAL FEES</th> <td><?php print $row['total']; ?></td> </tr> <tr> <th>FEES PAID</th> <td><?php print $row['paid']; ?></td> </tr> <tr> <th>BALANCE</th> <td><?php print $row['balance']; ?></td> </tr> <?php } print "</table></center>"; mysql_close($con); ?> Rslt.php: <?php session_start(); ?> <?php $email = $_SESSION['email']; include("config.php"); $result1=mysql_query("select * from registration where email='$email'"); print "<center><table border='1'cellpadding='5px' style='border-collapse:collapse;'>"; $row1 = mysql_fetch_array($result1); $rollno = $row1['id']; $result = mysql_query("select * from result where rollno=$rollno"); while($row=mysql_fetch_array($result)) { ?> <tr> <th>ROLL NO</th> <td><?php print $row['rollno']; ?></td> </tr> <tr> <th>TOTAL MARKS</th> <td><?php print $row['total']; ?></td> </tr> <tr> <th>MARKS OBTAINED</th> <td><?php print $row['obtained']; ?></td> </tr> <?php } print "</table></center>"; mysql_close($con); ?> Student.php: <?php session_start(); ?> <form style="padding-left:150px;padding-top:30px;" enctype="multipart/form-data" action="<?php print $_SERVER['PHP_SELF'];?>" method="post"> <?php $email = $_SESSION['email']; include("config.php"); $result=mysql_query("select * from registration where email = '$email'"); print "<table border='1' cellpadding='5px' style='border-collapse:collapse;'>"; while($row=mysql_fetch_array($result)) { ?> <tr> <th>ID</th> <td> <?php print $row['id']; ?> </td> </tr> <th>NAME</th> <td> <?php print $row['name'];?> </td> </tr> <tr> <th>E-MAIL</th> <td> <?php print $row['email']; ?> </td> </tr> <tr> <th>MOBILE</th> <td> <?php print $row['mobile'];?> </td> </tr> <tr> <th>DOB</th> <td> <?php print $row['dob']; ?> </td> </tr> <tr> <th>COURSE</th> <td> <?php print $row['course'];?> </td> </tr> <tr> <th>BRANCH</th> <td> <?php print $row['branch'];?> </td> </tr> <tr> <th>BATCH</th> <td> <?php print $row['batch'];?> </td> </tr> <img style="float:left;padding-right:50px;" src="image/<?php print $row['Image'];?>" height="200" width="200"> <?php } print "</table>"; mysql_close($con); ?> Registration.php: <?php if (isset($_POST['register'])) { if(isset($_FILES['image'])); { $pic=$_FILES['image']['name']; $random_digit=rand(0000,9999); $new_file_name=$random_digit.$pic; $path="image/".$new_file_name; } if(copy($_FILES['image']['tmp_name'],$path)); { header('Location:flog.php'); } include("config.php"); mysql_query("INSERT INTO registration(name,email,pwd,mobile,dob,course,branch,batch,image) values('$_POST[name]','$_POST[email]','$_POST[pwd]','$_POST[mobile]','$_POST[dob]','$_POST[course]','$_POST[branch]','$_POST[batch]','$new_file_name') "); mysql_close($con); } ?> <center> <form style="padding-left:190px;padding-top:30px;" enctype="multipart/form-data" action="<?php print $_SERVER['PHP_SELF'];?>" method="post"> Result.php: <?php session_start(); ?> <?php if (isset($_POST['submit'])) { include("config.php"); mysql_query("INSERT INTO result(rollno,total,obtained) values('$_POST[rollno]','$_POST[total]','$_POST[obtained]') "); echo "Result Entered Successfully"; mysql_close($con); } ?> <form style="padding-left:190px;padding-top:30px;" enctype="multipart/form-data" action="<?php print $_SERVER['PHP_SELF'];?>" method="post"> Cpwd.php: <?php session_start(); ?> <?php if (isset($_POST['submit'])) { $email=$_SESSION['email']; include("config.php"); $result=mysql_query("update registration set pwd='$_POST[npwd]' where email='$email' "); echo "Password Changed Successfully"; mysql_close($con); } ?> <form style="padding-left:150px;padding-top:30px;" enctype="multipart/form-data" action="<?php print $_SERVER['PHP_SELF'];?>" method="post"> Flog.php: <?php session_start(); ?> <?php if(isset($_POST['login'])) { include("config.php"); $email = $_POST['email']; $pwd = $_POST['pwd']; $result=mysql_query("select * from registration where email='$_POST[email]' && pwd='$_POST[pwd]'"); $count = mysql_num_rows($result); $row = mysql_fetch_array($result); if($count==1) { $_SESSION['email'] = $row['email']; header('Location:student.php'); } else { print "Invalid username or password"; } mysql_close($con); } ?> <form style="padding-left:190px;padding-top:30px;" action="<?php print $_SERVER['PHP_SELF'];?>" method="post"> Fees.php: <?php if (isset($_POST['submit'])) { include("config.php"); mysql_query("INSERT INTO fees(uni,rollno,total,paid,balance) values('$_POST[uni]','$_POST[rollno]','$_POST[total]','$_POST[paid]','$_POST[balance]') "); echo "Fees Entered Successfully"; mysql_close($con); } ?> <form style="padding-left:190px;padding-top:30px;" enctype="multipart/form-data" action="<?php print $_SERVER['PHP_SELF'];?>" method="post"> Config.php: <?php $con = mysql_connect("localhost","root",""); if(!$con) { die("Could not connect".mysql_error()); } mysql_select_db("netmax",$con); ?> Netmax.css: body { margin: 0; padding: 0; background: #FFFFFF url(images/img01.jpg) repeat-x ; font: 13px Georgia, "Times New Roman", Times, serif; color: #666666; } dl { padding-top:10px; padding-left:150px; margin:100px; list-style: none; } li { display: inline; } a { padding-right:50px; text-decoration:none; letter-spacing: -1px; font-size: 1.2em; font-weight: bold; color: #333333; }

8. SCREENSHOTS: Home.php:

About us Courses offered: Placements:

Student login:

Student Registration: Admin Login:

9. GANTT CHART: 1 WEEK 2 WEEK 3 WEEK 4 WEEK 5 WEEK 6WEEK LEARN HTML LEARN CSS STARTING OF PROJECT LEARN PHP LEARN MYSQL FINAL WORK ON PROJECT 10. PROJECT LEGACY TECHNICAL LESSON LEARNT: During this project I have learnt about : * Html * Css * Php * Mysql * Developing a Web Database Application Using PHP and MySQL
HTML:
HTML is a language for describing web pages.
HTML stands for Hyper Text Markup Language
HTML is not a programming language, it is a markup language
A markup language is a set of markup tags
HTML uses markup tags to describe web pages
When you save an HTML file, you can use either the .htm or the .html extension. We use .htm in our examples. It is a habit from the past, when the software only allowed three letters in file extensions.
With new software it is perfectly safe to use .html.
CSS:
Cascading style sheet enable us to precisely control the formatting of element on our webpages.Html was designed to control the structure of our web pages, such as headings, images, links, paragraphs and tables. Style sheets were designed to control the formatting of these elements in far greater detail than the HTML commands allow. Styles are the rules that define how the elements appear in web pages such as font and color.
Three types of css: - 1. Inline 2. Internal 3. External
PHP:
Hypertext Preprocessor. In its early development by a guy named Rasmus Lerdorf, it was called Personal Home Page tools. When it developed into a full-blown language, the name was changed to be more inline with its expanded functionality. The PHP language’s is known as shell scripting language
PHP is actually simpler than because it doesn’t use some of the more difficult concepts of C. PHP also doesn’t include the low-level programming capabilities of C because PHP is designed to program Web sites and doesn’t require those capabilities.PHP is particularly strong in its ability to interact with databases.
PHP support every database we’ve ever heard of (and some we haven’t). PHP handles connecting to the database and communicating with it.
PHP is an embedded scripting language when used in Web pages. This means that PHP code is embedded in HTML code. WE use HTML tags to enclose the PHP language that WE embed in our HTML file — the same way that WE would use other HTML tags. WE create and edit Web pages containing PHP the same way that WE create and edit regular HTML pages.

MYSQL:
MySQL is a fast, easy-to-use RDBMS used on many Web sites. Speed was the developers’ main focus from the beginning. In the interest of speed, they made the decision to offer fewer features than their major competitors (such as Oracle and Sybase). However, even though MySQL is less full-featured than its commercial competitors, it has all the features needed by the majority of database developers. It’s easier to install and use than its commercial competitors, and the difference in price is strongly in MySQL’s favor.
MySQL is developed, marketed, and supported by MySQL AB, which is a Swedish company.
MySQL is a popular database with Web developers. Its speed and small size make it ideal for a Web site. Add to that the fact that it’s open source, which means free, and WE have the foundation of its popularity. Here is a rundown of some of its advantages:

* It’s fast. The main goal of the folks who developed MySQL was speed. Thus, the software was designed from the beginning with speed in mind. * It’s inexpensive. MySQL is free under the open source GPL license, and the fee for a commercial license is reasonable. * It’s easy to use. WE can build and interact with a MySQL database by using a few simple statements in the SQL language, which is the standard language for communicating with RDBMSs. Check out Chapter 4 for the lowdown on the SQL language.

DEVELOPING A WEB BASED APPLICATION USING PHP AND MYSQL
The PHP software works with the Web server. The Web server is the software that delivers Web pages to the world. When we type a URL into our Web browser, we are sending a message to the Web server at that URL, asking it to send an HTML file. The Web server responds by sending the requested file. Web browser reads the HTML file and displays the Web page. We also request the Web server to send web a file when we click a link in a Web page.
In addition, the Web server processes a file when WE click a Web page button that submits a form. When PHP is installed, the Web server is configured to expect certain file extensions to contain PHP language statements. Often the extension is .php or .phtml, but any extension can be used. When the Web server gets a request for a file with the designated extension, it sends the HTML statements as-it-is. But PHP statements are processed by the PHP software before they’re sent to the requester.
When PHP language statements are processed, only the output is sent by the Web server to the Web browser. The PHP language statements are not included in the output sent to the browser, so the PHP code is secure and transparent to the user. user’s browser. The browser interprets the statement as HTML code and displays a Web page with one paragraph — hello World. The PHP statement is not delivered to the browser, so the user never sees any PHP statements. PHP and the Web server must work closely together.

MANAGERIAL LESSON LEARNT:
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.Here almost all work is computerized. So the accuracy is maintained. Maintaining backup is very easy. It can do wit in a few minutes. Our system has two type of accessing modes, administrator and user. Student management system is managed by an administrator. It is the job of the administrator to insert update and monitor the whole process. When a user will login to the system. He would only view details of the student. He can't perform any changes.
This System provides one attractive environment where you can manipulate data and information about students and staff easily. So we can say the Core purpose of designing “College Management System” is to manage the task related to the college students/employees and to reduce time to searching of appropriate candidates in college view.
This system is an integrated web application that handles various academic and non academic activities of a College/Academic Institute. The system can access by every students of the institution through internet connected computers or internet enabled mobile devices with the aid of his user name and password. Every user will have a customized home page with his/her profile management facilities. Through links that displays in the home page the user can access different options of the website assigned to him/her. Though the system allows access to everyone there is a significant security risk involved in this project. To tackle this problem we suggest a modular structure in the proposed system and a complete isolation of the financial and administrative modules from the public portal. Only trusted IPs can access these modules. Web services will interact to the financial and administrative modules to fetch necessary information to display in the public portal. Although a standard password policy will be followed in the designing of the system to prevent the possibilities of malicious activities of itching users.

11. BIBLIOGRAPHY * http://php.net/manual/en/tutorial.php * http://www.tutorialspoint.com/php * http://dev.mysql.com/doc/refman/5.0/en/tutorial.html * http://www.tutorialspoint.com/mysql/ * http://www.collegemanagementsoftware.com/college-management-system.php * Database Management System by - H. Korth * An integrated approach to software engineering by Pankaj Jalote * http://www.advantainnovations.com/benefits-school-college-management-system.aspx\ * http://www.providence.edu/learn/Pages/facultytutorials.aspx

Similar Documents

Premium Essay

Literature Cited

...Marinduque State College. Tanza, Boac, Marinduque. Matre, Postrado (2011) Development of Web-Based Tricycle Franchise Monitoring and Billing System. Undergraduate Software Project. School of Information and Computing Sciences. Marinduque State College. Tanza, Boac, Marinduque. Larga, Muhi, Ola and Samarita (2011). Development of Web-Based Document Management System for Marinduque State College Records Office. Undergraduate Software Project. School of Information and Computing Sciences. Marinduque State College. Tanza, Boac, Marinduque. Abetria,Alojado, De Luna, Del Prado, Labayna, Laceda, and Luz (2012), Development of General Sales and Inventory Monitoring System of Dena’s Pharmacy. Undergraduate Software Project. School of Information and Computing Sciences. Marinduque State College. Tanza, Boac, Marinduque. Logatoc, Lontoc, Nuñez, Opis and Solano (2013). Development of Web-Based Schools Document Management System of Marinduque State College Campus Director’s Office (Boac Campus). Undergraduate Software Project. School of Information and Computing Sciences. Marinduque State College. Tanza, Boac, Marinduque. Cadelena and Recana (2011). Development of School of Information and Computing Sciences Document Filing System. Undergraduate Software Project. School of Information and Computing Sciences. Marinduque State College. Tanza, Boac, Marinduque. Dela Cruz, Lauresta and Livelo (2009). Development of Fees Assessment and Fees Collecting System of MSC . Undergraduate...

Words: 571 - Pages: 3

Premium Essay

Business Rules & Database Models

...Business Rules and Database Models A database is defined as a grouped and organized set of data held in a computer system. A college database, therefore, can be defined as a small repository for its operational data. A college can use a database to access, manage and update its functional data. Additionally, it can use the database to track the information regarding its instructors; students, courses taught, and students' grades. A college needs an effective data management system. Such a system should be a collection of software, data, hardware, and users that are necessary to help the college manage its operational data. The major function of any database management system is to provide reliable and efficient methods of retrieving data to users. Therefore, a college database management system needs to be designed in a way that will allow several users to access several data items simultaneously or a similar data item frequently. Entities and attributes STUDENTS STUDENTS GRADES GRADES INSTRUCTORS INSTRUCTORS COURSES COURSES Diagram 1: A simple entity-relationship model. The above entity-relationship model is essential in designing a college database. Such entity-relationship model must use the concepts of the entity, attribute and relationship intuitively. Entities are key objects in the college that need to be represented in the database. In a college, the key entities are students, instructors, and courses taught. A grade of a student in a course is a relationship...

Words: 799 - Pages: 4

Free Essay

Selection of a Learner Management System for a University

...and Education Diploma Assignment: Selection of a Learner Management System for a University in Spain 1 Part 1 – Introduction 1.1 Background The subject matter I have chosen for my Assignment is the selection and planning of a Learning Management System for a University in Spain. 1.2 Objectives of the Project I have identified that a LMS could provide a number of potential advantages for our college, including the following:    Improvement in the quality of learning outcomes, Improvement in customer service quality, Efficiencies and cost savings. The specific objectives of the project is as follows:   To identify the particular benefits to learners and the college from such a system To prioritise functionality which will be of most benefit to the college and its learners. To identify implementation considerations which help ensure success. 1.3 What is a Learning Management System? Wikipedia defines a LMS as “a set of software tools designed to manage user learning interventions”. 1 SearchCIO define it as “a software application or Web-based technology used to plan, implement, and assess a specific learning process.”2 Typically, a Learning Management System is a computer based system which facilitates creation and delivery of content, communication between stakeholders in the training process, monitoring of student participation, and assessment of student performance. A learning management system may also provide students with the ability to use interactive...

Words: 2173 - Pages: 9

Premium Essay

Database Management Systems

...Database Management System Basith Shaik Southern New Hampshire University September 7, 2015 Abstract The intent of this paper is to design and propose a database management system solution to Grandfield College for tracking software installed. I have analyzed the organizational issues and needs and developed conceptual, logical, and physical designs of DBMS solution. In order to implement the solution, substantial research had been done on best practices in design, available products, and the legal and ethical standards to which we must adhere during design. This paper includes Business rules, Conceptual, Logical, and Physical database designs, Recommendations on best DBMS required for Grandfield College, Data model, Legal Compliance, Ethical Practices, Security Needs and Security Plan Keywords: Grandfield College, Database Design, Recommendations, Business Rules, Data model, Security Plan Database Management System Grandfield College is in need of Database Management System as law requires that any business, including a school, track its software. It is important to know what software the school owns, in what versions, and what the license agreement for that software is. For this purpose I have developed a Software Tracking database for Grandfield College. Problem Grandfield College is in need of a database for effectively tracking faculty and staff computers, the software installed on those systems, User access to each computer, and requests for new software installation...

Words: 4672 - Pages: 19

Free Essay

E-Vote

... India’s higher education system is the third largest in the world, after China and United State. The main governing body at tertiary level is the University Grants Commission. Which enforces its standards, advises the government, and help coordinate between the center and the state? Accreditation for higher learning is overseen by 12 autonomous institutions established by the University Grants Commission. As of 2009, India has 2 central university 215 state universities, 100 deemed universities, 5 institutions established and functioning under the state act, and 13 institutes which are of national importance. Other institutions include 16000 colleges, including 1800 exclusive women’s colleges, functioning under these universities and institutions. A software development and IT service firm implemented its catalyst in Governor Andres Pascual College was integrated web platform to provide content management, transaction processing, marketing and interactive community functions to the two rice schools. Catalyst delivers on the Jones Schools two primary criteria for selecting web-based platform simplifying content management, and enabling user’s response to information such as event RSVP and course registration. The content management tools let the Jones school staff edits update or add to the volume of curriculum and event information without calling for technical assistance. They simply cut and paste document into the content management system audit for consisting and publish...

Words: 631 - Pages: 3

Premium Essay

Econ 545 Week 2 Project Part 1

...In the file MGT 449 Week 5 Team Assignment Quality Improvement Implementation Paper Quality Management and Productivity you will find overview of the following parts: 1. Introduction 2. Identify a quality management system for process or organizational improvement 3. Summarize the requirements of the chosen system 4. Explain how your quality management system will benefit the organization 5. Define the variation you have identified in the as-is flow chart 6. Detail the implementation plan for your chosen quality improvement process 7. Examples of the quality tools plan to use for identifying and reducing process variability. 4. Conclusion 5. References Business - Management ·  Write a 1,400- to 2,100-word proposal recommending a process improvement to the management team of Hartman Industries, LLC. Work together to complete the following in your proposal: 1.  Identify the Hartman process or procedure for quality improvement.  2.  Detail the steps of the chosen process and discuss how the quality system is applied to it.  (As-Is) This can be done in a flow chart or written step by step.  3.  Explain how your recommended quality management system will benefit the process of the organization. (Should-Be) 4.  Define the variation you have identified from as-is to should-be. In other words, what part of the process are you fixing? 5.  Detail the implementation plan for your chosen...

Words: 351 - Pages: 2

Free Essay

Swc Econ 101

...Models Big organizations like universities, colleges, banking and hospitals with large amount of data require a software that is able to organize the data and in the database. Therefore the primary use of a database management system is its ability to collect data, store and transmute it into informative information that can help business make decisions. In order to make this possible, a database must be able to reduce data redundancy, inconsistency, upsurge security features, reliability and allow concurrent access of the data and improve accuracy and accuracy. The most important purpose of such a database is to provide automated methods that are able to develop, store and retrieve data more efficiently (Chapman, 2014). There are several drawbacks that are associated with the use of conventional file systems. This is because of the fact that most of such databases applications are developed on top of an existing file system. For this reason, the following problems are expected. To begin with, is redundancy; it is a situation where a lot of file formats together with duplicate information is found in different files (Gillenson, 2005). Accessing such data is difficult and the duplication of data in a file system may sometimes require a new program to be written. Another problem associated with conventional file systems is the difficult in file isolation. This is due to the multiple files and formats in the system that makes it difficult to isolate files from each...

Words: 847 - Pages: 4

Premium Essay

Programming Methods

...head: PROGRAMMING METHODS 1 College Databases Kenny Johnson Prof. Mark Cook CIS111: Introduction to Relational Database Management Systems April 20, 2014   Databases are used to store data and retrieve them quickly for processing. All businesses use a database to help them keep their information organized and available when needed. The data in the database is organized in a database management system. A database management system is a collection of programs that manages the database structure and controls access to the data stored in the database (Coronel, Morris & Rob). A business organization that uses a database is a college or university. Currently, at the time the student is admitted to the college all of the information is done manually by ink and paper. This is very time consuming and requires a lot of effort and time. Therefore, it is required to design a database system to make the work more efficient and speed up the process. The database management system will be fast and convenient, easy to operate and easy to edit and delete student information. The purpose of the database will store the records of students, teachers and courses. The database will keep track of students and the courses that they have taken. The database will also keep track of the instructors teaching each of the courses, Some of the entities that will be used in the college database management system are Student, Teacher, Course and Fees. The attributes...

Words: 951 - Pages: 4

Premium Essay

Students Course Registration

...Course Registration System Vision   Version 1.0       Revision History |Table |Version |Description |Author | |1/Dec/98 |Draft |Initial Draft |Sue Gamble | |13/Dec/98 |1.0 |Minor revisions following Peer Review. |Sue Gamble | | | |Added performance requirements. | | |  |  |  |  | |  |  |  |  |   Vision 1          Introduction 1.1           Purpose The purpose of this document is to define the high-level requirements of the Wylie course registration (C-Registration) system in terms of the needs of the end users. 1.2           Scope This Vision Document applies to the Wylie course registration system, which will be developed by the Wylie College Information Systems (IT) department. The IT department will develop this client-server system to interface with the existing course catalog database. The C-Registration System will enable students to register...

Words: 4109 - Pages: 17

Premium Essay

Essay

...challenging career in a progressive environment where learning , innovation and creativity are encouraged , where my skills and knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the Organization. EDUCATION: Course | Institute | Board | Year of passing | % or CGPA | B.Tech in Computer Science & engg. | Parala Maharaja Engineering College | BPUT | 2015 | 7.5 | 10+2 | Ravenshaw Junior College | CHSE | 2011 | 80.33 | 10th | Agrahat High School | BSE | 2009 | 90.66 | COMPUTER PROFICIENCY: * Operating system : Windows * Programming Language : java,c * Networking PROJECT PROFILE:PROJECT#1(major project) PROJECT TITLE | Online Crime Management System | DOMAIN | .net | ENVIRONMENT | .net,sql | TEAM SIZE | 7 | ROLE | Design | BRIEF DESCRIPTION | It is a web based application in which one can lodge complain about crime at anywhere at any time. | | SUBJECT OF INTEREST: * Database Management System * Software Engineering ACHIVEMENTS: * Represented the Class at College level . * Attended Seminars in College. STRENGTH: * Good team player. * Self motivated. * Hardwork is always promised. * An active listener. * Focused and Confident with positive attitude. HOBBIES: * Painting * Listening to music PERSONAL PROFILE: Name : Aisurya Baral Gender : Female Date Of Birth :...

Words: 256 - Pages: 2

Premium Essay

Management Information System

...MANAGEMENT INFORMATION SYSTEM TO HELP MANAGERS FOR PROVIDING DECISION MAKING IN AN ORGANIZATION 1G.SATYANARAYANA REDDY, 2RALLABANDI SRINIVASU, 3SRIKANTH REDDY RIKKULA, 4VUDA SREENIVASA RAO 1Professor & HOD-MBA in CMR College of Information Technology, Hyderabad, India 2Professor & Director –PG Studies. St. Mary’s Group of Institutions, Hyderabad, India. 3Associate Professor, MCA Dept. St.Mary’s College of Engg. & Technology, Hyderabad ,India. 4Professor & Head CSE, IT Dept. St.Mary’s College of Engg. & Technology, Hyderabad ,India. E-mail: satya3831@yahoo.com, rsrinivasusas@gmail.com, rikkula@gmail.com, vudasrinivasarao@gmail.com ABSTRACT Management Information System (MIS) provides information for the managerial activities in an organization. The main purpose of this research is, MIS provides accurate and timely information necessary to facilitate the decision-making process and enable the organizations planning, control, and operational functions to be carried out effectively. Management Information System (MIS) is basically concerned with processing data into information and is then communicated to the various Departments in an organization for appropriate decision-making. MIS is a subset of the overall planning and control activities covering the application of humans, technologies, and procedures of the organization. . The information system is the mechanism to ensure that information is available to the managers in the form they want it and when they need...

Words: 344 - Pages: 2

Free Essay

The Description of Management

... • File size should not exceed 500kb. Decreasing the dpi to 150-200 should compress file size if needed. • PDF is preferred, but additional formats are accepted (.doc, .wpd, .rtf, .xls, or .txt). • Preview your uploaded transcript to ensure it’s legible. • Applicants with international transcripts are required to submit a WES (www.wes.org) course-by-course evaluation. Official transcripts will be required if admitted. ⇨ Three letters of recommendation. • Three recommendations are required. Recommendations are submitted electronically via the online application system.  These letters should be written narratives by individuals who can address your responsibilities and skills, professional potential, motivation, and the potential impact of the program on the development of your career. *Management Information Systems (MIS) will not accept letters of...

Words: 1018 - Pages: 5

Free Essay

Training Need Analysis

...TRAINING NEEDS ANALYSIS (TNA) THE ROYAL AUSTRALIAN AND NEW ZEALAND COLLEGE OF RADIOLOGISTS® The Royal Australian and New Zealand College of Radiologists Strategic Priorities 2010 - 2014 Name of document and version: Training Needs Analysis (TNA), Version 1 Prepared by: Kelly Menzel - Educational Development Manager Sharon Messina - Director, Education and Research Submitted to: Endorsed by College Council, 21 July 2011 ABN 37 000 029 863 Copyright for this publication rests with The Royal Australian and New Zealand College of Radiologists ® The Royal Australian and New Zealand College of Radiologists Level 9, 51 Druitt Street Sydney NSW 2000, Australia Email: ranzcr@ranzcr.edu.au Website: www.ranzcr.edu.au Telephone: + 61 2 9268 9777 Facsimile: + 61 2 9268 9799 2 CONTENTS 1. INTRODUCTION……………………………………………………………….3 2. WHAT IS A TRAINING NEEDS ANALYSIS? ………………………...……4 3. BENEFITS OF UNDERTAKING A TNA……………………………………..6 4. INITIAL QUESTIONS ………………………………………………………..6 5. METHODOLOGY………………………………………………………………8 6. TRAINING NEEDS IDENTIFIED……………………………………………11 7. RECOMMENDATIONS………………………………………………………18 8. CONCLUSION………………………………………………………………...22 9. REFERENCES………………………………………………………………..24 10. BIBLOGRAPHY……………………………………………………………….26 11. APPENDIX 1…………………………………………………………………..27 12. APPENDIX 2…………………………………………………………………..28 13. APPENDIX 3…………………………………………………………………..36 Education and Research Portfolio Training Needs Analysis 22 July 2011 Page 2 1) INTRODUCTION This training...

Words: 9059 - Pages: 37

Premium Essay

Ffff

...Student Database Management System Abstract: An organized and systematic office solution is essential for all universities and organizations. There are many departments of administration for the maintenance of college information and student databases in any institution. All these departments provide various records regarding students. Most of these track records need to maintain information about the students. This information could be the general details like student name, address,performance, attendance etc or specific information related to departments like collection of data. All the modules in college administration are interdependent. They are maintained manually. So they need to be automated and centralized as, Information from one module will be needed by other modules. For example when a student needs his course completion certificate it needs to check many details about the student like his name, reg number, year of study, exams he attended and many other details. So it needs to contact all the modules that are office, department and examination and result of students. With that in mind, we overhauled the existing Student Database Management System and made necessary improvement to streamline the processes. Administrators using the system will find that the process of recording and retrieving students information and managing their classes, including marking of attendance, is now a breeze. In general, this project aims to enhance efficiency and at the same time...

Words: 308 - Pages: 2

Free Essay

Achieving Academic Excellence

...that lead to success in non-traditional learning: * The student must have an academic goal that can be articulated. * Emotional maturity is essential as distance learning can be lonely. * The student must be able to set and achieve goals. * The student must be able to work alone. * The student must be a self-starter and self-motivated. * The student must have self-understanding of needs and limitations. * Students need to have persistence and patience. * Students must be self-confident. * Students need above-average reading and writing ability. * The student must be willing to contact faculty and fellow students for help with content problems. * The student must have an academic support system at home (Source: Suite101: What You Need to Know About Online Education: Essential Knowledge When Considering Distance Education) Those who are not familiar with online learning think it is not difficult at all. They later discover that it is quite challenging. The U.S. Department of Education conducted a review that compared the effects of online learning with learning in the traditional face-to-face setting. The Department published its findings in a report called the "Evaluation of Evidence-Based Practices in Online Learning"; (2010). It states: Online learning has become popular because of its potential for providing more flexible access to content and instruction at any time, from any place. Frequently, the focus entails (a) increasing...

Words: 2334 - Pages: 10