Sample
Sample
By
Rohit Hansda
Roll no. 12
Enrollment No. AJU/210786
1
GUIDED BY:
PREPARED BY:
Dr. Arvind Kumar Pandey Rohit Hansda
&
Ms. Alka Singh
SUBMITTED TO
DEPARTMENT OF COMPUTER SCIENCE & IT
ARKA JAIN UNIVERSITY
SUBMITTED TO
DEPARTMENT OF COMPUTER SCIENCE & IT
i
ARKA JAIN UNIVERSITY
ARKA JAIN UNIVERSITY, JHARKHAND
DEPARTMENT OF COMPUTER SCIENCE & IT
CERTIFICATE
This is to certify that the project entitled, "ONLINE NOTICE BOARD SYSTEM", is
bonafide work of ROHIT HANSDA bearing Enrolment No. AJU/210786 submitted in partial
fulfilment of the requirements for the award of degree of MASTER OF COMPUTER
APPLICATION (MCA) from ARKA JAIN University, JHARKHAND.
ii
ACKNOWLEDGEMENT
It is a genuine pleasure to express my profound gratitude and deep regards to my Internal Guide
Ms. Alka Kumari and our HOD Dr. Arvind Kumar Pandey for their exemplary guidance,
monitoring and constant encouragement. I would like to express my special thanks to ARKA
JAIN UNIVERSITY who gave me the golden opportunity to do this wonderful project on the
topic Online Notice Board System, which helped me in doing a lot of Research and I came to
know about so many new things.
With Regards
Rohit Hansda (AJU/210786)
Roll no. 12 (MCA)
iii
ABSTRACT
An online notice board is a place where people can leave any types of messages and
notifications, for example, to advertise things, announce events or provide any
information.
Notice board online it can be placed on digital devices such computers, tabs, mobile
phones etc. This online notice board project is very helpful for all type of users like
existing users and new users.
So, admin can leave and erase notification for other people to read and see.
The main aim of this free online notice board project is making information dissemination
much easier in a paperless community as the world tends to interact with the online notice
board facility as a project. Online notice board admin can send the notification to the
particular students regarding fee payments, results, any new activity happen in college
campus or college fest participation, libraries dues, hostel room payments, any workshop
registrations, warnings and reminders etc for this work online notice board project is
making all work much easier and understandable to all. This online notice board work
generally intends to act as a support system for the all users. By the help of free online
notice board, users can access the notifications and articles quickly not only in the
particular premises, also wherever and whenever they need to know.
Online notice board usability is fully capable of passing relevant notices and
announcements and keeping the users update from time to time. The students are kept
updated each time with the online notice board for college is uploaded based on their
preferences with respect to the departments and categories through a notice board online.
iv
DECLARATION
I hereby declare that the project entitled, “ONLINE NOTICE BOARD SYSTEM” done at
“Arka Jain University”, has not been in any case duplicated to submit to any other university
for the award of any degree. To the best of my knowledge other than me, no one has submitted
to any other university.
The project is done in partial fulfilment of the requirements for the award of degree of
MASTER OF COMPUTER APPLICATION (MCA) to be submitted as final semester
project as part of our curriculum.
Rohit Hansda
v
TABLE OF CONTENTS
vi
3.3 Normalization ................................................................................................................. 11
3.3.1 1st Normal Form: - .................................................................................................. 11
3.3.2 2nd Normal Form: - .................................................................................................. 11
3.3.3 3rd Normal Form: - ................................................................................................... 12
[Link] Student Table .................................................................................................... 12
[Link] Subject Table .................................................................................................... 12
[Link] Score Table ....................................................................................................... 12
3.3.4 Boyce – Codd Normal Form ................................................................................... 13
[Link] Student Table .................................................................................................... 13
[Link] Professor Table ................................................................................................. 13
Chapter 4: Coding.................................................................................................................. 14
vii
5.11 Students Notice ............................................................................................................ 56
Chapter 6: Conclusion ........................................................................................................... 57
viii
Chapter 1: Introduction
Overview
The Online Notice Board System is intented for colleges and institutions where information
and file sharing on regular basis plays vital role in the performance. The proposed system will
act as an online notice board which will make use of the modern communication methodologies
and tecniques for information flow. The system is planned to consist of various useful features
for the said purpose.
The proposed system aims to create a platform for issuing notice, sharing information and files
between the members of the institutions. Different users shall have different level of access to
the content. In the context of a college, there shall be four users of the software—administrator,
student, teacher and guest. The administrator shall be able to issue notice, upload files, and
view students’ activities on the software. The teacher shall be able to issue notice, upload files
(on a general basis or to a particular classroom), and view result and students’ result. A guest
will simply be able to view public notices.
Problem Statement
In today’s world, everything is digitalized and paper is being used less and less everyday. How
often has it happened that we miss some important notice because we have to go to a wall and
read the notice there? There has dedicated file hosting sites and clouds used by some
institutions, but there is a definite need for a dedicated notice board system. The proposed
system is such a systsm.
Need
Almost all leading institutions, expecting a few, currently lack an electronic noticeboard
system. Though some have taken the aid of third-party websites like facebook to interact, it
comes the cost of mixing one’s social life with professional. Keeping this in mind, educational
institutes will find the software extremely useful.
The “Online Notice Board System “is a web-based software, with supplementary application
software, with supplementary application software, that aims to aid the institutes by providing
such digital notice board.
1
Chapter 2: Implementation and Testing
Primary aim
The primary aim of the Online notice board software project is to create a fully functional
digital noticeboard system which will efficiently handle all assigned tasks.
They may be able to, in due course, heavily minimize, if not eradicate, the conventional,
physical noticeboards. With the help of the supplementary applications, users will be able to
receive real-time notifications of any and all notices posted by another user with privileges as
such.
Objectives
• To develop supplementary apps for the said noticeboard.
• To create a user-friendly interface.
• To develop and manage a proper database system to ensure data safety and proper
management.
• To allocate various levels of users and have proper authentication.
• To prepare proper and detailed system documentation.
• Operating System
• Database—MySQL
2
Suggested Deliverables
• A web-based online noticeboard system.
• A windows 8 App
• An Android App
• Proper system documentation
Process Model
The incremental model has been deemed the best suited for the SDLC process and shall be
followed. Using this model will have the benefit over the LSM in the sense that it will inherit
the quality of the LSM but exclude the rigidity. Furthermore, the feedback process of Process
Iteration model will also be available in the incremental model. Another contributing factor in
choosing this model is the short period of time available to make a working initial version of
the system.
Visibility Plan
• The group members will be in contact timely and will focus on one area at atime as
all are beginners.
• The phases will be followed sequentially with equal contribution of group members
in each phase.
• platforms.
Schedule Feasibility
The development process is planned to reach designing phase till the end of the semester, which
gives us a windows of roughly six months. Although this may be a tight fit for a perfect, final
system, as the incremental model is being followed in the SDLC, this is enough time to develop
a working first version of the software.
Legal Feasibility
The developers will obviously use no illegal means or methodologies in the development
process of the system. The software will be operated abiding by the cyber and other applicable
laws prevailing in the country enforced by the government of Nepal. The user will be held
responsible for only the data they enter to the system. In case of international users, they will
be subjected to the applicable laws in that country. So, the software has no legal barrages.
3
Religious- Cultural Feasibility
This system will never ask the user of their religion or cultural origin and ergo will not act in
any what so ever that may hurt the sentiments of any cultural or religious group. The product
development or operation will never undergo any process that might be3 unacceptable to a
specific religion or culture. The software itself will be generic and impartial. So, no religious
or cultural issues should disrupt the system.
Economic Feasibility
The program uses programming language whose IDE are freeware. One exception to this is the
Visual Studio 2012. Which is needed for the supplementary app development. But this software
is provided free of cost by the MIC Nepal. Further costs for this project are the costs of online
domain, space and database and registering and uploading the apps in the respective market,
which is expected to be covered by the college. The remaining cost is that of training the
developer team in the particular language and/or platform. which is minimal. So, the project is
economically feasible.
Technical Feasibility
The software is to be developed using Java, PHP, CSS, XAML and MySQL, which are all
readily available. Also, the team members have sufficient programming and related knowledge
which will enable us to learn and adapt to these specifie language and platforms easily. Thus,
we can see that the project is technically feasible.
Operational Feasibility
The software requires very little specific environment to run. Only the apps require their
environment to run. i.e., Windows 8TM and Android. As a staggering majority of the PCs in the
world are based on Windows OS and many mobile devices operate on Android, this cannot
really be considered a need. The software will be extremely user-friendly, removing the need
for specifically trained employees. Similarly, the cost of buying the rights and the maintenance
cost will not be very high for the client. So, the software is feasible for operation.
Background Theory
In today’s world, everything is digitalized and paper is being used less and less every day. How
often has it happened that we miss some important notice because we have to go to a wall and
read the notice there?
4
The Online Notice Board System is mainly intended for colleges and institutions where
information and file sharing on regular basis plays vital role in the performance. The proposed
system will act as an online notice board will make use of the modern communication
methodologies and techniques for information flow. The system is planned to consist of various
useful features for the said purpose
The Online Notice Board System is a web-based software, with supplementary application
software, that aims to aid the institutes by providing such digital noticeboard.
Application Area
The proposed system is currently mainly intended to be applied in educational institutes as an
online notice board and file sharing system. Further applications of this system may include
any type of office or business organizations where computers with working internet connection
is available.
Hardware Interfaces: - The system will interact with the hardware resources of the system on
which it is running. While any system will support the core software, a device with push
messaging facility is recommended for Windows 8 or Android app.
Software Interfaces: - Only Windows 8 and Android OS will support this software’s apps. It
will have the most interaction with an external database server. It may also be integrated with
other systems like Employee Management System and/or Student Management System.
5
System Actors and User
The system has two major actors and each actor has its features to carry out as follows:
Admin
Admin is the person who controls, monitors and keeps the whole follow of the system. The
main functions of the admin are:
• To keep and track down the total number of users in the system.
• Update Password
Student
Student is a knowledge seeker, or more theoretical word, a learner. The student has to be
registered and log in into the system before he/she carries out their functions.
• Student Registration
• Login
• Update Profile
• Update Password
6
Chapter 3: System Design
0.0
LogIn/LogOut
Online Login/LogOut
Admin Notice Student
Alert Display Info
Board
System
7
3.1.2 First level dfd: -
1.0
2.0
Request for Login View All Notice, new/old
Admin Existing D1 notice
Update/Delete notice
Alert
Students
3.0
Request for details
Admin Notice Existing Notices/Latest News
D2 notice
Get Some Infomations For Display Notice
Students
8
3.1.3 Second level dfd: -
3.1
Create Notice New Student Details
Student Notice D2 user
Alert
For Response
Students
3.2
Request for notice Fetching Student Details
Notice
Student D2 user
Display notice For Student Details
Students
3.3
9
Er - Diagram: -
ID
Name
Notice
Descripti
Date
on
Notice
ID
1 M
Notice View Student/other
M
Add
Notice
BranchID
1
Email
Branch Class
Name
Name
ID
Courses
10
Normalization
11
3.1.6 3rd Normal Form: -
[Link] Student Table
12
4002 2002 CSC301 84 End Term 256
Student_id P_id
2001 P1
2002 P2
2003 P3
P2 P. DBMS DBMS
P3 P. Account Account
13
Chapter 4: Coding
Admin Dashboard
<?php
session_start();
if (isset($_POST['update_profile'])) {
if ($query_run) {
[Link] = 'admin_dashboard.php'
</script>";
} else {
[Link] = 'admin_dashboard.php'
</script>";
14
if (isset($_POST['send_notice'])) {
if ($query_run) {
[Link] = 'admin_dashboard.php';
</script>";
} else {
[Link] = 'admin_dashboard.php';
</script>";
?>
<!DOCTYPE html>
<head>
<meta charset="utf-8">
<title>Admin Dashboard</title>
15
<script src="../bootstrap-4.4.1/js/[Link]" charset="utf-8"></script>
<script type="text/javascript">
$(document).ready(function() {
$("#edit_profile_button").click(function() {
$("#main_content").load('edit_profile.php');
});
$("#create_notice_button").click(function() {
$("#main_content").load('create_notice.php');
});
$("#view_notice_button").click(function() {
$("#main_content").load('view_all_notice.php');
});
});
</script>
</head>
<body>
16
<!-- Header section code start here -->
<div class="col-md-4">
</div>
<div class="col-md-4">
</div>
<div class="col-md-4">
</div>
</div>
<br>
<section id="container">
<div class="row">
<hr>
17
<a href="[Link]" type="button" class="btn btn-success btn-block">Logout</a><br>
</div>
<p>
Welcome to Admin Dashboard page. Here admin can be mangage notice board system.
He create a notice, delete a notice and all the replies of the notice.</p>
<p>On Coursera, you can choose from thousands of online courses taught by faculty
from world-class universities like Yale, Stanford, and Princeton, and gain skills in fields such
as data science, finance, cloud computing, and graphic design.
<p>
You're receiving this monthly email because you turned on Location History, a Google
Account-level setting that saves where you go in your private Timeline.
Location History data also helps give you personalized information on Google,
including better restaurant recommendations, and suggestions for a faster commute. You can
view, edit, and delete this data anytime in Timeline.
</p>
</div>
</div>
</section>
</body>
</html>
18
Create notice
<!DOCTYPE html>
<head>
<meta charset="utf-8">
<title>Create Notice</title>
</head>
<body>
<center>
</center>
<br>
<div>
<div class="form-group">
<label>To Whom:</label>
<option>To All</option>
<option>BCA</option>
<option>[Link] IT</option>
<option>[Link]</option>
19
<option>Polytechnic</option>
<option>[Link]</option>
<option>MCA</option>
</select>
</div>
<div class="form-group">
<label>Post Date:</label>
</div>
<div class="form-group">
<label>Subject:</label>
</div>
<div class="form-group">
<label>Message:</label>
</div>
</form>
</div>
</body>
</html>
20
Edit profile
<?php
session_start();
$name = "";
$email = "";
$password = "";
$name = $row['name'];
$email = $row['email'];
$password = $row['password'];
?>
<!DOCTYPE html>
<head>
<meta charset="utf-8">
<title></title>
</head>
21
<body>
<div class="form-group">
<label>Name:</label>
</div>
<div class="form-group">
<label>Email:</label>
</div>
<div class="form-group">
<label>Password:</label>
</div>
</form>
</body>
</html>
22
Index
<?php
session_start();
if (isset($_POST['login'])) {
if (mysqli_num_rows($query_run)) {
$_SESSION['email'] = $_POST['email'];
echo "<script>
[Link] = 'admin_dashboard.php';
</script>";
} else {
</script>";
?>
23
<!DOCTYPE html>
<head>
<meta charset="utf-8">
</head>
<body>
<div class="col-md-4">
</div>
<div class="col-md-4">
</div>
<div class="col-md-4">
</div>
</div>
24
<section id="login_form">
<div class="row">
<center>
<h4>Admin Login</h4>
</center>
<div class="form-group">
<lable>Email ID:</label>
</div>
<div class="form-group">
<lable>Passowrd:</label>
</div>
</form>
</div>
</div>
</section>
</body>
</html>
25
Logout
<?php
session_start();
session_unset();
session_destroy();
header("Location:[Link]");
?>
Register
<?php
if (isset($_POST['register'])) {
if ($query_run) {
[Link] = '[Link]';
</script>";
} else {
26
[Link] = '[Link]';
</script>";
?>
<!DOCTYPE html>
<head>
<meta charset="utf-8">
</head>
<body>
<div class="col-md-4">
</div>
<div class="col-md-4">
27
<h3>Online Notice Board System</h3>
</div>
<div class="col-md-4">
</div>
</div>
<section id="login_form">
<div class="row">
<center>
</center>
<div class="form-group">
<lable>Full Name:</label>
</div>
<div class="form-group">
<lable>Email ID:</label>
</div>
<div class="form-group">
28
<lable>Passowrd:</label>
</div>
</form>
</div>
</div>
</section>
</body>
</html>
<!DOCTYPE html>
<head>
<meta charset="utf-8">
<title></title>
</head>
<body>
<br>
29
<center><h3>All Notices</h3></center><br>
<?php
$connection = mysqli_connect("localhost","root","");
$db = mysqli_select_db($connection,"online_notice_board");
$query_run = mysqli_query($connection,$query);
while($row = mysqli_fetch_assoc($query_run)){
?>
<div class="card">
<div class="card-body">
</div>
</div>
<?php
?>
</body>
</html>
30
Edit profile
<?php
session_start();
$fname = "";
$lname = "";
$email = "";
$password = "";
$class = "";
$fname = $row['fname'];
$lname = $row['lname'];
$email = $row['email'];
$password = $row['password'];
$class = $row['class'];
?>
<!DOCTYPE html>
31
<head>
<meta charset="utf-8">
<title></title>
</head>
<body>
<div class="form-group">
<label>First Name:</label>
</div>
<div class="form-group">
<label>Last Name:</label>
</div>
<div class="form-group">
<label>User ID:</label>
</div>
<div class="form-group">
<label>Password:</label>
32
<input type="password" class="form-control" name="password" value="<?php echo
$password; ?>">
</div>
<div class="form-group">
<label>Select Course:</label>
<option>BCA</option>
<option>[Link] IT</option>
<option>[Link]</option>
<option>Polytechnic</option>
<option>[Link]</option>
<option>MCA</option>
</select>
</div>
</form>
</body>
</html>
33
Index
<?php
session_start();
if (isset($_POST['login'])) {
if (mysqli_num_rows($query_run)) {
$_SESSION['email'] = $_POST['email'];
$_SESSION['class'] = $row['class'];
echo "<script>
[Link] = 'user_dashboard.php';
</script>";
} else {
</script>";
34
?>
<!DOCTYPE html>
<head>
<meta charset="utf-8">
</head>
<body>
<div class="col-md-4">
</div>
<div class="col-md-4">
</div>
<div class="col-md-4">
</div>
35
</div>
<section id="login_form">
<div class="row">
<center>
<h4>Student Login</h4>
</center>
<div class="form-group">
<lable>User ID:</label>
</div>
<div class="form-group">
<lable>Passowrd:</label>
</div>
</form>
</div>
</div>
36
</section>
</body>
</html>
Register
<?php
if (isset($_POST['register'])) {
if ($query_run) {
[Link] = '[Link]';
</script>";
} else {
[Link] = '[Link]';
</script>";
37
}
?>
<!DOCTYPE html>
<head>
<meta charset="utf-8">
</head>
<body>
<div class="col-md-4">
</div>
<div class="col-md-4">
</div>
<div class="col-md-4">
</div>
38
</div>
<section id="login_form">
<div class="row">
<center>
<h4>Registration form</h4>
</center>
<div class="form-group">
<lable>First Name:</label>
</div>
<div class="form-group">
<lable>Last Name:</label>
</div>
<div class="form-group">
<lable>User ID:</label>
</div>
<div class="form-group">
39
<lable>Passowrd:</label>
</div>
<div class="form-group">
<option>-Select-</option>
<option>BCA</option>
<option>[Link] IT</option>
<option>[Link]</option>
<option>Polytechnic</option>
<option>[Link]</option>
<option>MCA</option>
</select>
</div>
</form>
</div>
</div>
</section>
</body>
</html>
40
User Dashboard
<?php
session_start();
if (isset($_POST['update_profile'])) {
if ($query_run) {
[Link] = 'user_dashboard.php'
</script>";
} else {
[Link] = 'user_dashboard.php'
</script>";
?>
<!DOCTYPE html>
41
<html lang="en" dir="ltr">
<head>
<meta charset="utf-8">
<title>Student Dashboard</title>
<script type="text/javascript">
$(document).ready(function() {
$("#edit_profile_button").click(function() {
$("#main_content").load('edit_profile.php');
});
$("#view_notice_button").click(function() {
$("#main_content").load('view_notice.php');
});
});
</script>
</head>
<body>
42
<div class="col-md-4">
</div>
<div class="col-md-4">
</div>
<div class="col-md-4">
</div>
</div>
<br>
<section id="container">
<div class="row">
<hr>
</div>
<p>
43
This is the student Dashboard page. Here student cannot be manage notice board system. He
didn't create a notice, delete a notice and all the replies of the notice. </p>
<p>On Coursera, you can choose from thousands of online courses taught by faculty from
world-class universities like Yale, Stanford, and Princeton, and gain skills in fields such as data
science, finance, cloud computing, and graphic design.<p>
You're receiving this monthly email because you turned on Location History, a Google
Account-level setting that saves where you go in your private Timeline.
Location History data also helps give you personalized information on Google, including
better restaurant recommendations, and suggestions for a faster commute. You can view, edit,
and delete this data anytime in Timeline.
</p>
</div>
</div>
</section>
</body>
</html>
View Notice
<!DOCTYPE html>
<head>
<meta charset="utf-8">
<title></title>
</head>
<body>
<br>
<center>
44
<h3>Notices for You</h3>
</center><br>
<?php
session_start();
$query = "select * from notice where to_whom = 'To All' OR to_whom = 'To Class
$_SESSION[class]'";
?>
<div class="card">
<div class="card-body">
</div>
</div>
<?php
?>
</body>
</html>
45
Chapter 5: Screenshot
46
Admin Login
47
Admin Dashboard
48
Admin Profile
49
Admin Send Notice Form
50
All Notice
51
Registration Form
52
Student Login
53
Students Profile
54
Students Dashboard
55
Students Notice
56
Chapter 6: Conclusion
Future Look
Notices can be displayed in the form of word document, power point, video clips by uploading
them directly. This can be done by using a suitable operating system, program files, drivers,
players so as to make them more eye-catching. Such notices can be displayed by using a
webpage and giving an access to authorised users. The best way is the use of an INTERNET.
An IP address can be used to achieve this. The IP will enable the user to upload any notice and
from anywhere in the world. Moreover, cloud can be used to dump the past notices and keep
record of them.
Conclusion
With the day-to-day advancement in technology the Notice Boards are also evolving from a
hand- written system to a digital display and further to a Wireless Display System. The
paperreflects a Digital Notice Board System with a GSM module and raspberry pi, which
displays the desired notices in the form of a text or an image or video on the LCD screen
through a SMS. Multiple notices can be displayed simultaneously in parallel withan image or
video. Use of a password scheme before the message and for starting the notice board display
has also enhanced the security concerns.
Thus, the Online Notice Board System it is developed and executed successfully.
57