87683689 ooad lab record

1

Ex. No.1 ONLINE COURSE RESERVATION

Date:

AIM

To analyze, design and develop code for Online Course Reservation System using Rational

Rose software

PROBLEM STATEMENT

As the head of information systems for a college, you are tasked with developing a new

student registration system. The college would like a new client-server system to replace its much

older system developed around main frame technology. The new system will allow students to

register for courses and view report cards from PCs attached to the campus LAN. Professors will be

able to access the system to sign up to teach courses as well as record grades.

Students may request a course catalogue containing list of course offering for all college.

Information about each course, such as professor, department and prerequisites, will be included to

help students make informed decisions.

Once the registration process is completed for the student, the registration system sends

information to the billing system so that the student can be billed for the course.

OVERALL DESCRIPTION

The Online Course Reservation System is an integrated system that has four modules as part

of it. The four modules are,

1) Login for Student: Using this module student login to the system using his/her unique

username and password

2) Student Registration: In this module, the students register his/her details in the system. The

details are stored in students table in database

3) Form for Registration: In this module the user can apply for the course by giving the details

about the candidate and selecting the quota for the registration.

4) Enquiry about course: In this module the student can enquiry about the various courses in

all the colleges.

SOFTWARE REQUIRMENTS

Microsoft Visual Basic 6.0

Rational Rose

Microsoft Access

HARDWARE REQUIRMENTS

128MB RAM

Pentium III Processor

2

USE CASE DIAGRAM

CLASS DIAGRAM

3

ACTIVITY DIAGRAM

4

SEQUENCE DIAGRAM

5

COLLABRATION DIAGRAM

COMPONENT DIAGRAM

DEPLOYMENT DIAGRAM

Student System

Server Database

1: Login3: Getdetail

6: Look for course8: Select

10: Register

15: Print

2: validate4: Query9: Update11: Check

7: Resut12: Validate

14: Validation

5: Retrive13: Update

Student

Register

Administ

rator

View

Databas

eCatalog

Access

Database

Course

Reserv...

StudentAdminis

trator

6

IMPLEMENTATION

Form1

Private Sub Command1_Click()

Dim cn As New ADODB.Connection

Dim rs As New ADODB.Recordset

Dim a As Boolean

a = False

cn.Open "dsn=course"

rs.ActiveConnection = cn

With rs

.CursorType = adOpenStatic

.CursorLocation = adUseClient

.LockType = adLockOptimistic

.Open "select * from Students"

End With

rs.MoveFirst

While Not rs.EOF

If (Text1.Text = rs(1) And Text2.Text = rs(2)) Then

a = True

Form3.Show

Form1.Hide

End If

rs.MoveNext

Wend

If (a = False) Then

MsgBox ("Enter Correct UserName and Password")

End If

End Sub


Form2.Show

Unload Me

End Sub

7

Form2




cn.Open "dsn=Course"


If (Text3.Text = Text4.Text) Then

With rs





End With

With rs

.AddNew

.Fields(0) = Val(Text1.Text)

.Fields(1) = Text2.Text


If (Option1 = True) Then

.Fields(3) = Option1.Caption

End If



End If


8





.Update

MsgBox ("Registration Success. Please Login")

Form1.Show

Unload Me

End With

Else

MsgBox ("Password doesn't match")

End If

End Sub


Unload Me

End Sub

Public Sub calCutoff()

Text9.Text = Val(Text6.Text) / 4 + Val(Text7.Text) / 4 + Val(Text8.Text) / 2

End Sub

Private Sub Text6_Change()

calCutoff

End Sub


calCutoff

End Sub


calCutoff

End Sub

Form3


Form4.Show

Unload Me

End Sub

9


Form5.Show

Unload Me

End Sub

Form4


Form3.Show

Unload Me

End Sub




cn.Open "dsn=course"


With rs




.Open "select * from Colleges"

End With

rs.MoveFirst

While Not rs.EOF

If (Val(Text1.Text) = rs(0)) Then

Text2.Text = rs(1)

Text3.Text = rs(2)

Text4.Text = rs(3)

Text5.Text = rs(4)

10

Text6.Text = rs(5)

End If

rs.MoveNext

Wend

End Sub

Form5




cn.Open "dsn=Course"


With rs




.Open "select * from Reservations"

End With

With rs

.AddNew

.Fields(0) = Form1.Text1.Text



.Update

MsgBox ("Resrvation Success")

End With

End Sub


Unload Me

End Sub

11

CONCLUSION:

This project was carried out in a sequential manner to design and implement the “Online

Course Reservation System”. Thus the outcome of the project is efficient. The Online Course

Reservation System caters the varied requirements of the user to perform various options.

12

Ex. No. 2 E- TICKETING

Date:

AIM

To analyze, design and develop code E-Ticketing using Rational Rose software.

Problem Statement

Our project is carried out to develop software for online Railway Reservation System. The

software is coded in VB, which is the front end, and it has Back end, which contains information

about the reservation and the availability of seats in trains. It has various options like reservation,

cancellation and to view details about available seats. Our project mainly simulates the role of a

Railway ticket booking officer, in a computerized way.

The reservation option enables a person to reserve for a ticket at their home itself. All he/ she

has to do is to just login and enter the required details. After this the reservation database is updated

with the person details, train name and also the source and destination place.

The cancellation option enables the passenger to cancel the tickets that has been already

booked by him/her.

The availability option prompts the person to enter train number, train name and date of

travel. After this the availability database is accessed and available positions are produced.

OVERALL DESCRIPTION:

The E-Ticketing System is an integrated system that has four modules as part of it. The four modules

are,

1) Viewing Train Details: To view the train details. Details can be viewed by giving the train

number or Source and Destination

2) Checking Availability of Tickets: To view number of tickets available in the train

3) Reservation of Tickets: To enable the users to reserve the tickets easily

