Thursday, October 25, 2012

SD AIM
http://www.scribd.com/doc/111131678


SD LAB

http://www.scribd.com/doc/111131868


EX.NO:1             ON-LINE TICKET RESERVATION
DATE:

AIM:
            To develop a software for reservation of train tickets through online.

PROBLEM ANALYSING AND PROJECT PLANNING:
  
  • The project is aiming to develop a reservation process through online which gives the user to make their confirmation of tickets.
  • The details of the customer is to be submitted to the process where the Name, age, gender, martial status, DOB, quota are to be checked. By submitting their email id the reservation of the tickets are informed through mailing process.
  • Reservation form is displayed where the user can enter the source and destination of their journey before the scheduled date. Here in this form the user can confirm their journey. By giving the next option we can go for the selection of classes. By selecting the class the user can fix their reserved classes.
  • Finally the availability of seats can be checked through the online, the reservation also can be checked for the confirmation of the date of journey.

SOFTWARE REQUIREMENT ANALYSIS:

1. FUNCTIONAL REQUIREMENT:

  • Online reservation has many modules. The user can first make their personal details to be entered and then they can make their next process.
  • Then by clicking the next button the user can make their reservation process.
  • After completing the entering of reservation details about their source and destination they move on to the next process of making the selection of classes.
  • In selection of classes the user can make only one class as their traveling class and then they can move on to the process entering the number passengers they have to make reservation.
  • Here then the user can enter the number of passengers they need to reserve. After this process the availability of the seats in each class can be checked.
  • The user has the option that they can even check the seat and class availability just by entering their PNR number.


2. SOFTWARE REQUIREMENT:

·         FRONT END:VISUAL BASIC
·         BACK END:MS ACCESS


FORMS:






























CODING:

Form 1:

Private Sub Command1_Click()
If Text1.Text = "arvind" And Text2.Text = "arav" Then
of2.Show
Else
MsgBox ("Enter Correct Details")
End If
End Sub

Private Sub Command2_Click()
of1.Show
End Sub

Form 2:

Private Sub Command1_Click()
of3.Show
End Sub

Private Sub Command2_Click()
of3.Show
End Sub

Private Sub Command3_Click()
of5.Show
End Sub

Private Sub Command4_Click()
End
End Sub

Form 3:
Private Sub Command1_Click()
of4.Show
End Sub

Private Sub Command2_Click()
Data1.Recordset.AddNew
of4.Show
End Sub
Private Sub Command3_Click()
of2.Show
End Sub
Form4:

Private Sub Command1_Click()
of2.Show
End Sub

Private Sub Command2_Click()
MsgBox ("Ticket is reserved")
End Sub

Form5:

Private Sub Command1_Click()
of2.Show
End Sub

Private Sub Command2_Click()
MsgBox ("Ticket is cancelled")
End Sub



























USE CASE DIAGRAM










                                                     



















                                                                













CLASS DIAGRAM












































SEQUENCE DIAGRAM







COLLABORATION DIAGRAM



  












































RESULT:
                      Thus the project Online Reservation has been successfully developed.

EX.NO:2             LIBRARY MANAGEMENT SYSTEMS
DATE:

AIM:
To develop Software for the purpose of library Management details effectively by maintaining their records.

PROBLEM ANALYSIS AND PROJECT PLANNING:

·         The Library Management System is designed & developed for a receipt and issuance of books in the library along with the student’s details. The books received in the library are entered in Books Entry form and the new student is entered in the student entry form.
  • When the student wants to get the desired book the same is issued on the availability basis to the student. The issuance and due date for the returning of the book is also entered into the Book Issue form under third menu Book Issue.
  • The student has to pay the fine if any on the basis of no. of days delayed deposit of the book in the library.

SOFTWARE REQUIREMENTS ANALYSIS:

1. FUNCTIONAL REQUIREMENTS:  
  • When the programmer needs a specific user interface feature such as a button, he selects the appropriate ready to use component provided by the Visual programming environment.
  • These components can be moved, resized and renamed as required. So a Visual programming environment automates the process of creating the user interface by designing Visual interface using the ready to use components.
  • In addition, it also provides the means of associating the user written logically defined code with the components used in a project.
  2. SOFTWARE REQUIREMENTS:
·         FRONT END : VISUAL BASIC
·         BACK END : MS ACCESS






















































RESULT:
Thus the project Library Management has been successfully developed.
EX.NO:3             E-BOOK MANAGEMENT SYSTEM
DATE:

AIM:
To develop Software for the purpose of E-Book Management system by maintaining the records.

PROBLEM ANALYSIS AND PROJECT PLANNING

