‘TIME TABLE MANAGEMENT SYSTEM NITS POLYTECHNIC Indira Nagar, Miran Sahib, JAMMU- J&K Estd.: 1984 A PROJECT REPORT ON “TIME TABLE MANAGEMENT SYSTEM” Session May-June 2014 PROJECT GUIDE: SUBMITTED BY: Er. Dalip Kohli DEEPAK SHARMA DEPARTMENT OF INFORMATION TECHNOLOGY, NITS RECOGNISED BY J&K GOVT., (AFFILIATED TO J&K STATE BOARD OF TECHNICAL EDUCATION) APPROVED BY [Link].T.E GOVT OF INDIA 1TIME TABLE MANAGEMENT SYSTEM NITS POLYTECHNIC Indira Nagar Miran Sahib , JAMMU- J&K Estd.: 198 Session: May-June (2014) Department Of Information Technology Engineering CERTIFICATE This is to certify that DEEPAK SHARMA AND RAKESH KUMAR students of Vith Semester IT Engg. have successfully completed the Major Project Work entitled “TIME TABLE MANAGEMENT SYSTEM” for the fulfillment of award of Three Years Diploma in IT Engg. Of State Board of Technical Education, J&K oo ND wae ae PROJECT GUIDE pt. of IT Engg.) (Dept. of IT Engg.)‘TIME TABLE MANAGEMENT SYSTEM ACKNOWLEDGEMENT We feel immense pleasure in thanking our Principal, for having permitted us to carry out this project work. We wish to express our deep sense of gratitude to our Project Guide, Er. Dalip Kohli , Hop. Dept. Of IT Engg. For their able guidance and uscful suggestions, which helped us in completing the project work titled “TIME TABLE MANAGEMENT SYSTEM”. Words are inadequate in offering our heartfelt thanks to our beloved parents for their blessings. encouragement, and wishes for the successful competition of this project. PROJECT TEA! DEEPAK SHARMA (5026) RAKESH KUMAR (5040) Place: - Jammu‘TIME TABLE MANAGEMENT SYSTEM. INTRODUCTION This project would cover the basic need of college to arrange their Time Tables. College can add new teachers, edit teacher’s record, search record of teacher, college can also add new courses, edit course description and search particular course and college can also add various subjects and edit/ delete the subjects information. College can manage the information about the different periods, their timings and day schedules and can manage the time table of the period in which class which period is taken by the which professor. College can also make changes in the timetable of the lectures and change their schedule too. College can make change in the timing of the lectures too. College can also search in which room is lecture is taken by which teacher. In this project report of all entries are generated so that college can take the print out of time table of all.TIME TABLE MANAGEMENT SYSTEM 1. Administrator Panel a. Login Required. b. Add/Update/Delete teacher. c. Add/Update/Delete course. d. Add/Update/Delete subject. e. Add/Update/Delete periods. f. Add/Update/Delete timetable. any any any any any information information information information information about the about the about the about the about theTIME TABLE MANAGEMENT SYSTEM. OBJECTIVES The purpose of this project is to provide full efficient system about the Time Table Management. This project is useful for college. It provides a convenient way to deal with timetable of the college Providing platform to manage the information about teachers and courses in easy way. The main objectives of this project are:- >» Administrative: The Admin can insert, edit and search the data of the teachers, courses, subjects, periods and timetable of the each course and each teacher.TIME TABLE MANAGEMENT SYSTEM SYSTEM SPECIFICATION HARDWARE AND SOFTWARE REQUIREMENTS HARDWARE REQUIREMENTS Hardware is the important part of computer system whose presence can be felt by physically 1. 13 PROCESSOR 2. KEYBOARD 3. MOUSE 4. MONITOR 5, RAM-512 MB (MINIMUM) 6. WINDOW SEVENTIME TABLE MANAGEMENT SYSTEM SOFTWARE REQUIREMENTS Software is another important part of computer system that is required for performing some application, system or utility work. The software tools in our project are: 4. VISUAL STUDIO 2008(professional edition) 2. .NET FRAME WORKTIME TABLE MANAGEMENT SYSTEM INTRODUCTION TO LANGUAGE We have chosen SQL SERVER 2005 as Back End & [Link] as Front-end in this project. TOOLS / ENVIRONMENT USED Loo. EEE ¥ FRONT END TOOL [Link] 3.5 or NET Framework3.5 ¥ BACK END TOOL : Microsoft AccessTIME TABLE MANAGEMENT SYSTEM Introduction to VISUAL BASIC 2008 Visual Basic 2008 is a development tool that you can use to build software applications that perform useful work and look great within a variety of settings. Using Visual Basic 2008, you can create applications for the Windows operating system, the Web, hand-held devices, and a host of other environments and settings. The most important advantage of Visual Basic is that it has been designed to increase productivity in your daily development work— especially if you need to use information in databases or create solutions for the Internet—but an important additional benefi t is that once you become comfortable with the development environment in Microsoft Visual Studio 2008, you can use the same tools to write programs for Microsoft Visual C++ 2008, Microsoft Visual C# 2008, Microsoft Visual Web Developer 2008, and other third-party tools and compilers. Visual Basic .NET Versions So how did we get here, anyway? The fi rst version of Visual Basic NET (Microsoft Visual Basic .NET 2002) was released in February 2002. The second release (Microsoft Visual Basic .NET 2003) was widely available in March 2003. Next came Visual Basic 2005 in late 2005, and after a long period of development and integration work, Microsoft released Visual Basic 2008 in early 2008. Visual Basic 2008 is now so tightly integrated with Visual Studio 1TIME TABLE MANAGEMENT SYSTEM that it is only available as a component in the Visual ‘| Studio 2008 programming suite, which includes Visual C#, y visual C++, Visual Web Developer, and other Microsoft NET development tools. Visual Studio 2008 is sold in several different product configurations, — including Standard Edition, Professional Edition, Team Suite, and Express Edition. I’ve written this book to be compatible with all editions of Visual Basic 2008 and Visual Studio 2008, but especially with the tools and techniques available in Visual Studio Standard Edition and Visual Studio Professional Edition. Although Visual Basic 2008 is similar in many ways to Visual Basic 2005, there are many important differences and improvements, Upgrading from Microsoft Visual Basic 6.0 Before Visual Basic .NET, of course, the programming world was blessed to have Visual Basic 6, originally released ten years ago in September 1998. Visual Basic 6 was so popular that many programming enthusiasts continue to use it, especially developers outside of Europe and North America, where hardware upgrades can be a little harder to come by. (For those of you Visual Basic 6 users who have written me letters from Africa and Asia, thank you!) In some respects, | can’t blame you—Visual Basic 6 was and is awesome for its ease-of-use and Straightforward programming methods. But, as many of us know now, Visual Basic 6 also made creating real professional-grade applications a bit of a chore. As a result, | always felt like | had a speed and size complex 12TIME TABLE MANAGEMENT SYSTEM when | chatted with friends who wrote about their fast and tiny-footprint Visual C++ Programs. To write really complex Visual Basic 6 applications, | usually had to jump through a number of hoops. 13TIME TABLE MANAGEMENT SYSTEM DATA FLOW DIAGRAM TIMETABLE MANAGEMENT CENTRAL DFD Time Table Management Svstem Database File 14~~ Add/Edit/ Search Teacher \ \ TIME TABLE MANAGEMENT SYSTEM TIMETABLE MANAGEMENT LEVEL1 DFD Add/Edit/ Search Course Add/Edit/ eee Search period Database Add/Edit/ Search timetableTIME TABLE MANAGEMENT SYSTEM. TEACHER TABLE ‘ht Dee ce fe War ce Atdemmecntegiotgurterin, ‘esegius Pestare neeTIME TABLE MANAGEMENT SYSTEM ia mn : 3 fem Oem emits Diba ein ® = 9 | De 2 axe ee COURSE TABLE fst s | | { | | ne 7TIME TABLE MANAGEMENT SYSTEM SUBJECT TABLE lors owesTIME TABLE MANAGEMENT SYSTEM PERIOD TABLE a ri g ® m | \ iyi | etenecneg bt ats | eae sae a } me i rey p g & ie i Se niet Nate 3S Dap SapAAN FORM DESIGN Taare E a Te = ig Va = ee 9 \ / aes { Gio 2/6]0 @(s)ele 20LOGIN WINDOW 21TIME TABLE MANAGEMENT SYSTEM MAIN MENUS‘TIME TABLE MANAGEMENT SYSTEM ADD TEACHER WINDOW oS SE AGHER WINDOW 23TIME TABLE MANAGEMENT SYSTEM ADD COURSE 24TIME TABLE MANAGEMENT SYSTEM ADD SUBJECT vat ee)ADD PERIOD TIME é é gt é é ua 6: 6-6-6: o ¢: e: ¢: eTIME TABLE MANAGEMENT SYSTEM SEARCH TEACHER BL? 21) ¢ Slee]TIME TABLE MANAGEMENT SYSTEM SEARCH TIME SEARCH TIME ees i Boe 2 ¢ 0 Geo 29TIME TABLE MANAGEMENT SYSTEM SEARCH SUBJECT SEARCH SUBJECT r Lae Tin Her sy tr iB iy oft Ts Tet abe ip a jeg S40 Meg nen © cide mieTIME TABLE MANAGEMENT SYSTEM - Tee Fea a rapt RA yD fe To Tet ie p23 m beat wee nal 31TIME TABLE MANAGEMENT SYSTEM “se, ce SUE AND CRTC‘TIME TABLE MANAGEMENT SYSTEM & op Ds OS oF 33TIME TABLE MANAGEMEN USYsTem © ae Foay eds = Ba WB Fe To Te ta ip we 4, 3 i ne : 34TIME TABLE MANAGEMENT system CODING en Splash Form public Class splash private Sub Timerl Tick(ByVal sender As [Link], ByVal e As [Link]) Handles .Tick If [Link] = 100 Then login. Show() [Link] = False Else [Link] = [Link] + 10 End If End Sub End Class 35~~ TIME TABLE MANAGEMENT SYSTEM LOGIN FORM public Class login private Sub Buttonl_Click(ByVal sender As system Object, ByVal e As [Link]) Handles [Link] If [Link] = "abc" And [Link] = 3" Then [Link]() [Link]() Else MsgBox ("invalid") End If End Sub 36TIME TABLE MANAGEMENT SYS MDI PARENT FORM m cn As New ction ("provider=[Link].4.0;data e=" & [Link] & "\[Link]") Private Sub ADDToolStripMenuItem Click (ByVal sender [Link], ByVal e As [Link]) Handles [Link] FORM1 . Show () ad Sub Private Sub SEARCHToolStripMenultem_Click (ByVal AS [Link], ByVal e As [Link]) [Link] form2 . Show () es End Sub Private Sub ADDToolStripMenuItem1_Click (ByVal sender As [Link], ByVal e As [Link]) ndles [Link] [Link]() 5 End Sub Private Sub SEARCHToolStripMenulteml_Click (ByVal As [Link], ByVal e As [Link]) [Link] formS . Show () 37 Bee was.TIME TABLE MANAGEMENT SYSTEM pnd Sub Fea etem Obj ee eg bMenuTtem2 Click (ByVal - -Object, ByVal e As [Link]) ADDTOo1StripMenurt System. EventArg venuTtem2. Form6 . Show () eels znd Sub sender 2% yandles private Sub SEARCHToolStripMenultem2_Click (ByVal gender AS [Link], ByVal e As system. EventArgs [Link] foxrm7 . Show () : gEnd Sub pandles private Sub UPDATEToolStripMenuItem_Click (ByVal gender As [Link], ByVal e As [Link]) yandles [Link] form9 . Show () End Sub Private Sub ADDToolStripMenultem3 Click (ByVal sender As [Link], ByVal e As [Link] Handles [Link] form8 .Show() End Sub private Sub TEACHERToo1StripMenultem_Click (ByVal sender As [Link], ByVal e As [Link]) Handles [Link] If [Link] = 2 Then [Link]() [Link]() | Dim QueryString As String QueryString = "Select * from teacher " . Dim Adapter As OleDbDataAdapter = New OleDbDataAdapter (QueryString, cn) 38TIME TABLE MANAGEMENT SYSTEM Dim ds As DataSet = New DataSet () [Link](ds, "teacher") Dim rpt As New CrystalR D c eportl [Link]([Link] & [Link]") rpt .SetDataSource (ds) [Link]() [Link] = rpt End Sub private Sub COURSEToolStripMenuItem_Click (ByVal gender AS [Link], ByVal e As [Link]) gandles [Link] If [Link] = 1 Then [Link]() [Link]() Dim QueryString As String QueryString = "Select * from course Dim Adapter As OleDbDataAdapter = New olepbDataAdapter (QueryString, cn) Dim ds As DataSet = New DataSet () [Link](ds, "course") Dim rpt As New CrystalReport2 [Link]([Link] & "/[Link]") rpt .SetDataSource (ds) Form14. Show () [Link] .ReportSource = rpt End Sub Private Sub SUBJECTToolStripMenultem_Click (ByVal sender As [Link], ByVal e As [Link]) Handles [Link] 39re —————_— y TIME TABLE MANAGEMENT SYSTEM If [Link] = 1 Then c open () hen [Link]() pim QueryString As string QueryString = elect * from subject Dim Adapter As OleDbDataAdapter = New gpbataAdapter (QueryString, cn) Dim ds As DataSet = New DataSet () [Link](ds, "subject") Dim rpt As New CrystalReport3 [Link]([Link] & [Link]") rpt .SetDataSource (ds) Form15 . Show () [Link] = rpt End Sub Private Sub PERIODToolStripMenulItem Click (ByVal der As [Link], ByVal e As System. EventArgs) idles [Link] If [Link] = 1 Then [Link]() [Link]() Dim QueryString As String QueryString = "Select * from period " Dim Adapter As OleDbDataAdapter = New dledbDataAdapter (QueryString, cn) Dim ds As DataSet = New DataSet () [Link](ds, "period") Dim rpt As New CrystalReport4 , [Link]([Link] & /[Link]") 40TIME TABLE MANAGEMENT SYSTEM rpt .Set DataSource (ds) [Link]() [Link] Viewer] .RepextSource = rpt nd Sub f private Sub EXITToolStripMenultem Click (ByVal der As [Link], ByVal e As [Link]) ndles [Link] [Link] () End Sub and Class 41TIME TABLE MANAGEMENT SYSTEM. ADD TEACHER FORM imports System. [Link] public Class FORM1 Dim cn As New oleDbConnection ("provider=[Link].4.0;data & [Link] & "\[Link]") source=" private Sub Button1_Click(ByVal sender As [Link], ByVal e As [Link]) Handles [Link] If [Link] = 1 Then [Link]() Dim cmd As New OleDbCommand("insert into teacher (ename, dese, quali, doj, code) values (@al, @a2,@3, @4, @5}", cn) cmd. Parameters .AddWithValue("@al", [Link]) cmd. Parameters .AddWithValue("@a2", [Link]) cmd. Parameters. AddWithValue("@a3", [Link]) cmd. Parameters .AddWithValue("@a4", [Link]) cmd. Parameters .AddwWithValue("@a5", [Link]) cn. Open() cmd. ExecuteNonQuery () MsgBox ("saved") [Link] = [Link] = 42| — —S—<— TIME TABLE MANAGEMENT SYSTEM End Sub jvate Sub Button2 Click(Byval 5 Object, ee ender As yal e As [Link]) Handles [Link]() pnd Sub . private Sub Button3 Click(ByVal sender As [Link], ByVal e As [Link]) Handles putton3- Click If [Link] = 1 Then [Link]() [Link]() Dim QueryString As s xing QueryString = "Select * from teacher " Dim Adapter As OleDbDataAdapter = New | oleDbDataAdapter (QueryString, cn) Dim ds As DataSet = New DataSet () [Link](ds, "teacher") Dim rpt As New CrystalReport1 [Link]([Link] "/[Link]") rpt .SetDataSource (ds) Form13. Show () [Link] = rpt End Sub ind ClassTIME TABLE MANAGEMENT SYSTEM ADD COURSE FORM ——CERSE FORM imports [Link]. oleppy public Class form4 P Dim cn As New Hee aol erOVider=microsoft. jet oledb 1 O;data source="_ & Application. Startuppath & "\[Link]") “private Sub Buttonl_ Click (Byva1 sender As system. Object, ByVal e As [Link]) Handles [Link] If [Link] = 7 Then [Link]() Dim cmd As New OleDbCommand ("insert into course (code, type, stream, sub) values (@al,@a2,@a3,@4)", on. Y omd. Parameters. AddWithvalue ("@al", [Link]) cmd. Parameters -AddWithValue ( "@a2", TextBox2. Text) omd. Parameters. AddWithValue ( "@a3", TextBox3. Text) cmd. Parameters. AddWithValue("@a4", TextBox4 . Text) cn. Open () cmd. ExecuteNonQuery () MsgBox ("saved") End sub Private Sub Button3 Click(ByVal sender As [Link], ByVal e As [Link]) Handles utton3. Click If [Link] = 1 Then [Link]() cn. Open () Dim QueryString As String QueryString = "Select * from course " a4‘TIME TABLE MANAGEMENT SYSTEM. ppoataadapter (QueryString, cn) - ole’ | | | Dim Adapter As OleDbDataAdapter = New pim ds As DataSet = New Dataset () [Link](ds, "course") Dim rpt As New CrystalReport2 - rpt-Load([Link] & [Link]") rpt -SetDataSource (ds) [Link]() [Link] = rpt ys znd Sub ind CLASS 45TIME TABLE MANAGEMENT SYSTEM ADD SUBJECT FORM rs [Link] ior class Form6é sm cn AS New jeppconnection ("provider-microsoft .[Link].4.0;data oleDP’_" & [Link] & "\[Link]") sourc’jvate Sub Button] Click (ByVal sender As “object, ByVal e As [Link]) Handles Dim cmd As New OleDbCommand ("insert into guvject (code, sub, branch, sem) values (@al, @a2, @3, 04)", en) cmd. Parameters .AddWithValue("@ai", jextBox1 Text) cmd. Parameters .AddWithValue("@a2", x2. Text) gextB cmd. Parameters. AddWithValue("@a3", qextBox3. Text) cmd. Parameters. AddWithValue("@a4", | textBox4 . Text) cn. Open () cmd. ExecuteNonQuery () MsgBox ("saved") End Sub Private Sub Button2_Click(ByVal sender As [Link], ByVal e As [Link]) Handles [Link] [Link]() li iii isi i RET ee & Souhhers mia ne C a5 8% in % 5 2 ° i 4 2 3 s 2 8 3 9 5 8 8 End Sub Private Sub Button3_Click(ByVal sender As Sistem. object, ByVal e As [Link]) Handles htton3. click If [Link] = cn. Open () 1 Then [Link]() 46TIME TABLE MANAGEMENT SYSTEM pim QueryString As String gueryString = "Select * from subject " pim Adapter As OleDbDataadapter = New pataAdapter (QueryString, cn) pl pim ds As DataSet = New Dataset () [Link](ds, "subject") pim rpt As New CrystalReport3 rpt-Load([Link] «& [Link]") rpt .SetDataSource (ds) [Link] (} [Link] = rpt peryst? pnd Sub md Class aayy TIME TABLE MANAGEMENT SYsTEM ADD TIME FORM system. [Link] class form’ nin cn AS New spconnection ("provider=[Link].4.0;data ceo" & [Link] & "\[Link]") private Sub Buttonl_Click(ByVal sender As [Link] ByVal e As [Link]) Handles soni Click OM Tf [Link] = 1 Then [Link]() Dim cmd As New OleDbCommand("insert into no, Start, end) values (@al,@a2,@3)", cn) omd. Parameters .AddWithValue("@al", poBoxl. Text) cmd. Parameters .AddWithValue ("@a2", [Link]) E cmd. Parameters .AddWithValue ("@a3", [Link]) seriod [Link]() cmd. BxecuteNonQuery () MsgBox ("saved") End Sub Private Sub Button3_Click(ByVal sender As [Link], ByVal e As [Link]) Handles ton3. Click If [Link] = 1 Then [Link]() [Link] () Dim QueryString As String 48v TIME TABLE MANAGEMENT system queryString = "Select * from period " pim Adapter As OleDbDataad, taAdapter = gppataadaptex (QueryString, cn) pees es Dim ds As DataSet = New Dataset () [Link](ds, "perioa") Dim rpt As New CrystalReport4 xpt. Load ([Link] & [Link]") [Link] (ds) [Link]() [Link] = rpt ajoryst@ End Sub private Sub Button2_Click(ByVal sender As gystem-Object, ByVal e As [Link]) Handles [Link] , [Link]() End Sub md Class SEARCH/MODIFY/DELETE FORM 49| TIME TABLE MANAGEMENT SYSTEM [Link] ss form2 | nection ("provider=[Link].4.0;data “ ¢ [Link] & "\[Link]") vate Sub teacher_search_Load(ByVal sender As object, ByVal e As [Link]) Handles- se. Load [Link] = TextBox2. Text [Link] [Link] = [Link] = "" Dim cmd As New OleDbCommand("select * from ", cn) If [Link] = 1 Then [Link]() cn. Open () Dim dr As OleDbDataReader dr = [Link] If [Link] = True Then While [Link] [Link] (dr ("ename") ) [Link] = dr("ename") [Link] = dr("dese") [Link] = dr ("quali") [Link] = dr("doj") [Link] = dr ("code") End While Else MsgBox ("sorry data is not found") End If End Sub Private Sub ListBoxl_SelectedIndexChanged (ByVal As [Link], ByVal e As [Link]) ndles [Link] Dim cmd As New OleDbCommand("select * from cher where ename ='" & [Link] & "'", cn) 50TIME TABLE MANAGEMENT SYSTEM rf [Link] = 1 Then [Link]() [Link]() . pim dr As OleDbDataReader dr = cmd. ExecuteReader ff dr-HasRows = True Then While [Link] [Link] = dr("ename") [Link] dr ("dese") [Link] = dr("quali") [Link] = dr("doj") [Link] = dr("code") End While Else MsgBox ("sorry data is not found") end If end Sub ByVal sender As Buttonl_Click( Handles private Sub gystem- Object, ByVal e As [Link]) ton] click Dim cmd As New OleDbCommand ("update set where dese ='" & qauic'" & [Link] 6 [Link] & "'", cn) i£ [Link] = 1 Then [Link]() [Link]() cmd. ExecuteNonQuery () MsgBox ("Data Updated", MsgBoxStyle. YesNo) [Link]() End Sub Private Sub Button2_Click (ByVal sender As Handles [Link], ByVal e As [Link]) [Link] : Dim cmd As New OleDbCommand ("delete from tablel & [Link] & mem) cn) If [Link] = 1 Then [Link]() [Link]() cmd. ExecuteNonQuery () MsgBox ("data deleted") [Link]() 51TIME TABLE MANAGEMENT SYSTEM 52TIME TABLE MANAGEMENT SYSTEM SEARCH COURSE FORM vps system. Data. OleDb wor jass forms prim cn AS New ennection ("provider=micr eee ppplication. Startupeath ¢ sede eee neces at 0 rravate Sub course_search_Load(ByVal sender As sen-opject ByVal e As [Link]) Handles age 202! ae [Link] [Link] [Link] TextBox4 .Text Dim cmd As New OleDbCommand ("select * from worse "s en) If [Link] = 1 Then [Link]() [Link]() Dim dr As OleDbDataReader dr = [Link] If [Link] = True Then While [Link] ListBox1. Items .Add (dr ("CODE") ) [Link] = dr ("CODE") [Link] dr ("type") [Link] dr ("stream") [Link] = dr("sub") End While Else MsgBox("sorry data is not found") End If End Sub Private Sub ListBoxl SelectedIndexChanged (ByVal der As [Link], ByVal e As [Link]) Milles [Link] Dim cmd As New OleDbCommand("select * from Mtse where code ='" & [Link] & "'", cen) If [Link] = 1 Then [Link]() 53TIME TABLE MANAGEMENT SYSTEM cn-open() pim dr AS OleDbDataReader gr = [Link] tf dr-HasRows = True Then While [Link] [Link] dx ("code") [Link] = dr ("type") [Link] = dr("stream") [Link] = dr("sub") End While Else MsgBox ("sorry data is not found") End If snd sub private Sub Buttonl_Click(ByVal sender As gstem-Object, ByVal e As [Link]) Handles [Link] cmd As New OleDbCommand("update set sub ='" & [Link] & "' where stream ='" & [Link] & cn) If [Link] = 1 Then [Link]() [Link]() cmd. ExecuteNonQuery () MsgBox ("Data Updated", MsgBoxStyle. YesNo) [Link]() End Sub Private Sub Button2_Click(ByVal sender As em.0bject, ByVal e As [Link]) Handles [Link] Dim cmd As New OleDbCommand("delete from course here code='" § [Link] & "'", cn) If [Link] = 1 Then [Link]() [Link]() cmd. ExecuteNonQuery () MsgBox ("data deleted") [Link]() 54TIME TABLE MANAGEMENT systEM SEARCH SUBJECT FORM its [Link]. OleDb orm class form? fm cn AS Nee nection ("provider=microsof i aotPe § Application. StartupPath & "\deeee mabe su eivate Sub subject_search Load(Byval sender As geo opsect ByVal e As [Link]) Handles nase Load ae ab pv D: [Link] =" [Link] [Link] [Link] Dim cmd As New OleDbCommand("select * from abject“, on) , If [Link] = 1 Then [Link]() [Link]() Dim dr As OleDbDataReader dr = [Link] If [Link] = True Then While [Link] [Link]{dr ("code") ) [Link] = dr("code") [Link] dr ("sub") [Link] = dr("branch") [Link] = dr("sem") End While Else MsgBox ("sorry data is not found") End If End Sub private Sub ListBoxl_SelectedIndexChanged (ByVal Mer As [Link], ByVal e As [Link]) “les [Link] 55TIME TABLE MANAGEMENT SYSTEM m cmd As New OleDbCommand ("select * from pil =m _ where code ='" § [Link] 4 "'", cn) qf [Link] = 1 Then [Link]( [Link] () m dx AS OleDbDataReader ea = [Link] tf [Link] = True Then While [Link] [Link] = dr("code") [Link] = dr("sub" [Link] = dr ("branch") [Link] = dr("sem") End While Else MsgBox ("sorry data is not found") end if gnd Sub ind CLASS 56TIME TABLE MANAGEMENT SYSTEM SEARCH TIME FORM _ system. [Link] pr crass form9 pst cn As New pin n ("provider=micro Dam pect ion ("Pr e Soft. [Link].4.0;q, pen a Application. Startuppath ¢ "\[Link]") “se ByVal sender As [Link]) Handles cure" jvate Sub Button] Click, Pr opjects ByVal e As Syst opteny click att" "pim cmd As New OleDbCommand (" i g [Link] g "1 update period set where end =!" 5 ngox2- Text & "'", cn) Q If [Link] = 1 Then [Link]() [Link] () ond. ExecuteNonQuery () MsgBox ("Data Updated", [Link]) [Link]() End Sub rate Sub Button2_Click(ByVal sender As Object, ByVal e As [Link]) Handles [Link] Dim cmd As New OleDbCommand ("delete from time ere no='" & [Link] & "', cn) If [Link] = 1 Then [Link](} cn. Open () cmd. ExecuteNonQuery () MsgBox ("data deleted") [Link]() End Sub M4 Class | | 57 LTIME TANIE Man AGEMENT sygr SYSTEM the me esting Yor quality control me, asure employed during g soinware development. Testing is the Process of executing the ogram with intent of finding an ¢ tror, No piece of code is on fully tested. This stage is lage it is ompletely ready unless it has bee very important as at this st 5 verified whether the code developed meet the requirement Specifications or not Moreover, | validation Is also checked in the testing stage. NEED FOR TESTING: ‘esting is vital to the success of the system Testing makes a gical assumption that is if all parts of the system are correct, the ‘get will be successfully achieved. In adequate testing or ‘ontesting leads to errors that may not appear until months later. “small system error can conceivably explode into a much larger “oblem. Effective testing early in the process translates directly to long term cost saving from reduced number of errors. Second is vital to the success of the system. Testing is its utility “4 user oriented vehicle before implementation. Finally, testing aulls iN “8s to software reliability. Identified and removing fauits, during Bd4 TIME TABLE MANAGEMENT SYSTEM g can make the software More reliable. yeslil confidence in the system This increases yser’s sne basic levels of the testing are: unit Testing integration testing 40 2) 3) system testing 4) Aeceptance testing 59TIME TABLE MANAGEMENT SYSTEM | yn TESTING: | Ye v the first level of testing is unit testing. In this different modules are testing against the specification produced during for the modules. Unit testing is essential or verification of the code produced during the coding phase and hence the goal is the internal logic of the modules. INTEGRATION TESTING: The next level of testing is often called integration testing. In this many tested modules are combined into sub system, which are then tested. The goal here is to see if the modules can be integrated properly, the emphasis be considered as testing the design, and hence the emphasis on testing module interaction. 60TIME TABLE MANAGEMENT SYSTEM. SYSTEM TESTING: The next level of testing is system testing. Here the entire software system is tested. The reference document for this process is requirement document, and the geal is to ; see if the software meets its requirements. This is essentially a validation exercise. ACCEPTANCE TESTING: The last level of testing is acceptance testing. Acceptance testing is performed with realistic data of the client to demonstrate that the software is working satisfactorily. Testing here focuses on the external behavior of the system. The internal logic of the program is not emphasized. These different levels of testing attempt to detect different 'ypes of faults. The relation of the faults introduction in different phase, and the different levels of testing are shown: 61TIME TABLE MANAGEMENT sys TEM. client needs | ————> Acceptance testing | Requirement —— _ System testing Design ——- Integration testing Code —— Unit testingv TIME TABLE MANAGEMENT SYSTEM puTURE SCOPE OF THE PROJECT po Timetable Management System provides high flexible "features for managing and controlling the schedules of study for students in universities _ Timetable Management System is flexible to accept changes that can occur in schedules for all colleges of the university that recorded during the academic year without an overlap in the specified times between these colleges The main reports of Timetable Management System is extraction tables and schedules for students at the beginning of each academic year, also lectures, laboratories and teachers tables per semester. 63MIME TABLE MANAGEME NT SYSTEM siBLIOGRAPHY a we have referred to the following books for the presentation of the project:- ¢ [Link] ¢ Informatics practices by Sumita Arora. ¢ MS-Access by BPB Publication ¢ Visual [Link] by black 64