4) Cancellation of Tickets: To enable the users to cancel the tickets by giving PNR No

USE CASE DIAGRAM :-

13

CLASS DIAGRAM :-

14

ACTIVITY DIAGRAM :-

15

INTERACTION DIAGRAM :-

16


COMPONENT DIAGRAM

Passenger

1: pass

Client End

system:system

Server database:Train

database

1: Login to website

2: Check login details

3: Acknowledged the login

4: Look for train details

5: provide corresponding train details

6: check for availability for seats

7: Display available seats

8: choose a specific seats

9: Display the price scheme

10: pay via credit/debit

11: Acknowledged pay

12: cancellation process

13: Ask confirmation of cancellation

14: confirm cancellation

15: updata database

16: Logout

Passeng

er

Reservati

on

Administ

rator

Cancellat

ion

Databas

e

17

DEPLOYMENT DIAGRAM

IMPLEMENTATION

Form1


Form2.Show

Unload Me

End Sub


Form3.Show

Unload Me

End Sub


Form4.Show

Access

Database

E-

Ticketi...

Passen

ger

Adminis

trator

18

Unload Me

End Sub


Unload Me

End Sub

Form2




cn.Open "dsn=Ticket"


With rs





End With

With rs

.AddNew





.Update

MsgBox ("Reservation Success.")

Text1.Text = ""

Text2.Text = ""

Text3.Text = ""

Text4.Text = ""

End With

19

End Sub


Form1.Show

Unload Me

End Sub

Form3




cn.Open "dsn=Ticket"


With rs





End With

rs.MoveFirst

While (Not rs.EOF)

If (rs(0) = Val(Text1.Text)) Then

rs.Delete

rs.Update

End If

Wend

End Sub


Form1.Show

Unload Me

End Sub

Form4




Dim a As Boolean

a = False

cn.Open "dsn=ticket"


With rs




.Open "select * from Trains"

End With

20

rs.MoveFirst

While Not rs.EOF


Text3.Text = Text3.Text + Str$(rs(0)) + ", "

Text3.Text = Text3.Text + rs(1) + ". "

a = True

End If

rs.MoveNext

Wend

If (a = False) Then

MsgBox ("Enter correct Details")

End If

End Sub


Form1.Show

Unload Me

End Sub

CONCLUSION:

This project was carried out in a sequential manner to design and implement the “E-

Ticketing System”. Thus the outcome of the project is efficient. The E-Ticketing System caters the

varied requirements of the user to perform various options.

21

Ex No: 3 CREDIT CARD PROCESSING

Date:

AIM

To analyze, design and develop code for Credit Card Processing System using Rational Rose

software

PROBLEM STATEMENT

We envision a banking system that provides the customer holing a bank credit card can make

deposits, withdraws, check balances and perform transfer to and from their accounts. Credit card

processing will be attractive to banking customer because they allow access to their accounts outside

of regular business hours.

Participating Banks want to make sure the access to their customer account information is

safe and secure transaction information is accurate and reliable. Bank Customer-Want easy, low-cost,

remote access to their accounts, but want to be assured that their accounts are secure and not

accessible to hackers or other their parties.

Bank must be able to handle multiple simultaneous transactions (and possible

simultaneous transaction to the same joint account).Bank owning a credit card must be able to

determine the cash on hand in the creditcard. The cash in the creditcard must be secure.

OVERALL DESCRIPTION

The Credit Card Processing System is an integrated system that has four modules as part of

it. The four modules are,

1) User Login: Using this module user login to the system using his/her unique username and

password

2) Withdraw: The purpose of this module to withdraw money from the account

3) Deposit: The purpose of this module to deposit money to the account

4) Balance Enquiry: Using this module the user can check his/her account balance and the loan

amount to pay if any.



Rational Rose

Microsoft Access


128MB RAM


22

USE CASE DIAGRAM

CLASS DIAGRAM

Customer

Deposit

Login

Bank Database

Withdraw

Transaction

Balance Enquiry

23

ACTIVITY DIAGRAM

Login

Withdraw Deposit Balnce Enquiry

Logout

24

SEQUENCE DIAGRAM

Customer Credit System Bank Database

Login

Validate Details

Validation Success

Login Success

Transaction

Validate Transaction

Transaction Validated

Transaction Success

Pin Change

Update Details

Details Updated

Pin Change Success

25


COMPONENT DIAGRAM

DEPLOYMENT DIAGRAM

Customer Credit

System

Bank

Database

1: Login

2: Validate Details

3: Validation Success

4: Login Success

5: Transaction

6: Validate Transaction

7: Transaction Validated

8: Transaction Success

9: Pin Change

10: Update Details

11: Details Updated

12: Pin Change Success

Customer

Bank

Credit

Card

Databas

e

Access

Database

Credit Card

Processi...Customer

26

IMPLEMENTATION

Form1


Form2.Show

Unload Me

End Sub


Form3.Show

Unload Me

End Sub


Unload Me

End Sub

Form2




Dim a As Boolean

a = False

cn.Open "dsn=credit"


With rs




.Open "select * from Admin"

27

End With

rs.MoveFirst

While Not rs.EOF


a = True

Form7.Show

Unload Me

End If

rs.MoveNext

Wend

If (a = False) Then


End If

End Sub

Form3




Dim a As Boolean

a = False



With rs




.Open "select * from Customers"

End With

rs.MoveFirst

While Not rs.EOF


a = True

Form4.Show

Form3.Hide

End If

rs.MoveNext

Wend

28

If (a = False) Then


End If

End Sub

Form4


Form5.Show

Unload Me

End Sub


Form6.Show

Unload Me

End Sub

Private Sub Form_Load()

Form4.Text1 = Form3.Text1.Text

End Sub

Form5






29

With rs





End With

rs.MoveFirst

While Not rs.EOF

If (rs(1) = Form3.Text1.Text) Then


rs(3) = rs(3) + Val(Text1.Text)