·         The main objective of the document is to illustrate the Requirements of project E-Book Management system. The document gives the detailed description of both functional and non-functional requirements. It will also explain about the features of the system interface of the system. What the system will do, the constraint under which it must operate and how the system will react to external stimuli. The document is developed after a number of consultations with team members and specification of the given project.

·         This software is totally self contained and works relatively an efficient on the package relates to the software. It provides simple database rather than complex one for high requirement and it provides a good and easy graphical user interface to both new and naïve as well as experienced user of the computer.
SOFTWARE REQUIREMENTS ANALYSIS:
1. FUNCTIONAL REQUIREMENTS:
  •  Register - Enter details in application form.
  •  Login - Enter Username and Password.
  •  Search - Search book by attribute.
  •  Buy - Download softcopies and order for hard copy.
  •  Payment - Pay for books in different method.
  •  Update - Update User details
2. SOFTWARE REQUIREMENTS:

·         FRONT END TOOL - Rational Rose Enterprise suite.

·        BACK END TOOL – MS-Access























































RESULT:
Thus the project for E-book Management has been successfully executed.
EX.NO:4                                 PAYROLL SYSTEM
DATE:

AIM:
To develop Software for the purpose of analyzing employee details effectively by maintaining their records.

PROBLEM ANALYSIS AND PROJECT PLANNING:
   
·         This project aiming at developing a payroll system and also analyze the name ,id , job , salary of the employee. In this system, employee names are arranged in the list. This system will help the user to analyze the salary that is indicated for each and every employee in the database.

·         Payroll system is also used to display a list of the entire employee’s. A new employee can be added in this system and their details are entered. The employee database will contain the information about the employee’s name, id, job, salary. The entire employee details were displayed in the separate form.

·         In this system, the administrator can update the employee records. The user can save and delete the records by entering their correct username and password. The output is displayed in the separate form.

SOFTWARE REQUIREMENTS ANALYSIS:

1. FUNCTIONAL REQUIREMENTS:
          
·         Payroll system consists of several modules. The user can enter their username and password in the first module. This system will check whether the username and password given by the user are correct and direct them to the linked module.
·         The user can view the entire employee details in the separate module. In another module the user can add or delete or modify the employee records. A new employee can also be added in the database and their details are entered.
            
·         In payroll system, details about employee name and employee id can be displayed in the module. The job and salary detail about the particular employee is also viewed in the module.

2. SOFTWARE REQUIREMENTS:

·         FRONT END : VISUAL BASIC

·         BACK END : MS ACCESS






































 FORMS:

























































CODINGS:

Form1:
Private Sub Command1_Click()
Form2.Show
End Sub
Form2:
Private Sub Command1_Click()
Form6.Show
End Sub
Private Sub Command2_Click()
Form4.Show
End Sub
Private Sub Command3_Click()
Form5.Show
End Sub
Form3:
Private Sub Command1_Click()
MsgBox ("view by clicking next")
End Sub

Private Sub Command2_Click()
Form4.Show
End Sub
Form4:
Private Sub Command1_Click()
MsgBox ("your account is created")
End Sub

Private Sub Command2_Click()
Form5.Show
End Sub
Form5:
Private Sub Command1_Click()
MsgBox ("welcome you again")
End Sub
Private Sub Command2_Click()
Form2.Show
End Sub
Private Sub Command4_Click()
End
End Sub
Form6:
Private Sub Command1_Click()
Form3.Show
End Sub
USECASE DIAGRAM:














CLASS DIAGRAM:

























SEQUENCE DIAGRAM:




COLLABORATION DIAGRAM:



























FORMS:

































































USECASE DIAGRAM:













CLASS DIAGRAM:


















SEQUENCE DIAGRAM











COLLABORATION DIAGRAM



















CODING:

Form 1
Private Sub Command1_Click()
Form1.Show
End Sub

Form 2
Private Sub Command1_Click ()
If Text1.Text = "admin" And Text2.Text = "admin" Then
Form2.Show
End If
End Sub

Form 3
Private Sub Command1_Click()
Form3.Show
End Sub

Private Sub Command2_Click()
Form4.Show
End Sub

Form 4
Private Sub Command1_Click()
Form7.Show
End Sub

Private Sub Command2_Click()
Form2.Show
End Sub

Form 5
Private Sub Command1_Click()
Data1.Recordset.AddNew
End Sub

Private Sub Command2_Click()
Data1.Recordset.Update
End Sub

Private Sub Command3_Click()
Data1.Recordset.Delete
End Sub


Private Sub Command4_Click()
Data1.Recordset.MoveNext
End Sub

Private Sub Command5_Click()
Data1.Recordset.MovePrevious
End Sub

Private Sub Command6_Click()
Form5.Show
End Sub

Private Sub Command7_Click()
Form2.Show
End Sub

