Final Report Dynamic Timetable
Final Report Dynamic Timetable
Final Report Dynamic Timetable
In this final year we have developed the project that will help people in different
sections for solving their needs and requirements.
1 Introduction 1
1.1. Need for the System
1.2. Problem Definition
6 Costing 29
6.1 Cost of project
7 Other Aspects 30
7.1.Advantages
7.2.Applications
7.3.Future Scope
8 Future Scope 31
9 Conclusion and References 32
Figures: -
2 E-R Diagram 6
3 Activity Diagrams 7
Activity Diagram (Admin Login)
Activity Diagram (HOD Login)
Activity Diagram (Student Login)
Activity Diagram (Registrar Login)
Index of Tables: -
1
Functionalities:
2
CHAPTER 2
REQUIREMENT ANALYSIS & FEASIBILITY STUDIES [8]
Hardware Specification:
Content Description
HDD 20 GB Min
40 GB Recommended
RAM 1 GB Min
2 GB Recommended
Keyboard Standard 102 keys
Mouse 3 buttons
3
Software Specification:
Platform Windows
Language HTML,PHP
Database MySQL
Library Jquery
Feasibility Study:
4
CHAPTER 3 [7]
SYSTEM DESIGN AND ARCHITECTURE
E-R diagram:
5
Activity Diagram:
1. System overview
master
timetable
add
timetable
class room
log in dashboard
lab
user
staff
time
day
master
class
timetable
add timetable
staff
class room
log in dashboard
lab
user
staff
time
6
add
master timeslot teacher
timetable lecture
day
add subject
timetable
type
labs
class room
log in dashboard class name
practical batches subject
lab
user
teacher
staff
time
master
timetable
add timetable
add class
room
class room
log in dashboard delete
lab
user
staff
time
7
5. Module:Subject
Master
Add
Timetable
ClassRoom
Login Dashboard
Lab Sub_name
user Add
SubjectCourse
name
Delete
Time
6. Module:Lab
Master
ClassRoom
Add Lab_name
Login Dashboard Lab
Delete
user Subject
Time
8
7. Module: Timeslot
Master
Add
Timetable
user Subject
Add
Add
Timeslot
Time
Delete
8. Module:Main Module
select days
Select Teacher
Timeslot
Sub_name
Lecture
Teacher
Add days name
Timetable Type
Labname
Class
Practical Batch Sub_name
Sub_name
Add
Course
Subject
name
Delete
AddAdd
Time Timeslot
Delete
9
CHAPTER4
CODING AND SCREENSHOTS
<!DOCTYPE html>
<html lang="en">
<head>
<title>Timetable</title>
</head>
<body>
<div class="bg-page py-5" style="background-color: #3c8dbc ">
<div class="container">
<!-- main-heading -->
<h2 class="main-title-w3layouts mb-2 text-center text-
black">Admin Login</h2>
<!--// main-heading -->
<div class="form-body-w3-agile text-center w-lg-50 w-sm-
75 w-100 mx-auto mt-5">
<form method="post" action="" id="formval" >
<div>
<label>Username</label>
<input type="text" name="username" class="form-
control" placeholder="Username">
</div>
<div>
<label>Password</label>
<input type="password" name="password"
class="form-control" placeholder="Password">
</div>
10
<button type="submit" name="btn_login" class="btn
btn-primary error-w3l-btn mt-sm-5 mt-3 px-4"
id="login">Login</button>
</form> </div> </div> </div>
</body></html>
<?php
include "database.php";
if (isset($_POST['btn_login'])) {
}
}
}
11
?>
12
Code for lab add:
<!DOCTYPE html>
<html>
<head>
</head>
<body class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">
<header class="main-header">
13
<li>
<!-- inner menu: contains the actual data -->
<p>
Government Polytechnic Nashik
</p>
</li>
</li>
<!-- Menu Footer-->
<li class="user-footer">
<div class="pull-right">
<a href="index.php" class="btn btn-default btn-flat"
style="color: red">Sign out</a>
</div>
</li>
</ul>
14
</li>
<!-- Control Sidebar Toggle Button -->
<!-- <li>
<a href="#" data-toggle="control-sidebar"><i class="fa fa-
gears"></i></a>
</li> -->
</ul>
</div>
</nav>
</header>
<!-- Left side column. contains the logo and sidebar -->
<aside class="main-sidebar">
<!-- sidebar: style can be found in sidebar.less -->
<section class="sidebar">
<!-- Sidebar user panel -->
<div class="user-panel">
<div class="pull-left image">
<img src="img/index.jpg" class="img-circle" alt="User
Image">
</div>
<div class="pull-left info">
<p>Admin</p>
<a href="#"><i class="fa fa-circle text-success"></i>
Online</a>
</div>
</div><br><br>
<!-- search form -->
<!-- <form action="#" method="get" class="sidebar-form">
<div class="input-group">
<input type="text" name="q" class="form-control"
placeholder="Search...">
<span class="input-group-btn">
<button type="submit" name="search" id="search-btn"
class="btn btn-flat">
15
<i class="fa fa-search"></i>
</button>
</span>
</div>
</form> -->
<!-- /.search form -->
<!-- sidebar menu: : style can be found in sidebar.less -->
<ul class="sidebar-menu" data-widget="tree">
<li class="header">MAIN NAVIGATION</li>
<li>
<a href="dashboard.php">
<i class="fa fa-dashboard"></i>
<span>Dashboard</span> </a>
</li>
<li>
<a href="addttdemo.php">
<i class="fa fa-files-o"></i>
<span>Add Timetable</span> </a>
</li>
<li>
<a href="classroom.php">
<i class="fa fa-th"></i>
<span>Classroom</span> </a>
</li>
<li>
<a href="lab.php">
<i class="fa fa-pie-chart"></i>
<span>Labs</span></a>
</li>
<li>
16
<a href="staff.php">
<i class="glyphicon glyphicon-user"></i>
<span>Staff</span> </a>
</li>
<li>
<a href="subject.php">
<i class="app-menu icon fa fa-files-o"></i>
<span>Subject</span> </a>
</li>
<li>
<a href="time.php">
<i class="glyphicon glyphicon-time"></i>
<span>Time</span> </a>
</li>
</section>
<!-- /.sidebar -->
</aside>
<div class="content-wrapper">
<section class="content-header">
<h1> Lab </h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i>
Home</a></li> <li class="active">Lab</li>
<li class="active">Add Lab</li>
</ol>
</section>
<hr>
<hr>
<form id="formval" action="" method="post">
17
<div>
<div class="form-group col-md-3">
<label class="control-label">Lab</label>
<input class="form-control" type="text" placeholder=""
name="lab" id="lab" >
</div><br><br><br><br>
18
<script src="bower_components/jquery-
slimscroll/jquery.slimscroll.min.js"></script>
<!-- ChartJS -->
<script src="bower_components/chart.js/Chart.js"></script>
<!-- AdminLTE dashboard demo (This is only for demo purposes) -
->
<script src="dist/js/pages/dashboard2.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
</body>
</html>
<?php
include("database.php");
if(isset($_POST['addlab']))
{
if($connection)
{
$lab=$_POST['lab'];
$query=mysqli_query($connection,"INSERT INTO lab (lab)
VALUES('$lab')");
if($query)
{
echo "added successfully";
}
else{
echo mysqli_error($connection);
}
}
}
?>
19
Code for lab module :
</head>
<body class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">
<header class="main-header">
<li>
<!-- inner menu: contains the actual data -->
20
<!-- Tasks: style can be found in dropdown.less -->
<p>
Government Polytechnic Nashik
</p>
</li>
</li>
<!-- Menu Footer-->
<li class="user-footer">
<div class="pull-right">
<a href="index.php" class="btn btn-default btn-flat"
style="color: red">Sign out</a>
</div>
</li>
</ul>
</li>
<!-- Control Sidebar Toggle Button -->
<!-- <li>
21
<a href="#" data-toggle="control-sidebar"><i class="fa fa-
gears"></i></a>
</li> -->
</ul>
</div>
</nav>
</header>
<!-- Left side column. contains the logo and sidebar -->
<aside class="main-sidebar">
<!-- sidebar: style can be found in sidebar.less -->
<section class="sidebar">
<!-- Sidebar user panel -->
<div class="user-panel">
<div class="pull-left image">
<img src="img/index.jpg" class="img-circle" alt="User
Image">
</div>
<div class="pull-left info">
<p>Admin</p>
<a href="#"><i class="fa fa-circle text-success"></i>
Online</a>
</div>
</div><br><br>
<!-- search form -->
<!-- <form action="#" method="get" class="sidebar-form">
<div class="input-group">
<input type="text" name="q" class="form-control"
placeholder="Search...">
<span class="input-group-btn">
<button type="submit" name="search" id="search-btn"
class="btn btn-flat">
<i class="fa fa-search"></i>
</button>
</span>
22
</div>
</form> -->
<!-- /.search form -->
<!-- sidebar menu: : style can be found in sidebar.less -->
<ul class="sidebar-menu" data-widget="tree">
<li class="header">MAIN NAVIGATION</li>
<li>
<a href="dashboard.php">
<i class="fa fa-dashboard"></i>
<span>Master Timetable</span> </a>
</li>
<li>
<a href="stafftt.php">
<i class="fa fa-user"></i>
<span>Staff Timetable</span> </a>
</li>
<li>
<a href="addttdemo.php">
<i class="fa fa-files-o"></i>
<span>Add Timetable</span> </a>
</li>
<li>
<a href="classroom.php">
<i class="fa fa-th"></i>
<span>Classroom</span> </a>
</li>
<li>
<a href="lab.php">
<i class="fa fa-pie-chart"></i>
<span>Labs</span></a>
</li>
23
<li>
<a href="staff.php">
<i class="glyphicon glyphicon-user"></i>
<span>Staff</span> </a>
</li>
<li>
<a href="subject.php">
<i class="app-menu icon fa fa-files-o"></i>
<span>Subject</span> </a>
</li>
<li>
<a href="time.php">
<i class="glyphicon glyphicon-time"></i>
<span>Time</span> </a>
</li>
</section>
<!-- /.sidebar -->
</aside>
<div class="content-wrapper">
<section class="content-header">
<h1> Dashboard </h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i>
Home</a></li>
<li class="active">Lab</li>
</ol>
</section><hr><hr>
24
<thead class="thead-dark">
<tr>
<th scope="col">Sr. No.</th>
<th scope="col">Lab</th>
<th scope="col">Action</th>
</tr>
</thead>
<tbody><br>
<?php
include "database.php";
$query = mysqli_query($connection,"SELECT * FROM lab");
$n=1;
if($query) {
while($row = mysqli_fetch_array($query)){
?>
<tr>
<th scope="row"><?php echo $n; ?></th>
<td><?php echo $row['lab']; ?></td>
<td><a href='deletelab.php?srno=<?php echo
$row['srno']; ?>' class="btn btn-danger">Delete</a></td>
<?php $n++; ?>
</tr>
<?php
}
}
?>
</table >
</html>
25
SCREENSHOTS:
Log in:
Master timetable:
26
Staff Timetable :
Add timetable :
27
Lecture assign :
Overlapping:
28
Overlapping error:
Add practical :
29
Class module:
Add class :
30
Labs :
Add lab :
31
Staff :
Add staff :
32
Subject :
Add subject :
33
Add timeslot :
34
CHAPTER 5
TESTING
System testing
System testing tests the system as a whole. Once all the components are integrated,
the application as a whole is tested rigorously to see that it meets the specified Quality
Standards. This type of testing is performed by a specialized testing team.
a. System testing is the first step in the Software Development Life Cycle,
where the application is tested as a whole.
b. The application is tested thoroughly to verify that it meets the functional
and technical specifications.
Types of Tests
Unit testing
This type of testing is performed by developers before the setup is handed over to the
testing team to formally execute the test cases. Unit testing is performed by the respective
developers on the individual units of source code assigned areas. The goal of unit testing is to
isolate each part of the program and show that individual parts are correct in terms of
requirements and functionality.
Integration testing
35
Functional test
Functional tests provide systematic demonstrations that functions tested are available
as specified by the business and technical requirements, system documentation, and user
manuals. Functional testing is centered on the following items:
System Test
System testing tests the system as a whole. Once all the components are integrated,
the application as a whole is tested rigorously to see that it meets the specified Quality
Standards. This type of testing is performed by a specialized testing team.
White-box testing is the detailed investigation of internal logic and structure of the code.
White-box testing is also called glass testing or open-box testing. In order to perform white-box
testing on an application, a tester needs to know the internal workings of the code.
The technique of testing without having any knowledge of the interior workings of the
application is called black-box testing. The tester is oblivious to the system architecture and
does not have access to the source code. Typically, while performing a black-box test, a tester
will interact with the system's user interface by providing inputs and examining outputs
without knowing how and where the inputs are worked upon.
36
Acceptance Testing
This is conducted by the Quality Assurance Team who will gauge whether the
application meets the intended specifications and satisfies the client’s requirement.
Test Cases:
Login Model:
Sr. Test Test case Step I/P Data Expected Actual Status
no Case Objective Result Result
ID
1 TC1 If a user 1.open Enter the Username Login Pass
will be able the login username and successfully
to login form and password
with a valid 2.write password is valid ,so
username username login the
and valid and page
password password
TC2 If a user 1.open Wrong Message Invalid Fail
2 cannot the login password for invalid password
login with form password
a valid 2.enter
username the valid
and an username
invalid and
password invalid
password
TC3 When the Does not Message Message It required Fail
3 filed is enter for this for this username
blank and password filed filed and
submit and required required password
button is username username username
clicked and and
password password
TC4 If user is Enter Correct User User login Pass
4 able to username username should be to
login and and login to Dashboard
successfully password correct dashboard
password
5 TC5 Verify the Enter the Wrong Message Message Pass
message for invalid username for invalid for invalid
invalid password and password password
and password and and
username username username
37
2) MasterTimeTable Model:
SR. Test Test case step I/P data Expected Actual Status
No case objective result result
id
1 TC2 To check 1.select Select the Does not Does not Fail
add the the day day submit submit
day and 2.click successfully successfully
does not submit
add class button
Whether
is submit
or not
2 TC2 To check 1.select Select the It show the It show the Fail
does not the class class message message
add day 2.click on please add please add
and add submit the day the day
class
Whether
is submit
or not
3. TC3 To check 1.does Does not show the It show the Fail
does not not select select message message
select class and class and please add please add
day and day day the day the day
class 2.click on
submit
4 TC4 To check 1.does select show the It show the Fail
does not not select teacher message message
add day day please add please add
and add 2.click on the day the day
teacher submit
Whether
is submit
or not
38
3) Add Time Tabel Model:
Sr. Test Test case Step I/P Data Expected Actual Status
No case objective result Result
id
1 TC1 Does not 1.select Does not Show the It show Fail
select on other select message the
timeslot module timeslot enter message
2.does timeslot
not select
Timeslot
3.click
on
submit
2 TC2 Does not 1.select Does not Show the It show Fail
select on other select type message the
type module model select the message
model 2.does item
not
select
type
model
3.click
on
submit
3 TC3 Does not 1.select Does not Show the It does Pass
select on other select day message not show
day module select the the
2.does item message
not
select
day
3.click
on
submit
4 TC4 If select 1.select select same It show the It does pass
same all item timeslot, message not show
timeslot, 2.click same day teacher are the
same day on and same already message
and same submit class name assign
class This class
name and this
timeslot
39
40
4) All module:
Sr. Test Test case step I/P Data Excepted Actual status
No case objective output output
id
1 TC1 Add staff 1. click Add the Show the Add staff pass
on the staff message successfully
add add staff
button successfully
2. then
click on
submit
2 TC2 Delete 1. click Delete the Show the Delete staff pass
the staff on the staff message successfully
delete delete staff
button successfully
2. then
delete
the staff
3 TC3 add the 1.click add the Show the Add class pass
class on the class message successfully
add add class
button successfully
4 TC4 Delete 1.click Delete the Show the Delete class Pass
the class on the class message successfully
delete delete class
button successfully
5 TC5 add the 1. click add the lab Show the Add lab pass
lab on the message successfully
add add lab
button successfully
2. then
add the
lab
6 TC6 Delete 1. click Delete the Show the Delete lab pass
the lab on the lab message successfully
delete delete lab
button successfully
2. then
delete
the lab
7 TC7 add the 1.click add the Show the Show the pass
subject on the subject message message
add add subject add subject
button successfully successfully
41
2. then
add the
subject
8 TC8 Delete 1. click Delete the delete Delete pass
the on the subject subject subject
subject delete successfully successfully
button
2. then
delete
the
subject
42
CHAPTER 6
COSTING [8]
Cost of project:
1. Work hour 80
2. Group members 4
6. Internet hours 40
43
CHAPTER 7
OTHER ASPECTS
Advantages:
There are some of advantages for the using the Dynamic Timetable instead of manually
creating Timetable. Those are:
Disadvantage:
While we are using the Dynamic Timetable there are also 2 drawbacks those are:
44
CHAPTER 8
FUTURE SCOPE
45
CHAPTER 9
CONCLUSION AND REFERENCES
References
https://en.wikipedia.org/wiki/Bootstrap_(front-end_framework)
https://www.guru99.com/what-is-php-first-php-program.html
https://www.php.net/manual/en/intro-whatcando.php
46