MsgBox ("Transaction Complete")

End If


If ((rs(3) + 50000) > Val(Text1.Text)) Then

rs(3) = rs(3) - Val(Text1.Text)

MsgBox ("Transaction Complete")

Else

MsgBox ("Credit Amount Exceeds")

End If

End If

End If

rs.MoveNext

Wend

Text1.Text = ""

End Sub


Form4.Show

Unload Me

End Sub

Form6


Form4.Show

Unload Me

End Sub




30



With rs





End With

rs.MoveFirst

While Not rs.EOF

If (rs(1) = Form3.Text1.Text) Then

Text1.Text = rs(3)

End If

rs.MoveNext

Wend

End Sub

Form7


Form8.Show

Unload Me

End Sub


Unload Me

End Sub

Form8




Dim a As Boolean

a = False

cn.Open "dsn=Credit"


With rs





31

End With

rs.MoveFirst

While Not rs.EOF


Text2.Text = rs(1)

Text3.Text = rs(3)

Text4.Text = rs(4)

a = True

End If

rs.MoveNext

Wend

If (a = False) Then

MsgBox ("Enter correct ID")

End If

End Sub


Form7.Show

Unload Me

End Sub

CONCLUSION:

This project was carried out in a sequential manner to design and implement the “Credit

Card Processing System”. Thus the outcome of the project is efficient. The Credit Card Processing

System caters the varied requirements of the user to perform various options.

32

Ex No:4 SOFTWARE PERSONNEL MANAGEMENT SYSTEM

Date:

AIM

To analyze, design and develop code for Software Personnel Management System using

Rational Rose software

PROBLEM STATEMENT

To create Software Personnel Management System and processes the intersection between

human resource management (HRM) and information technology. The system should merges HRM

as a discipline and in particular its basic HR activities and processes with the information technology

field.

OVERALL DESCRIPTION

The Software Personnel Management System is an integrated system that has four modules as

part of it. The four modules are,

1) Login: To implement security and only the HR is allowed to access the system using is

username and password

2) Adding an Entry: This module is used to insert a new personnel details

3) Search an Entry: This module is used to search the database with reference to Id or

Designation

4) View an Entry: This module is used to get the detailed information about an personnel



Rational Rose

Microsoft Access


128MB RAM


USECASE DIAGRAM

Login

Add New Entry

HR

Search an Entry

View an Entry

Database

33

CLASS DIAGRAM

ACTIVITY DIAGRAM

Login

Add New Entry View Entry Search Entry

By Id By Designation

Logout

34

SEQUENCE DIAGRAM

HR SPM System SPM Database

Login

Validate Details

Validation SuccessLogin Success

Add New Entry

Add Details

Details Added

Entry Added

Edit Entry

Update Details

Details UpdatedEntry Edited

Search Entry

Retrive Data

Return Data

Return Details

35


COMPONENT DIAGRAM

DEPLOYMENT DIAGRAM

HR SPM

System

SPM

Database

1: Login5: Add New Entry

9: Edit Entry

4: Login Success8: Entry Added

12: Entry Edited

2: Validate Details6: Add Details

10: Update Details

3: Validation Success7: Details Added

11: Details Updated

13: Search Entry

14: Retrive Data

15: Return Data

16: Return Details

HR Personnel Designation

Access

Database

SPM

SystemHR

36

IMPLEMENTATION

Form1


Dim a As Boolean

a = False

If (Text1.Text = "admin" And Text2.Text = "admin") Then

a = True

Form2.Show

Unload Me

End If

If (a = False) Then

MsgBox ("Enter Correct Username and Password")

End If

End Sub

Form2


Form3.Show

Unload Me

End Sub


Form4.Show

Unload Me

End Sub

37


Form5.Show

Unload Me

End Sub


Unload Me

End Sub

Form3




cn.Open "dsn=Software"


With rs




.Open "select * from Details"

End With

38

With rs

.AddNew





End If



End If





.Update

End With

Text1.Text = ""

Text2.Text = ""

Text3.Text = ""

Text4.Text = ""

Text5.Text = ""

Text6.Text = ""

Option1 = False

Option2 = False

End Sub

Form4




Dim a As Boolean

a = False

cn.Open "dsn=software"


39

With rs





End With

rs.MoveFirst

While Not rs.EOF


Text3.Text = Text3.Text + rs(1) + ", "






a = True

End If

rs.MoveNext

Wend

If (a = False) Then

MsgBox ("Enter correct Employee ID")

End If

Text1.Text = ""

End Sub




Dim a As Boolean

a = False



With rs





End With

rs.MoveFirst

While Not rs.EOF

If (Text2.Text = rs(4)) Then







a = True

End If

40

rs.MoveNext

Wend

If (a = False) Then

MsgBox ("Enter correct Designation")

End If

Text2.Text = ""

End Sub


Form2.Show

Unload Me

End Sub

Form5




Dim a As Boolean

a = False



With rs





End With

41

rs.MoveFirst

While Not rs.EOF


Text2.Text = rs(1)

Text3.Text = rs(2)

Text4.Text = rs(3)

Text5.Text = rs(4)

Text6.Text = rs(5)

Text7.Text = rs(6)

a = True

End If

rs.MoveNext

Wend

If (a = False) Then


End If

End Sub

CONCLUSION:

This project was carried out in a sequential manner to design and implement the “Software

Personnel Management System”. Thus the outcome of the project is efficient. The Software Personnel

Management System caters the varied requirements of the user to perform various options.

42

Ex.No: 5 BOOK BANK SYSTEM

Date :

AIM:

To analyze, design and develop code for Book Bank system using Rational Rose software.

PROBLEM STATEMENT

To create an Book Bank Maintenance System software that will meet the needs of the

customer and help them in registering for the book bank ,enquiry about the issue of book, return book

and available books.

OVERALL DESCRIPTION