Form 6
Private Sub Command1_Click()
Form7.Show
End Sub

Form 7
Private Sub Command1_Click()
Data1.Recordset.AddNew
End Sub


Private Sub Command2_Click()
Data1.Recordset.Update
End Sub

Private Sub Command3_Click()
Data1.Recordset.Delete
End Sub

Private Sub Command4_Click()
Data1.Recordset.MoveNext
End Sub

Private Sub Command5_Click()
Data1.Recordset.MovePrevious
End Sub

Private Sub Command6_Click()
Form7.Show
End Sub
Form 8
Private Sub Command1_Click()
Form6.Show
End Sub

Private Sub Command2_Click()
Form8.Show
End Sub

Private Sub Command3_Click()
Form9.Show
End Sub

Form 9
Private Sub Command1_Click()
Data1.Recordset.AddNew
End Sub

Private Sub Command2_Click()
Data1.Recordset.Update
End Sub

Private Sub Command3_Click()
Data1.Recordset.Delete
End Sub

Private Sub Command4_Click()
Data1.Recordset.MoveNext
End Sub

Private Sub Command5_Click()
Form7.Show
End Sub

Form 10
Private Sub Command1_Click()
Data1.Recordset.AddNew
End Sub

Private Sub Command2_Click()
Data1.Recordset.Update
End Sub

Private Sub Command3_Click()
Data1.Recordset.Delete
End Sub

Private Sub Command4_Click()
Data1.Recordset.MoveNext
End Sub
Private Sub Command5_Click()
Form7.Show
End Sub
Private Sub Command6_Click()
End
End Sub
Private Sub Form_Load()
Combo1.AddItem "1"
Combo1.AddItem "2"
Combo1.AddItem "3"
Combo1.AddItem "4"
Combo1.AddItem "5"
Combo1.AddItem "6"
Combo1.AddItem "7"
Combo1.AddItem "8"
Combo2.AddItem "jan"
Combo2.AddItem "feb"
Combo2.AddItem "mar"
Combo2.AddItem "apr"
Combo2.AddItem "may"
Combo2.AddItem "jun"
Combo2.AddItem "jul"
Combo2.AddItem "aug"
Combo3.AddItem "2011"
Combo4.AddItem "1"
Combo4.AddItem "2"
Combo4.AddItem "3"
Combo4.AddItem "4"
Combo4.AddItem "5"
Combo4.AddItem "6"
Combo4.AddItem "7"
Combo4.AddItem "8"
Combo5.AddItem "jan"
Combo5.AddItem "feb"
Combo5.AddItem "mar"
Combo5.AddItem "apr"
Combo5.AddItem "may"
Combo5.AddItem "jun"
Combo5.AddItem "jul"
Combo5.AddItem "aug"
Combo6.AddItem "2011"
End Sub
FORMS:


































CODING:

Form 1:
Private Sub Command1_Click()
If Text1.Text = Text2.Text Then
Form2.Show
Else
MsgBox ("PLEASE ENTER THE CORRECT DETAILS")
End If
End Sub

Private Sub Command2_Click()
End
End Sub

Form  2:
Private Sub Command1_Click()
Form3.Show
End Sub

Private Sub Command2_Click()
Form4.Show
End Sub

Form 3:
Private Sub Command1_Click()
Data1.Recordset.AddNew
End Sub

Private Sub Command10_Click()
End
End Sub

Private Sub Command2_Click()
Data1.Recordset.Delete
End Sub

Private Sub Command3_Click()
Data1.Recordset.Update
End Sub

Private Sub Command4_Click()
Data1.Recordset.MoveFirst
End Sub


Private Sub Command5_Click()
Data1.Recordset.MoveNext
End Sub

Private Sub Command6_Click()
Data1.Recordset.MovePrevious
End Sub

Private Sub Command7_Click()
Data1.Recordset.MoveLast
End Sub

Private Sub Command8_Click()
Form4.Show
End Sub

Private Sub Command9_Click()
Form2.Show
End Sub

Form 4:
Private Sub Command1_Click()
Text6.Text = Val(Text3.Text) + Val(Text4.Text) + Val(Text5.Text)
End Sub

Private Sub Command2_Click()
Form5.Show
End Sub
Private Sub Command3_Click()
Form3.Show
End Sub
Private Sub Command4_Click()
End
End Sub
Form  5:
Private Sub Command1_Click()
End
End Sub
Form 6:
Private Sub Command1_Click()
Form3.Show
End Sub
Private Sub Command2_Click()
Form4.Show
End Sub

USE CASE DIAGRAM


















CLASS DIAGRAM
























 SEQUENCE DIAGRAM






















COLLABORATION DIAGRAM




























RESULT:                                                                                               
                Thus the project for Payroll has been successfully developed.