The Book Bank Maintenance System is an integrated system that has four modules as part of

it. The four modules are,

1) Registration for the new user: In this module, the user can register as new user in the

database.

2) Issue Book: In this module, it shows the details of issued book to the existing user and it

shows the available book to the particular user.

3) Return Book: In this module, shows and modify the database and store the return book from

the user and shows the fine amount.



Rational Rose

Microsoft Access


128MB RAM


43

USECASE DIAGRAM

CLASS DIAGRAM

ENTER INTO SYSTEM

USERNEWUSER

EXISTING USER

ISSUE

RETURN

STORE

DATA BASE ADMIN

44

ACTIVITY DIAGRAM

Login

New user Registration

Existing user

Return Book

Fine

End

Issue book

Available Books

Book search

start

YesNo

45

SEQUENCE DIAGRAM

useruser systemsystem data basedata base

1: new user

2: save

3: existing user

4: retrieve

5: display information

6: issue

7: update

8: close

9: save

10: return

11: update

12: close

13: save

46

COLLABORATION DIAGRAM

COMPONENT DIAGRAM

DEPLOYMENT DIAGRAM

user system

data base

1: new user

3: existing user

6: issue

8: close

10: return

12: close

2: save

4: retrieve

7: update

9: save

11: update

13: save

5: display information

DatabaseBookSearchUser

Access

Database

Book

BankUser

47

IMPLEMENTATION

Form1


Dim a As Boolean

a = False


a = True

Form2.Show

Unload Me

End If

If (a = False) Then


End If

End Sub

Form2


Form3.Show

Unload Me

End Sub


Form4.Show

Unload Me

End Sub

48


Form5.Show

Unload Me

End Sub


Form6.Show

Unload Me

End Sub


Unload Me

End Sub

Form3




cn.Open "dsn=BookBank"


With rs





End With

With rs

.AddNew



.Update

End With

Text1.Text = ""

End Sub


Form2.Show

Unload Me

End Sub

49

Form4






With rs




.Open "select * from Books"

End With

With rs

.AddNew




.Update

End With

Text1.Text = ""

Text2.Text = ""

Text3.Text = ""

End Sub


Form2.Show

Unload Me

End Sub

50

Form5



Dim rs1 As New ADODB.Recordset


Dim a As Boolean

Dim b As Boolean

a = False

b = False


rs1.ActiveConnection = cn


With rs1





End With

With rs2





End With

rs1.MoveFirst

While Not rs1.EOF

If (Val(Text1.Text) = rs1(0)) Then

a = True

rs2.MoveFirst

While Not rs2.EOF


b = True

If (rs2(2) > 0) Then

rs2(2) = rs2(2) - 1

rs2.Update

MsgBox "Book is Issued"

Else

MsgBox "No copies of books is avilable"

51

End If

End If

rs2.MoveNext

Wend

End If

rs1.MoveNext

Wend

Text1.Text = ""

Text2.Text = ""

If (a = False) Then

MsgBox ("Enter correct Student ID")

End If

If (a = True And b = False) Then

MsgBox ("Enter correct Book ID")

End If

End Sub





Dim a As Boolean

Dim b As Boolean

a = False

b = False




With rs1





End With

With rs2





End With

rs1.MoveFirst

While Not rs1.EOF


a = True

rs2.MoveFirst

While Not rs2.EOF


52

b = True

If (rs2(2) > 10) Then

MsgBox "Book is Renewed"

Else

MsgBox "Please return the Book."

End If

End If

rs2.MoveNext

Wend

End If

rs1.MoveNext

Wend

Text1.Text = ""

Text2.Text = ""

If (a = False) Then


End If



End If

End Sub


Form2.Show

Unload Me

End Sub

Form6





Dim a As Boolean

Dim b As Boolean

a = False

b = False

53




With rs1





End With

With rs2





End With

rs1.MoveFirst

While Not rs1.EOF


a = True

rs2.MoveFirst

While Not rs2.EOF


b = True

rs2(2) = rs2(2) + 1

MsgBox ("Book is Returned")

End If

rs2.MoveNext

Wend

End If

rs1.MoveNext

Text1.Text = ""

Text2.Text = ""

Wend

If (a = False) Then


End If



End If

End Sub


Form2.Show

Unload Me

End Sub

CONCLUSION:

This project was carried out in a sequential manner to design and implement the “Book Bank

System”. Thus the outcome of the project is efficient. The Book Bank System caters the varied

requirements of the user to perform various options.

54

Ex.No: 6 EXAM REGISTRATION SYSTEM

Date :

AIM:

To analyze, design and develop code for Exam Registration System using Rational Rose

software.

PROBLEM STATEMENT

To create an Exam registration software that will meet the needs of the applicant and help

them in registering for the exam ,enquiry about the registered subject ,modification in database and

cancellation for the registered project.

OVERALL DESCRIPTION

The Exam Registration System is an integrated system that has four modules as part of it. The

four modules are,

1) Registration for the exam: In this module, the user can select the subject to register for the

exam, Enquiry about the registered subject, Modification in the student database, canceling

the registered subject

2) Form for Registration: In this module the user can apply for the exam by giving the details

about the candidate and selecting the subject for the registration.

3) Modification in the Database: In this module the user can change the data’s like the phone

number, address can be done.

4) Cancellation for the registered subject: In this module the user can cancel their name which

is registered for the exam.



Rational Rose

Microsoft Access


128MB RAM


55

USECASE DIAGRAM:

CLASS DIAGRAM:

register for exam

(from use case)

enter datas

(from use case)

cancel the exam registration

(from use case)

maintain student info

(from use case)

student

(from actor)

modify databse

(from use case)

select the exam

(from use case)

databse

(from actor)

56

ACTIVITY DIAGRAM:

SEQUENCE DIAGRAM:

select the

subject

apply the exam

modify databse

cancel

regisrtation

enter into

system

student exam

registration

databse

enter the datas

select the subject

apply for the exam

generation of registration id

note id

modify databse

cancel the subject registration

57

COLLABRATION DIAGRAM:

COMPONENT DIAGRAM:

DEPLOYMENT DIAGRAM:

exam

registration

student

databse

1: enter the datas2: select the subject3: apply for the exam

4:

5: generation of registration id

6: note id

7: modify databse8: cancel the subject registration

exam

registrationstudent

Databse

58

IMPLEMENTATION

Form1




Dim a As Boolean

a = False

cn.Open "dsn=exam"


With rs





End With

rs.MoveFirst

While Not rs.EOF


a = True

Form3.Show

Form1.Hide

End If

rs.MoveNext

Wend

If (a = False) Then


End If

End Sub


Form2.Show

Unload Me

End Sub

59

Form2




cn.Open "dsn=Exam"



With rs





End With

With rs

.AddNew






End If



End If





.Update


Form1.Show

Unload Me

End With

60

Else


End If

End Sub


Unload Me

End Sub

Form3


Form4.Show

Unload Me

End Sub


Form5.Show

Unload Me

End Sub


Unload Me

End Sub

Form4


Form3.Show

Unload Me

End Sub




cn.Open "dsn=exam"


61

With rs




.Open "select * from Exams"

End With

rs.MoveFirst

While Not rs.EOF


Text2.Text = rs(1)

Text3.Text = rs(2)

Text4.Text = rs(3)

End If

rs.MoveNext

Wend

End Sub

Form5




62

cn.Open "dsn=Exam"


With rs




.Open "select * from Exams"

End With

rs.MoveFirst

While Not rs.EOF


rs(4) = rs(4) + ", " + Form1.Text1.Text

rs.Update

a = True

MsgBox "Exam Applied"

End If

rs.MoveNext

Wend

If (a = False) Then

MsgBox ("Enter correct Exam ID")

End If

End Sub


Unload Me

End Sub

CONCLUSION:

This project was carried out in a sequential manner to design and implement the “Exam

Registration System”. Thus the outcome of the project is efficient. The Exam Registration System

caters the varied requirements of the user to perform various options.

63

Ex.No:7 STOCK MAINTENANCE SYSTEM

Date :

AIM: To analyze, design and develop code for Stock maintenance system using Rational Rose

software.

PROBLEM DOMAIN:

Stock maintenance system is a real time application used in the merchant’s day to day

system. This is a database to store the transaction that takes places between the Manufacturer, Dealer

and the Shop Keeper that includes stock inward and stock outward with reference to the dealer. Here

we assume our self as the Dealer and proceed with the transaction as follows:

The Manufacturer is the producer of the items and it contains the necessary

information of the item such as price per item, Date of manufacture, best before use, Number of Item

available and their Company Address. The Dealer is the secondary source of an Item and he purchases

Item from the manufacturer by requesting the required Item with its corresponding Company Name

and the Number of Items required.

OVERALL DESCRIPTION:

1) Login Form: Authenticate the user and administrator.

2) Department Selection Form: This form will give the options for selecting the department to

get knowledge about the conference.

3) Conference view Form: This form contains the details about the conferences are conducting

by various institutions and we can see the date and time for the conference.

4) Database Form: The details about the conferences going to conduct by various institutions.

Administrator can add the details about the conference for the students and also for the staff

members.

SOFTWARE REQURIEMENTS:


Rational Rose

Microsoft Access.

HARDWARE REQURIMENTS:

128MB RAM


64

USECASE DIAGRAM:

SHOP KEEPER

Sales

Company name

Price/Item

Items ordered

Total price

DEALER

Purchase

Company name

Price/item

Items ordered

PRODUCER

Total price

65

CLASS DIAGRAM:

66

ACTIVITY DIAGRAM:

Inventory

System

Select from

the Menu

Purchase Sales Stock Exit

Company

Name

No of Items

ordered

Price/Item

Total Price If Availability > No of

Items Ordered

Displays price

of Items

Displays Insufficient

no of items

Display the

Transaction Details

67

SEQUENCE DIAGRAM:

PRODUCER DEALER SHOPKEEPER

1.PURCHASE

1.SALES

2.COMPANY NAME

2.COMPANY NAME

3.PRICE/ITEM

3.PRICE/ITEM

4.NO OF ITEMS ORDERED

4.NO OF ITEMS ORDERED

5.TOTAL PRICE

5.CHECKING WITH AVAILABILITY

6.ITEMS INSUFFICIENT/TOTAL PRICE

68

COLLABORATION DIAGRAM:

COMPONENT DIAGRAM:

DEPLOYMENT DIAGRAM:

PRODUC

ER

DEALER

SHOPKEE

PER

1: 1.PURCHASE3: 2.COMPANY NAME

7: 4.NO OF ITEMS ORDERED

5: 3.PRICE/ITEM9: 5.TOTAL PRICE

2: 1.SALES6: 3.PRICE/ITEM

11: 6.ITEMS INSUFFICIENT/TOTAL PRICE

4: 2.COMPANY NAME8: 4.NO OF ITEMS ORDERED

10: 5.CHECKING WITH AVAILABILITY

ManufacturerDealerShopKeeper

Access

Database

Stock

Maint...ShopKe

eper

69

IMPLEMENTATION:

Form1


Dim a As Boolean

a = False


a = True

Form2.Show

Unload Me

End If

If (a = False) Then


End If

End Sub

Form2


Form3.Show

Unload Me

End Sub


Form4.Show

Unload Me

End Sub

70


Form5.Show

Unload Me

End Sub


Unload Me

End Sub

Form3




cn.Open "dsn=Stock"


With rs




.Open "select * from Stock"

End With

With rs

.AddNew





.Update

End With

MsgBox ("New Record Added")

Text1.Text = ""

Text2.Text = ""

71

Text3.Text = ""

Text4.Text = ""

End Sub


Form2.Show

Unload Me

End Sub

Form4




Dim a As Boolean

a = False

cn.Open "dsn=Stock"


With rs





End With

rs.MoveFirst

While Not rs.EOF


Text2.Text = rs(1)

Text3.Text = rs(2)

Text4.Text = rs(3)

a = True

End If

72

rs.MoveNext

Wend

If (a = False) Then


End If

End Sub


Form2.Show

Unload Me

End Sub

Form5




cn.Open "dsn=Stock"


With rs





End With

rs.MoveFirst

While Not rs.EOF


With rs


73




.Update

End With

MsgBox ("Record Updated")

End If

rs.MoveNext

Wend

Text1.Text = ""

Text2.Text = ""

Text3.Text = ""

Text4.Text = ""

End Sub


Form2.Show

Unload Me

End Sub




Dim a As Boolean

a = False

cn.Open "dsn=Stock"


With rs





End With

rs.MoveFirst

While Not rs.EOF


Text2.Text = rs(1)

Text3.Text = rs(2)

Text4.Text = rs(3)

a = True

End If

rs.MoveNext

Wend

If (a = False) Then


End If

End Sub

74

CONCLUSION:

This project was carried out in a sequential manner to design and implement the “Stock

Maintenance System”. Thus the outcome of the project is efficient. The Stock Maintenance System

caters the varied requirements of the user to perform various options.

75

Ex.No:8 E-BOOK MANAGEMENT SYSTEM

Date :

AIM:

To analyze, design and develop code for E-Book Management system using Rational Rose

software.

PROBLEM STATEMENT

To create an E-Book Management system software that will meet the needs of the customer

and help them in registering for the book bank, enquiry about the issue of book, return book and

available books.

OVERALL DESCRIPTION

The E-Book Management System is an integrated system that has four modules as part of it.

The four modules are,

1) Add Book Details: In this module, the user can enter details about new book.

2) Edit Book Details: In this module, the user can edit details about any book.

3) View Book Details: In this module, the user can view details about books.

4) Search Book Details: In this module, the user can search details about books by Author and

Id



Rational Rose

Microsoft Access


128MB RAM


76

USECASE DIAGRAM

CLASS DIAGRAM

New Book Details

Edit Book Details

User

View Book Details

Search Book Details

Database

77

ACTIVITY DIAGRAM

Login

View Book

Details

Edit Book

Details

Search Book

Details

By Publication By Author

78

SEQUENCE DIAGRAM

User System Database

Add Book Details

Search Details

Insert Details

Successfully Inserted

Details Added

Retrive Details

Send Details

Send Details

Edit Details

Update Details

Udate Success

Edition Success

79

COLLABORATION DIAGRAM

COMPONENT DIAGRAM

DEPLOYMENT DIAGRAM

User System

1: Add Book Details5: Search Details

Database

2: Insert Details

3: Successfully Inserted

4: Details Added

6: Retrive Details

7: Send Details

8: Send Details

9: Edit Details

10: Update Details

11: Udate Success

12: Edition Success

User Book Database

Access

Database

E-Book

Manageme...User

80

IMPLEMENTATION

Form1


Dim a As Boolean

a = False


a = True

Form2.Show

Unload Me

End If

If (a = False) Then


End If

End Sub

Form2


Form3.Show

Unload Me

End Sub


81

Form4.Show

Unload Me

End Sub


Form5.Show

Unload Me

End Sub


Unload Me

End Sub

Form3




Dim a As Boolean

a = False

cn.Open "dsn=ebook"


With rs





End With

rs.MoveFirst

While Not rs.EOF


Text2.Text = rs(1)

Text3.Text = rs(2)

Text4.Text = rs(3)

82

a = True

End If

rs.MoveNext

Wend

If (a = False) Then


End If

End Sub


Form2.Show

Unload Me

End Sub

Form4




cn.Open "dsn=EBook"


With rs





End With

With rs

.AddNew



83



.Update

End With

Text1.Text = ""

Text2.Text = ""

Text3.Text = ""

Text4.Text = ""

End Sub


Form2.Show

Unload Me

End Sub

Form5




Dim a As Boolean

a = False

cn.Open "dsn=ebook"


With rs





End With

rs.MoveFirst

84

While Not rs.EOF





a = True

End If

rs.MoveNext

Wend

If (a = False) Then

MsgBox ("Enter correct Author Name")

End If

End Sub




Dim a As Boolean

a = False

cn.Open "dsn=ebook"


With rs





End With

rs.MoveFirst

While Not rs.EOF





a = True

End If

rs.MoveNext

Wend

If (a = False) Then

MsgBox ("Enter correct Publisher Name")

End If

End Sub


Form2.Show

Unload Me

End Sub

85

CONCLUSION:

This project was carried out in a sequential manner to design and implement the “E-Book

System”. Thus the outcome of the project is efficient. The E-Book System caters the varied


86

Ex.No: 9 RECRUITMENT SYSTEM

Date:

AIM

To analyze, design and develop code for Recruitment System using Rational Rose software

PROBLEM STATEMENT

Recruitment System is used to process the applicant easily. It also contains search filters to

filters the applicants based on age, gender, experience, skills etc.

It is mainly used by HR personnel in corporates to efficiently analyze the applications

OVERALL DESCRIPTION

The E-Book Management System is an integrated system that has four modules as part of it.

The four modules are,

1) Register: In this module, the user can register his/her details to use in the system. 2) Search Jobs: In this module, the user can search jobs. 3) Apply Jobs: In this module, the user can apply jobs. 4) Edit details: In this module, the user can search details about books by Author and Id



Rational Rose

Microsoft Access


128MB RAM


87

USECASE DIAGRAM:

CLASS DIAGRAM:

Employee

Login

Register

Search Jobs

Apply Jobs

Database

88

ACTIVITY DIAGRAM:

Login

Search jobs Apply Jobs Edit Details

Logout

89

SEQUENCE DIAGRAM

User Recruitment

Syste

Database

Login

Validate details

Valid user

Login sucess

Search Jobs

Retrive Details

Show Details

Apply Jobs

Make Entry

Entry Successful

Job Applied

Edit Details

Update Details

Updation Success

Details Edited

Send Details

90

COLLABORATION DIAGRAM:

COMPONENT DIAGRAM:

DEPLOYMENT DIAGRAM:

User Recruitment

Syste

Database

1: Login5: Search Jobs9: Apply Jobs

13: Edit Details

4: Login sucess8: Show Details12: Job Applied

16: Details Edited

2: Validate details6: Retrive Details10: Make Entry

14: Update Details

3: Valid user

11: Entry Successful15: Updation Success

7: Send Details

User Application Employer

Access

Databe

Recruitment

SystemEmployee

91

IMPLEMENTATION:

Form1:




Dim a As Boolean

a = False

cn.Open "dsn=recruit"


With rs




.Open "select * from Applicants"

End With

rs.MoveFirst

While Not rs.EOF


a = True

Form3.Show

Form1.Hide

End If

rs.MoveNext

Wend

If (a = False) Then


End If

End Sub


Form2.Show

Unload Me

End Sub

92

Form2




cn.Open "dsn=Recruit"



With rs




.Open "select * from Applicants"

End With

With rs

.AddNew






End If



93

End If




.Update


Form1.Show

Unload Me

End With

Else


End If

End Sub


Unload Me

End Sub

Form3


Form4.Show

Unload Me

End Sub


Form5.Show

Unload Me

End Sub


Text1.Text = Form1.Text1.Text

End Sub

94

Form4




Dim a As Boolean

a = False



With rs




.Open "select * from Jobs"

End With

rs.MoveFirst

While Not rs.EOF





a = True

End If

rs.MoveNext

Wend

If (a = False) Then

MsgBox ("Enter correct Company Name")

End If

End Sub




Dim a As Boolean

a = False

95



With rs





End With

rs.MoveFirst

While Not rs.EOF





a = True

End If

rs.MoveNext

Wend

If (a = False) Then


End If

End Sub


Form3.Show

Unload Me

End Sub

Form5




Dim a As Boolean

a = False



96

With rs





End With

rs.MoveFirst

While Not rs.EOF


rs(4) = rs(4) + ", " + Form1.Text1.Text

rs.Update

a = True

MsgBox "Job Applied"

End If

rs.MoveNext

Wend

If (a = False) Then


End If

End Sub

CONCLUSION:

This project was carried out in a sequential manner to design and implement the

“Recruitment System”. Thus the outcome of the project is efficient. The Recruitment System caters

the varied requirements of the user to perform various options.

97

Ex No: 10 ATM SYSTEM

Date:

AIM

To analyze, design and develop code for Atm System using Rational Rose software

PROBLEM STATEMENT

We envision a banking system that provides the customer holing a bank credit card can make

deposits, withdraws, check balances and perform transfer to and from their accounts. Atm card

processing will be attractive to banking customer because they allow access to their accounts outside

of regular business hours.

Participating Banks want to make sure the access to their customer account information is

safe and secure transaction information is accurate and reliable. Bank Customer-Want easy, low-cost,

remote access to their accounts, but want to be assured that their accounts are secure and not

accessible to hackers or other their parties.

Bank must be able to handle multiple simultaneous transactions (and possible

simultaneous transaction to the same joint account).Bank owning a credit card must be able to

determine the cash on hand in the atm. The cash in the at must be secure.

OVERALL DESCRIPTION

The Atm System is an integrated system that has four modules as part of it. The four modules

are,

1) User Login: Using this module user login to the system using his/her unique username

and password

2) Withdraw: The purpose of this module to withdraw money from the account

3) Deposit: The purpose of this module to deposit money to the account

4) Balance Enquiry: Using this module the user can check his/her account balance and the

loan amount to pay if any.



Rational Rose

Microsoft Access


128MB RAM


98

USE CASE DIAGRAM

CLASS DIAGRAM

Withdraw

User

Login

DatabaseTransaction

Balance Enquiry

99

ACTIVITY DIAGRAM

Login

Pin Change Withdraw Balance

Enquiry

Logout

100

SEQUENCE DIAGRAM

User System Database

Login

Validate details

Valid user

Login sucess

Withdraw

Reduce Amount

Send Cash

Balance Enquiry

Retrive Balance

Return Balance

Return details

Pin Change

Update Details

Updation Success

Pin Changed

New Balance

101


COMPONENT DIAGRAM

DEPLOYMENT DIAGRAM

User System

Database

1: Login5: Withdraw

9: Balance Enquiry13: Pin Change

4: Login sucess8: Send Cash

12: Return details16: Pin Changed

2: Validate details6: Reduce Amount10: Retrive Balance14: Update Details

3: Valid user

11: Return Balance15: Updation Success

7: New Balance

Customer ATM

Card

BankDatabas

e

Access

Databe

ATM

System

User

102

IMPLEMENTATION

Form1




Dim a As String

Dim b As Integer

Dim c As Boolean

c = False

cn.Open "dsn=atm"


With rs





End With

rs.MoveFirst

While Not rs.EOF

a = rs.Fields("AccNO")

b = rs.Fields("PIN")

If (Text1.Text = a And Val(Text2.Text) = b) Then

c = True

Form2.Show

Form1.Hide

End If

rs.MoveNext

Wend

If (c = False) Then

MsgBox ("Enter Correct AccNo and PIN")

End If

End Sub

103

Form2


Form3.Show

Unload Me

End Sub


Form4.Show

Unload Me

End Sub


Form5.Show

Unload Me

End Sub


Unload Form1

Unload Me

End Sub




Dim a As String

cn.Open "dsn=atm"


With rs





End With

104

rs.MoveFirst

While Not rs.EOF


If (Form1.Text1.Text = a) Then

Text1.Text = rs.Fields("UserName")

Text2.Text = a

End If

rs.MoveNext

Wend

End Sub

Form3


Form2.Show

Unload Me

End Sub


Unload Form1

Unload Me

End Sub




Dim a As String

cn.Open "dsn=atm"


With rs





End With

rs.MoveFirst

While Not rs.EOF


105


Text1.Text = rs.Fields("Balance")

End If

rs.MoveNext

Wend

End Sub

Form4




Dim a As String

Dim b As Integer

Dim c As Boolean

c = False

cn.Open "dsn=atm"


With rs





End With

rs.MoveFirst

While Not rs.EOF



If (Val(Text1.Text) = rs.Fields("PIN")) Then

If (Val(Text2.Text) = Val(Text3.Text)) Then

rs("PIN") = Val(Text2.Text)

rs.Update

MsgBox ("Pin Change Success")

c = True

Text1.Text = ""

Text2.Text = ""

106

Text3.Text = ""

End If

End If

End If

rs.MoveNext

Wend

If (c = False) Then

MsgBox ("Pin Change not Success")

End If

End Sub


Form2.Show

Unload Me

End Sub


Unload Form1

Unload Me

End Sub

Form5




Dim a As String

Dim b As Long

Dim c As Boolean

c = False

cn.Open "dsn=atm"


With rs





End With

107

rs.MoveFirst

While Not rs.EOF


b = rs.Fields("Balance")

If (a = Form1.Text1.Text And Val(Text1.Text) < b) Then

rs.Fields("Balance") = b - Val(Text1.Text)

c = True

MsgBox ("Collect the cash")

Text1.Text = ""

End If

rs.MoveNext

Wend

If (c = False) Then

MsgBox ("Not sufficient Balance")

End If

End Sub


Form2.Show

Unload Me

End Sub


Unload Form1

Unload Me

End Sub

CONCLUSION:

This project was carried out in a sequential manner to design and implement the “ATM

System”. Thus the outcome of the project is efficient. The ATM System caters the varied


108

Ex No:11 PAYROLL SYSTEM

Date:

AIM: To analyze, design and develop code for Payroll system using Rational Rose software.

PROBLEM STATEMENT

To compute the gross pay of a person using the Payroll system software and to add new

details to the existing database and update it, using visual basic 6.0 and MS Access

OVERALL DESCRIPTION

The three modules are

1) Entry form: The employee details, edit details and exit command buttons are present. We

can choose the required command button.

2) Pay slip form: Fill in the form with details such as employee id, employee name, department,

experience, and basic pay in the text boxes and submit using CALCULATE command button

Update it in the database using UPDATE command button.

3) Database form: Updated database would be present. We can search for the required Pay

details using SEARCH command button

SOFTWARE REQURIEMENTS:


Rational Rose

Microsoft Access.

HARDWARE REQURIMENTS:

128MB RAM


USECASE DIAGRAM

109

CLASS DIAGRAM

110

ACTIVITY DIAGRAM

Payroll

Employee

Detail

Salary

Emp payroll Official detail Basic PF Other

111

SEQUENCE DIAGRAM

Employee System Employee

Database

Login

Valid

Enter Employee Details

Store In Database

Return Details

Display details

Ask For Salary Slip

Ask For Basic Pay,PF

Return Details

Calculate & Display Salary

Exit

112


COMPONENT DIAGRAM

DEPLOYMENT DIAGRAM:

Employee

Database

Employee System

1: Login3: Enter Employee Details

7: Ask For Salary Slip

2: Valid6: Display details

10: Calculate & Display Salary11: Exit

4: Store In Database8: Ask For Basic Pay,PF

5: Return Details9: Return Details

Employee PayRoll Database

Access

DatabePayRoll

System

Employee

113

IMPLEMENTATION:

Form1:


Dim a As Boolean

a = False


a = True

Form2.Show

Unload Me

End If

If (a = False) Then


End If

End Sub

Form2


Form3.Show

Unload Me

End Sub

114


Form4.Show

Unload Me

End Sub


Form5.Show

Unload Me

End Sub


Unload Me

End Sub

Form3




Dim a As Boolean

a = False

cn.Open "dsn=payroll"


With rs




115


End With

rs.MoveFirst

While Not rs.EOF


Text2.Text = rs(1)

Text3.Text = rs(2)

Text4.Text = rs(3)

Text5.Text = rs(4)

Text6.Text = rs(5)

Text7.Text = rs(6)

Text8.Text = rs(7)

a = True

End If

rs.MoveNext

Wend

If (a = False) Then


End If

End Sub


Form2.Show

Unload Me

End Sub


Unload Me

End Sub

Form4






With rs





End With

With rs

.AddNew

116









.Update

End With

Text1.Text = ""

Text2.Text = ""

Text3.Text = ""

Text4.Text = ""

Text5.Text = ""

Text6.Text = ""

Text7.Text = ""

Text8.Text = ""

End Sub


Form2.Show

Unload Me

End Sub


Unload Me

End Sub

117


Text4.Text = Val(Text3.Text) * 0.25



Text8.Text = Val(Text3.Text) + Val(Text4.Text) + Val(Text5.Text) - Val(Text6.Text) +

Val(Text7.Text)

End Sub

Form5




Dim a As Boolean

a = False



With rs





End With

rs.MoveFirst

While Not rs.EOF


rs.Delete

rs.Update

a = True

End If

rs.MoveNext

Wend

118

If (a = False) Then


End If

End Sub


Form2.Show

Unload Me

End Sub


Unload Me

End Sub

CONCLUSION:

This project was carried out in a sequential manner to design and implement the “Payroll

System”. Thus the outcome of the project is efficient. The Payroll System caters the varied


87683689 ooad lab record

Documents