ๅฐŠๆ•ฌ็š„ ๅพฎไฟกๆฑ‡็Ž‡๏ผš1ๅ†† โ‰ˆ 0.046166 ๅ…ƒ ๆ”ฏไป˜ๅฎๆฑ‡็Ž‡๏ผš1ๅ†† โ‰ˆ 0.046257ๅ…ƒ [้€€ๅ‡บ็™ปๅฝ•]
SlideShare a Scribd company logo
09CSA10



     Online Shopping System
                                 CONTENTS
Phase 1   Project Analysis and Planning
          1.1.   Study of the Problem
          1.2.   Project Scope
          1.3.   Objectives
Phase 2   Cost Estimation
Phase 3   Modeling the Requirements
          3.1.   Module Description
                         3.1.1. Login
                         3.1.2. Product Details
                         3.1.3. Add New Products
                         3.1.4. Updating The Quantity
          3.2.   UML Diagram
                         3.2.1. Use case Diagram
                         3.2.2. Class Diagram
                         3.2.3. Sequence Diagram
                         3.2.4. Collaboration Diagram
Phase 4   Configuration Management
          4.1.   S/W Requirements
          4.2.   H/W Requirements
          4.3.   Tools
          4.4.   Software Development
                 4.4.1. Form Creation
                 4.4.2. Script
Phase 5   Software Testing
          5.1.   Preparing Test Plan
          5.2.   Perform Validation Testing
          5.3.   Validation Test Criteria
          5.4.   Coverage Analysis
          5.5.   Memory Leaks
09CSA10




                                   Synopsis

      This is a small scale project for Online shopping system.The basic
idea is that customerโ€™s can buy products using online. It consists of
product details, security system, status and exits. The administrator can
enter the name and password and generate the report and can perform
operations like add , search, delete the products in the database.

      The Online Shopping system enables vendors to set up online
shops, customers to browse through the shops, and a system administrator
to approve and reject requests for new shops and maintain lists of shop
categories.Also on the agenda is designing an online shopping site to
manage the items in the shop and also help customers purchase them
online without having to visit the shop physically.Our online shopping
mall will use the internet as the sole method for selling goods to its
consumers. Shopping will be highly personalized and the mall will
provide lower prices than most competitors.
09CSA10

Phase 1 Project Analysis and Planning
1.1.   Study of the Problem
       The Current shopping System is critical to set up online shops, customers to
browse through the shops, and a system administrator to approve and reject requests
for new shops and maintain lists of shop categories. This is a small scale project for
Online shopping System. The basic idea is that the candidates can buy product from
anywhere during any time by using their card number and password provided to them.
The database will maintain the product details information. Customer can view their
product details using the card details. This Online shopping system involves with two
types of users.
           โ€ข      CUSTOMER
           โ€ข      ADMINISTRATOR

CUSTOMER ROLE:
       The customerโ€™s can login/logout the System. He/She can view his/her product
details and buy their product. The customer can just view the information whereas
he/she could not make changes in the database.


ADMINISTRATOR ROLE:
       The administrator plays a vital role in the Online shopping system. The
administrator controls the entire database. The report of the product is generated by
the administrator itself. The main role of the administrator is to safeguard the database
and can add/delete the products from the database.


1.2.   Project Scope
                  The supplementary specification applies to online shopping system.
This specification defines the non-functional requirement of the system such as:
Functionality:
       Since it stand alone application, one or more user may use it at a time.
Usability:
       Desktop interface
       Windows 98/2000/XP/7
09CSA10

Reliability:
        The system is available during online time only .
Performance:
        The performance depends on hardware specification


1.3.    Objectives
                 The purpose of this document is to define the requirements of Online
shopping system. This supplementary specification lists the requirements that are not
readily captured in the use case model. Supplementary specification and the use case
model capture a complete set of requirement of the system.


Phase 2 Cost Estimation
        An estimate is a prediction based upon probabilistic assessment. It is the
responsibility of the project manager to make accurate estimations of effort and cost.
This is particularly true for projects subject to competitive bidding where a bid too
high compared with competitors would result in loosing the contract or a bid too low
could result in a loss to the organization. This does not mean that internal projects are
unimportant. From a project leaders estimate the management often decide whether to
proceed with the project. Industry has a need for accurate estimates of effort and size
at a very early stage in a project. However, when software cost estimates are done
early in the software development process the estimate can be based on wrong or
incomplete requirements. A software cost estimate process is the set of techniques and
procedures that organizations use to arrive at an estimate. An important aspect of
software projects is to know the cost. The major contributing factor is effort.


Why SCE is difficult and error prone ?
โ€ข       Software cost estimation requires a significant amount of effort to perform it
    correctly.
โ€ข       SCE is often done hurriedly, without an appreciation for the effort required.
โ€ข       You need experience at developing estimates, especially for large projects.
โ€ข       Human bias i.e. An Estimator is likely to consider how long a certain portion
    of the system would take, and then to merely extrapolate this estimate to the rest of
    the system, ignoring the non-linear aspects of software development.
09CSA10


The causes of poor and inaccurate estimation
โ€ข          New software projects are nearly always different form the last.
โ€ข          Software practitioners don't collect enough information about past
    projects.
โ€ข          Estimates are forced to match the resources available.

2.1. Cost and Pricing
    Our project is of high range and is highly efficient which can satisfy the shopping
calculation for almost all software companies. The chances of error occurrence is very
limited and so our costs around Rs 10, 00,000(app).
    โ€ข   A team of 11 members is required for completing the task.
    โ€ข   It takes a time span of 3 weeks to shape the project.
    โ€ข   There are no specific environmental constraints.


Phase 3 Modeling the Requirements
3.1.    Module Description
3.1.1. Login
        It is the login session for the Administrator, customer and Exit.
3.1.2. Product Details
        It is used to view the product details from the database.
3.1.3. Add New Products
        It is used to add a product into the database and it includes searching a product
details and removing a product from database.
3.1.4. Updating The Quantity
        It is used to update the product details from the database.
09CSA10




3.2.    UML Diagram
3.2.1. Use case Diagram
        Use Case diagrams show the various activities the users can perform on the
system. The System is something that performs a function. They model the dynamic
aspects of the system. It provides a userโ€™s perspective of the system.
        Actor:
        An actor is a user of the system playing a particular role.
        Use case:
        Use case is a particular activity a user can do on the system.
       Relationship:
        Relationships are simply illustrated with a line connecting actors to use cases.




         customer                    items di splayed                    purchase




                                            login                          add item
         admin




3.2.2. Class Diagram
        A class diagram describes the types of objects in the system and the various
kinds of static relationships that exist among them.i.e.,A graphical representation of a
static view on declarative static elements. A class is the description of a set of objects
having similar attributes, operations, relationships and behavior.
09CSA10


                custom                                items to display                                                   purchase
       name : variant new                          name : variant new                                        item name : variant new
       age : variant                               itm no : variant                                          itm no : variant
       address : variant new                       manuf date : variant                                      quantity : variant
       city : variant new                          exp date : variant                                        cost per item : variant
                                                                                                             total cost : variant
       view()                                      purchase()
                                                                                                             view()




                adminis
                                                          login                                                             add item
        name : variant new
        age : variant                          user name : variant new                                          item name : variant new
        city : variant new                     password : variant new                                           item no : variant
                                                                                                                quantity : variant
        add items()                            add items()
                                                                                                                view()



3.2.3. Sequence Diagram
       A sequence diagram in Unified Modeling Language (UML) is a kind of
interaction diagram that shows how processes operate with one another and in what
order. It is a construct of a Message Sequence Chart. Sequence diagrams are
sometimes called event diagrams, event scenarios, and timing diagrams.

     administrator              customer       add item                       view item                    purchase


                             adding the item

                                                   viewing the item to purchase


                                                                                             purchasing



                                                                                      updating the items to customer




                                                                                                                       purchasing again




3.2.4. Collaboration Diagram
       A Collaboration diagram is very similar to a Sequence diagram in the purpose
it achieves; in other words, it shows the dynamic interaction of the objects in a
system. A distinguishing feature of a Collaboration diagram is that it shows the
objects and their association with other objects in the system apart from how they
interact with each other. The association between objects is not represented in a
09CSA10

Sequence diagram. A Collaboration diagram is easily represented by modeling objects
in a system and representing the associations between the objects as links. The
interaction between the objects is denoted by arrows. To identify the sequence of
invocation of these objects, a number is placed next to each of these arrows.



             administrat
                                                             1: add the item
                or


                                                                                add item


                    customer



                                                  5: purchasing again

       2: viewing the item to purchase

                               3: purchasing
       view item                                       purchase

                   4: updating the items to customer




Phase 4 Configuration Management
          Configuration management is also used in software development, where it is
called Unified Configuration Management (UCM). Using UCM, developers can keep
track of the source code, documentation, problems, changes requested, and changes
made. An advantage of a configuration management application is that the entire
collection of systems can be reviewed to make sure any changes made to one system
do not adversely affect any of the other systems
4.1.      S/W Requirements
                     OS: Windows
                     Language: Visual Basic
4.2.      H/W Requirements
                     Intel PII Processor with 300 MHz speed.
                     64 MB RAM
                     10MB Hard disk space
09CSA10

4.3.   Tools
               Design Tool: Rational Rose suite
4.4.   Software Development
4.4.1. Form Creation
Form1:




Form2:
09CSA10


Form3:




Form4:
09CSA10

Form5:




Form6:
09CSA10

4.4.2. Script
Coding for form1 (MENU):

Private Sub Command1_Click()
Form2.Show
End Sub

Private Sub Command2_Click()
Form3.Show
End Sub

Coding for form2 (CUSTOMER PURCHASE):

Dim db As Database
Dim rs As Recordset

Private Sub Command1_Click()
Text7.Text = Text5.Text
End Sub

Private Sub Command2_Click()
If (Text6.Text = "") Then
MsgBox "ENTER THE QUANTITY"
Else
Text5.Text = (Val(Text5.Text) - Val(Text6.Text))
Data1.Recordset.Edit
Data1.Recordset.Update
Text7.Text = (Val(Text4.Text) * Val(Text6.Text))
MsgBox "TRANSACTION SUCEESSFUL.. PAY TO DEALER"
End If
End Sub

Private Sub Command3_Click()
rs.MoveFirst
Text1.Text = rs(0)
Text2.Text = rs(1)
Text3.Text = rs(2)
Text4.Text = rs(3)
Text5.Text = rs(4)
End Sub

Private Sub Command4_Click()
rs.MovePrevious
Text1.Text = rs(0)
Text2.Text = rs(1)
Text3.Text = rs(2)
Text4.Text = rs(3)
Text5.Text = rs(4)
End Sub
09CSA10

Private Sub Command5_Click()
rs.MoveNext
Text1.Text = rs(0)
Text2.Text = rs(1)
Text3.Text = rs(2)
Text4.Text = rs(3)
Text5.Text = rs(4)
End Sub

Private Sub Command6_Click()
rs.MoveLast
Text1.Text = rs(0)
Text2.Text = rs(1)
Text3.Text = rs(2)
Text4.Text = rs(3)
Text5.Text = rs(4)
End Sub

Private Sub Form_Load()
Set db = OpenDatabase("Z:BIG SHOP.MDB")
Set rs = db.OpenRecordset("SHOP")
Text1.Text = " "
Text2.Text = " "
Text3.Text = " "
Text4.Text = " "
Text5.Text = " "
Text6.Text = " "
End Sub
Private Sub LO_Click()
Form1.Show
End Sub

Coding for form3 (ADMINISTRATOR LOGIN):

Private Sub Command1_Click()
If Text1.Text = "bhuva" And Text2.Text = "123" Then
Me.Hide
Text1.Text = ""
Text2.Text = ""
Form4.Visible = True
Else
MsgBox "invalid username and password"
Text1.Text = ""
Text2.Text = ""
Text1.SetFocus
End If
End Sub
Private Sub Command2_Click()
End
End Sub
09CSA10




Coding for form4 (ADMIN CHECK):

Private Sub Command1_Click()
Form5.Show
End Sub

Private Sub Command2_Click()
Form1.Show
End Sub

Private Sub Command4_Click()
Form6.Show
End Sub

Coding for form5 (ADD PRODUCTS):
Dim db As Database
Dim rs As Recordset
Private Sub Command1_Click()
Data1.Recordset.AddNew

End Sub

Private Sub Command2_Click()
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
Text4.Text = ""
Text5.Text = ""
End Sub

Private Sub Command3_Click()
Form2.Show
End Sub

Private Sub Form_Load()
Set db = OpenDatabase("Z:BIG SHOP.MDB")
Set rs = db.OpenRecordset("SHOP")
End Sub
Private Sub Label1_Click()
End
End Sub

Coding for form6 (UPDATION OF PRODUCTS):

Dim db As Database
Dim rs As Recordset
09CSA10

Private Sub Combo1_Change()
End Sub
Private Sub Command1_Click()
If Combo1.List(0) = "NN" Then
Text2.Text = rs(4)
Text1.Text = (Val(Text2.Text) + Val(Text1.Text))
Data1.Recordset.Edit
Data1.Recordset.Update
Else
If Combo1.List(0) = "HAMAM" Then
Text2.Text = rs(4)
Text1.Text = (Val(Text2.Text) + Val(Text1.Text))
Data1.Recordset.Edit
Data1.Recordset.Update
Else
If Combo1.List(0) = "MYSORESANDLE" Then
Text2.Text = rs(4)
Text1.Text = (Val(Text2.Text) + Val(Text1.Text))
Data1.Recordset.Edit
Data1.Recordset.Update
End If
End Sub

Private Sub Form_Load()
Combo1.AddItem "NN"
Combo1.AddItem "HAMAM"
Combo1.AddItem "MYSORESANDLE"
Set db = OpenDatabase("Z:BIG SHOP.MDB")
Set rs = db.OpenRecordset("SHOP")
End Sub

Private Sub Label1_Click()
End
End Sub

Phase 5 Software Testing
5.1.   Preparing Test Plan
       Preparing test plan is the first step in the last phase of software development
cycle .The test plan consists of all the activities that had to be done in the software
testing phase. This test plan has been documented using the rational test manager
software.
5.2.   Perform Validation Testing
       Software is completely assembled as a package interfacing errors have been
uncovered and a final series of software test validation testing may begin. Validation
successive when the customer is satisfied.
09CSA10


5.3.   Validation Test Criteria
       Software validation is achieved through a series of black box test that
demonstrates conformity with requirements.
5.4.   Coverage Analysis
       Coverage analysis is used to identify untested code. Using rational pure
coverage, untested code can easily be identified.
5.5.   Memory Leaks
       Memory leak testing has been done using rational purity software.


Result:
       Based on the system requirements specification ONLINE SHOPPING
INFORMATION SYSTEM has been designed and implemented.

More Related Content

What's hot

Online shopping project synopsis
Online shopping project synopsisOnline shopping project synopsis
Online shopping project synopsis
Student Project Guide
ย 
ONLINE SHOPPING SYSTEM -SEPM
ONLINE SHOPPING SYSTEM -SEPMONLINE SHOPPING SYSTEM -SEPM
ONLINE SHOPPING SYSTEM -SEPM
Aantariksh Developers
ย 
Online shopping report-6 month project
Online shopping report-6 month projectOnline shopping report-6 month project
Online shopping report-6 month project
Ginne yoffe
ย 
Online shopping Project
Online shopping Project Online shopping Project
Online shopping Project
Krishna Mohan Shakya
ย 
Online Shop Project Report
Online Shop Project ReportOnline Shop Project Report
Online Shop Project Report
Jayed Imran
ย 
Problem statement
Problem statementProblem statement
Problem statement
Kanika Jain
ย 
Online shopping system (E-commerce)
Online shopping system (E-commerce)Online shopping system (E-commerce)
Online shopping system (E-commerce)
Sarp Infotech
ย 
Final year project presentation
Final year project presentationFinal year project presentation
Final year project presentation
Noman Manzoor
ย 
online shopping website project PPT
online shopping website project  PPT online shopping website project  PPT
online shopping website project PPT
anuragkanade1
ย 
Online shopping Report
Online shopping ReportOnline shopping Report
Online shopping Report
Pragnya Dash
ย 
E-commerce (System Analysis and Design)
E-commerce (System Analysis and Design)E-commerce (System Analysis and Design)
E-commerce (System Analysis and Design)
Nazmul Hyder
ย 
Software Requirement Specification on Online Purchasing System
Software Requirement Specification on Online Purchasing SystemSoftware Requirement Specification on Online Purchasing System
Software Requirement Specification on Online Purchasing System
sabafarheen
ย 
e commerce project report,E-Commerce,Eshop,report
e commerce project report,E-Commerce,Eshop,reporte commerce project report,E-Commerce,Eshop,report
e commerce project report,E-Commerce,Eshop,report
BabluAgrahari
ย 
e-Commerce Website Development Proposal
e-Commerce Website Development Proposale-Commerce Website Development Proposal
e-Commerce Website Development Proposal
Indicsoft Technologies
ย 
SRS For Online Store
SRS For Online StoreSRS For Online Store
SRS For Online Store
Ahsan Rizwan
ย 
Online Shopping System
Online Shopping SystemOnline Shopping System
Online Shopping System
Kusum Sankhala
ย 
Report of e commerce website
Report of e commerce websiteReport of e commerce website
Report of e commerce website
Farhan Anik
ย 
Deals made easy| Online Shopping Kart |Java,Jsp,JDBC
Deals made easy| Online Shopping Kart |Java,Jsp,JDBCDeals made easy| Online Shopping Kart |Java,Jsp,JDBC
Deals made easy| Online Shopping Kart |Java,Jsp,JDBC
SaikiranReddy Sama
ย 
Ecommerce srs
Ecommerce  srsEcommerce  srs
Ecommerce srs
vikram singh
ย 
Project report final
Project report finalProject report final
Project report final
Jaya Saini
ย 

What's hot (20)

Online shopping project synopsis
Online shopping project synopsisOnline shopping project synopsis
Online shopping project synopsis
ย 
ONLINE SHOPPING SYSTEM -SEPM
ONLINE SHOPPING SYSTEM -SEPMONLINE SHOPPING SYSTEM -SEPM
ONLINE SHOPPING SYSTEM -SEPM
ย 
Online shopping report-6 month project
Online shopping report-6 month projectOnline shopping report-6 month project
Online shopping report-6 month project
ย 
Online shopping Project
Online shopping Project Online shopping Project
Online shopping Project
ย 
Online Shop Project Report
Online Shop Project ReportOnline Shop Project Report
Online Shop Project Report
ย 
Problem statement
Problem statementProblem statement
Problem statement
ย 
Online shopping system (E-commerce)
Online shopping system (E-commerce)Online shopping system (E-commerce)
Online shopping system (E-commerce)
ย 
Final year project presentation
Final year project presentationFinal year project presentation
Final year project presentation
ย 
online shopping website project PPT
online shopping website project  PPT online shopping website project  PPT
online shopping website project PPT
ย 
Online shopping Report
Online shopping ReportOnline shopping Report
Online shopping Report
ย 
E-commerce (System Analysis and Design)
E-commerce (System Analysis and Design)E-commerce (System Analysis and Design)
E-commerce (System Analysis and Design)
ย 
Software Requirement Specification on Online Purchasing System
Software Requirement Specification on Online Purchasing SystemSoftware Requirement Specification on Online Purchasing System
Software Requirement Specification on Online Purchasing System
ย 
e commerce project report,E-Commerce,Eshop,report
e commerce project report,E-Commerce,Eshop,reporte commerce project report,E-Commerce,Eshop,report
e commerce project report,E-Commerce,Eshop,report
ย 
e-Commerce Website Development Proposal
e-Commerce Website Development Proposale-Commerce Website Development Proposal
e-Commerce Website Development Proposal
ย 
SRS For Online Store
SRS For Online StoreSRS For Online Store
SRS For Online Store
ย 
Online Shopping System
Online Shopping SystemOnline Shopping System
Online Shopping System
ย 
Report of e commerce website
Report of e commerce websiteReport of e commerce website
Report of e commerce website
ย 
Deals made easy| Online Shopping Kart |Java,Jsp,JDBC
Deals made easy| Online Shopping Kart |Java,Jsp,JDBCDeals made easy| Online Shopping Kart |Java,Jsp,JDBC
Deals made easy| Online Shopping Kart |Java,Jsp,JDBC
ย 
Ecommerce srs
Ecommerce  srsEcommerce  srs
Ecommerce srs
ย 
Project report final
Project report finalProject report final
Project report final
ย 

Viewers also liked

Online shopping presentation
Online shopping presentationOnline shopping presentation
Online shopping presentation
pobr0702
ย 
MINI PROJECT REPORT OF Maruthi Knitterss
MINI PROJECT REPORT OF Maruthi KnitterssMINI PROJECT REPORT OF Maruthi Knitterss
MINI PROJECT REPORT OF Maruthi Knitterss
kalim k
ย 
Online shop system use case diagram report
Online shop system use case diagram reportOnline shop system use case diagram report
Online shop system use case diagram report
Mahan Gheib Khah Mashak
ย 
Online real estate management system
Online real estate management systemOnline real estate management system
Online real estate management system
Yasmeen Od
ย 
E commerce use case documentation.
E commerce use case documentation.E commerce use case documentation.
E commerce use case documentation.
Yaswanth Babu Gummadivelli
ย 
UML Diagrams for Real estate management system
UML Diagrams for Real estate management systemUML Diagrams for Real estate management system
UML Diagrams for Real estate management system
Starlee Lathong
ย 
Online Shopping Presentation
Online Shopping PresentationOnline Shopping Presentation
Online Shopping Presentation
amanda-schmid
ย 
Online Shopping System PPT
Online Shopping System PPTOnline Shopping System PPT
Online Shopping System PPT
somarka
ย 
Online Shopping Full Project Presentation (20 slides)
Online Shopping Full Project Presentation (20 slides)Online Shopping Full Project Presentation (20 slides)
Online Shopping Full Project Presentation (20 slides)
Krishna Mohan Shakya
ย 

Viewers also liked (9)

Online shopping presentation
Online shopping presentationOnline shopping presentation
Online shopping presentation
ย 
MINI PROJECT REPORT OF Maruthi Knitterss
MINI PROJECT REPORT OF Maruthi KnitterssMINI PROJECT REPORT OF Maruthi Knitterss
MINI PROJECT REPORT OF Maruthi Knitterss
ย 
Online shop system use case diagram report
Online shop system use case diagram reportOnline shop system use case diagram report
Online shop system use case diagram report
ย 
Online real estate management system
Online real estate management systemOnline real estate management system
Online real estate management system
ย 
E commerce use case documentation.
E commerce use case documentation.E commerce use case documentation.
E commerce use case documentation.
ย 
UML Diagrams for Real estate management system
UML Diagrams for Real estate management systemUML Diagrams for Real estate management system
UML Diagrams for Real estate management system
ย 
Online Shopping Presentation
Online Shopping PresentationOnline Shopping Presentation
Online Shopping Presentation
ย 
Online Shopping System PPT
Online Shopping System PPTOnline Shopping System PPT
Online Shopping System PPT
ย 
Online Shopping Full Project Presentation (20 slides)
Online Shopping Full Project Presentation (20 slides)Online Shopping Full Project Presentation (20 slides)
Online Shopping Full Project Presentation (20 slides)
ย 

Similar to Onlineshopping

Onlineshoppingonline shopping
Onlineshoppingonline shoppingOnlineshoppingonline shopping
Onlineshoppingonline shopping
Hardik Padhy
ย 
Onlineshopping 121105040955-phpapp02
Onlineshopping 121105040955-phpapp02Onlineshopping 121105040955-phpapp02
Onlineshopping 121105040955-phpapp02
Shuchi Singla
ย 
Oosd shopping (1)
Oosd shopping (1)Oosd shopping (1)
Oosd shopping (1)
shaj13
ย 
Super market billing system using webcam
Super market billing system using webcam Super market billing system using webcam
Super market billing system using webcam
SahithBeats
ย 
Fundamentals of software development
Fundamentals of software developmentFundamentals of software development
Fundamentals of software development
Pratik Devmurari
ย 
IBM Cognos 10 Framework Manager Metadata Modeling: Tips and Tricks
IBM Cognos 10 Framework Manager Metadata Modeling: Tips and TricksIBM Cognos 10 Framework Manager Metadata Modeling: Tips and Tricks
IBM Cognos 10 Framework Manager Metadata Modeling: Tips and Tricks
Senturus
ย 
Dnyaneshwar_Anantwar_Resume
Dnyaneshwar_Anantwar_ResumeDnyaneshwar_Anantwar_Resume
Dnyaneshwar_Anantwar_Resume
aryan9011079624
ย 
Online movie ticket booking
Online movie ticket bookingOnline movie ticket booking
Online movie ticket booking
mrinnovater007
ย 
BIS09 Application Development - III
BIS09 Application Development - IIIBIS09 Application Development - III
BIS09 Application Development - III
Prithwis Mukerjee
ย 
Medicine For World
Medicine For WorldMedicine For World
Medicine For World
Saifur Rahman
ย 
Complaint Management system
Complaint Management systemComplaint Management system
Complaint Management system
Imran Hussain
ย 
EMC Documentum xCP 2.2 Self Paced Tutorial v1.0
EMC Documentum xCP 2.2 Self Paced Tutorial v1.0EMC Documentum xCP 2.2 Self Paced Tutorial v1.0
EMC Documentum xCP 2.2 Self Paced Tutorial v1.0
Haytham Ghandour
ย 
Future fashion report
Future fashion reportFuture fashion report
Future fashion report
lokeshboran
ย 
Online computer shop 111 35-181
Online computer shop 111 35-181Online computer shop 111 35-181
Online computer shop 111 35-181
Daffodil International University
ย 
Unit2 2
Unit2 2Unit2 2
Unit2 2
sush-sushma
ย 
Software Engineering Important Short Question for Exams
Software Engineering Important Short Question for ExamsSoftware Engineering Important Short Question for Exams
Software Engineering Important Short Question for Exams
MuhammadTalha436
ย 
PURPOSE of the project is Williams Specialty Company (WSC) reque.docx
PURPOSE of the project is Williams Specialty Company (WSC) reque.docxPURPOSE of the project is Williams Specialty Company (WSC) reque.docx
PURPOSE of the project is Williams Specialty Company (WSC) reque.docx
amrit47
ย 
Usecases
UsecasesUsecases
Usecases
richaliet
ย 
Medical Shop - 2.pptx
Medical Shop - 2.pptxMedical Shop - 2.pptx
Medical Shop - 2.pptx
saiproject
ย 
Shopping-Portal online shopping saystam.docx
Shopping-Portal online shopping saystam.docxShopping-Portal online shopping saystam.docx
Shopping-Portal online shopping saystam.docx
krushnaborade2
ย 

Similar to Onlineshopping (20)

Onlineshoppingonline shopping
Onlineshoppingonline shoppingOnlineshoppingonline shopping
Onlineshoppingonline shopping
ย 
Onlineshopping 121105040955-phpapp02
Onlineshopping 121105040955-phpapp02Onlineshopping 121105040955-phpapp02
Onlineshopping 121105040955-phpapp02
ย 
Oosd shopping (1)
Oosd shopping (1)Oosd shopping (1)
Oosd shopping (1)
ย 
Super market billing system using webcam
Super market billing system using webcam Super market billing system using webcam
Super market billing system using webcam
ย 
Fundamentals of software development
Fundamentals of software developmentFundamentals of software development
Fundamentals of software development
ย 
IBM Cognos 10 Framework Manager Metadata Modeling: Tips and Tricks
IBM Cognos 10 Framework Manager Metadata Modeling: Tips and TricksIBM Cognos 10 Framework Manager Metadata Modeling: Tips and Tricks
IBM Cognos 10 Framework Manager Metadata Modeling: Tips and Tricks
ย 
Dnyaneshwar_Anantwar_Resume
Dnyaneshwar_Anantwar_ResumeDnyaneshwar_Anantwar_Resume
Dnyaneshwar_Anantwar_Resume
ย 
Online movie ticket booking
Online movie ticket bookingOnline movie ticket booking
Online movie ticket booking
ย 
BIS09 Application Development - III
BIS09 Application Development - IIIBIS09 Application Development - III
BIS09 Application Development - III
ย 
Medicine For World
Medicine For WorldMedicine For World
Medicine For World
ย 
Complaint Management system
Complaint Management systemComplaint Management system
Complaint Management system
ย 
EMC Documentum xCP 2.2 Self Paced Tutorial v1.0
EMC Documentum xCP 2.2 Self Paced Tutorial v1.0EMC Documentum xCP 2.2 Self Paced Tutorial v1.0
EMC Documentum xCP 2.2 Self Paced Tutorial v1.0
ย 
Future fashion report
Future fashion reportFuture fashion report
Future fashion report
ย 
Online computer shop 111 35-181
Online computer shop 111 35-181Online computer shop 111 35-181
Online computer shop 111 35-181
ย 
Unit2 2
Unit2 2Unit2 2
Unit2 2
ย 
Software Engineering Important Short Question for Exams
Software Engineering Important Short Question for ExamsSoftware Engineering Important Short Question for Exams
Software Engineering Important Short Question for Exams
ย 
PURPOSE of the project is Williams Specialty Company (WSC) reque.docx
PURPOSE of the project is Williams Specialty Company (WSC) reque.docxPURPOSE of the project is Williams Specialty Company (WSC) reque.docx
PURPOSE of the project is Williams Specialty Company (WSC) reque.docx
ย 
Usecases
UsecasesUsecases
Usecases
ย 
Medical Shop - 2.pptx
Medical Shop - 2.pptxMedical Shop - 2.pptx
Medical Shop - 2.pptx
ย 
Shopping-Portal online shopping saystam.docx
Shopping-Portal online shopping saystam.docxShopping-Portal online shopping saystam.docx
Shopping-Portal online shopping saystam.docx
ย 

Recently uploaded

Keynote given on June 24 for MASSP at Grand Traverse City
Keynote given on June 24 for MASSP at Grand Traverse CityKeynote given on June 24 for MASSP at Grand Traverse City
Keynote given on June 24 for MASSP at Grand Traverse City
PJ Caposey
ย 
Library news letter Kitengesa Uganda June 2024
Library news letter Kitengesa Uganda June 2024Library news letter Kitengesa Uganda June 2024
Library news letter Kitengesa Uganda June 2024
Friends of African Village Libraries
ย 
78 Microsoft-Publisher - Sirin Sultana Bora.pptx
78 Microsoft-Publisher - Sirin Sultana Bora.pptx78 Microsoft-Publisher - Sirin Sultana Bora.pptx
78 Microsoft-Publisher - Sirin Sultana Bora.pptx
Kalna College
ย 
Information and Communication Technology in Education
Information and Communication Technology in EducationInformation and Communication Technology in Education
Information and Communication Technology in Education
MJDuyan
ย 
How to stay relevant as a cyber professional: Skills, trends and career paths...
How to stay relevant as a cyber professional: Skills, trends and career paths...How to stay relevant as a cyber professional: Skills, trends and career paths...
How to stay relevant as a cyber professional: Skills, trends and career paths...
Infosec
ย 
220711130088 Sumi Basak Virtual University EPC 3.pptx
220711130088 Sumi Basak Virtual University EPC 3.pptx220711130088 Sumi Basak Virtual University EPC 3.pptx
220711130088 Sumi Basak Virtual University EPC 3.pptx
Kalna College
ย 
Accounting for Restricted Grants When and How To Record Properly
Accounting for Restricted Grants  When and How To Record ProperlyAccounting for Restricted Grants  When and How To Record Properly
Accounting for Restricted Grants When and How To Record Properly
TechSoup
ย 
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
ShwetaGawande8
ย 
Talking Tech through Compelling Visual Aids
Talking Tech through Compelling Visual AidsTalking Tech through Compelling Visual Aids
Talking Tech through Compelling Visual Aids
MattVassar1
ย 
220711130082 Srabanti Bag Internet Resources For Natural Science
220711130082 Srabanti Bag Internet Resources For Natural Science220711130082 Srabanti Bag Internet Resources For Natural Science
220711130082 Srabanti Bag Internet Resources For Natural Science
Kalna College
ย 
What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17
Celine George
ย 
Science-9-Lesson-1-The Bohr Model-NLC.pptx pptx
Science-9-Lesson-1-The Bohr Model-NLC.pptx pptxScience-9-Lesson-1-The Bohr Model-NLC.pptx pptx
Science-9-Lesson-1-The Bohr Model-NLC.pptx pptx
Catherine Dela Cruz
ย 
The Rise of the Digital Telecommunication Marketplace.pptx
The Rise of the Digital Telecommunication Marketplace.pptxThe Rise of the Digital Telecommunication Marketplace.pptx
The Rise of the Digital Telecommunication Marketplace.pptx
PriyaKumari928991
ย 
Brand Guideline of Bashundhara A4 Paper - 2024
Brand Guideline of Bashundhara A4 Paper - 2024Brand Guideline of Bashundhara A4 Paper - 2024
Brand Guideline of Bashundhara A4 Paper - 2024
khabri85
ย 
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
yarusun
ย 
Bแป˜ Bร€I TแบฌP TEST THEO UNIT - FORM 2025 - TIแบพNG ANH 12 GLOBAL SUCCESS - KรŒ 1 (B...
Bแป˜ Bร€I TแบฌP TEST THEO UNIT - FORM 2025 - TIแบพNG ANH 12 GLOBAL SUCCESS - KรŒ 1 (B...Bแป˜ Bร€I TแบฌP TEST THEO UNIT - FORM 2025 - TIแบพNG ANH 12 GLOBAL SUCCESS - KรŒ 1 (B...
Bแป˜ Bร€I TแบฌP TEST THEO UNIT - FORM 2025 - TIแบพNG ANH 12 GLOBAL SUCCESS - KรŒ 1 (B...
Nguyen Thanh Tu Collection
ย 
Cross-Cultural Leadership and Communication
Cross-Cultural Leadership and CommunicationCross-Cultural Leadership and Communication
Cross-Cultural Leadership and Communication
MattVassar1
ย 
Contiguity Of Various Message Forms - Rupam Chandra.pptx
Contiguity Of Various Message Forms - Rupam Chandra.pptxContiguity Of Various Message Forms - Rupam Chandra.pptx
Contiguity Of Various Message Forms - Rupam Chandra.pptx
Kalna College
ย 
Diversity Quiz Prelims by Quiz Club, IIT Kanpur
Diversity Quiz Prelims by Quiz Club, IIT KanpurDiversity Quiz Prelims by Quiz Club, IIT Kanpur
Diversity Quiz Prelims by Quiz Club, IIT Kanpur
Quiz Club IIT Kanpur
ย 
pol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdfpol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdf
BiplabHalder13
ย 

Recently uploaded (20)

Keynote given on June 24 for MASSP at Grand Traverse City
Keynote given on June 24 for MASSP at Grand Traverse CityKeynote given on June 24 for MASSP at Grand Traverse City
Keynote given on June 24 for MASSP at Grand Traverse City
ย 
Library news letter Kitengesa Uganda June 2024
Library news letter Kitengesa Uganda June 2024Library news letter Kitengesa Uganda June 2024
Library news letter Kitengesa Uganda June 2024
ย 
78 Microsoft-Publisher - Sirin Sultana Bora.pptx
78 Microsoft-Publisher - Sirin Sultana Bora.pptx78 Microsoft-Publisher - Sirin Sultana Bora.pptx
78 Microsoft-Publisher - Sirin Sultana Bora.pptx
ย 
Information and Communication Technology in Education
Information and Communication Technology in EducationInformation and Communication Technology in Education
Information and Communication Technology in Education
ย 
How to stay relevant as a cyber professional: Skills, trends and career paths...
How to stay relevant as a cyber professional: Skills, trends and career paths...How to stay relevant as a cyber professional: Skills, trends and career paths...
How to stay relevant as a cyber professional: Skills, trends and career paths...
ย 
220711130088 Sumi Basak Virtual University EPC 3.pptx
220711130088 Sumi Basak Virtual University EPC 3.pptx220711130088 Sumi Basak Virtual University EPC 3.pptx
220711130088 Sumi Basak Virtual University EPC 3.pptx
ย 
Accounting for Restricted Grants When and How To Record Properly
Accounting for Restricted Grants  When and How To Record ProperlyAccounting for Restricted Grants  When and How To Record Properly
Accounting for Restricted Grants When and How To Record Properly
ย 
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
ย 
Talking Tech through Compelling Visual Aids
Talking Tech through Compelling Visual AidsTalking Tech through Compelling Visual Aids
Talking Tech through Compelling Visual Aids
ย 
220711130082 Srabanti Bag Internet Resources For Natural Science
220711130082 Srabanti Bag Internet Resources For Natural Science220711130082 Srabanti Bag Internet Resources For Natural Science
220711130082 Srabanti Bag Internet Resources For Natural Science
ย 
What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17
ย 
Science-9-Lesson-1-The Bohr Model-NLC.pptx pptx
Science-9-Lesson-1-The Bohr Model-NLC.pptx pptxScience-9-Lesson-1-The Bohr Model-NLC.pptx pptx
Science-9-Lesson-1-The Bohr Model-NLC.pptx pptx
ย 
The Rise of the Digital Telecommunication Marketplace.pptx
The Rise of the Digital Telecommunication Marketplace.pptxThe Rise of the Digital Telecommunication Marketplace.pptx
The Rise of the Digital Telecommunication Marketplace.pptx
ย 
Brand Guideline of Bashundhara A4 Paper - 2024
Brand Guideline of Bashundhara A4 Paper - 2024Brand Guideline of Bashundhara A4 Paper - 2024
Brand Guideline of Bashundhara A4 Paper - 2024
ย 
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
ย 
Bแป˜ Bร€I TแบฌP TEST THEO UNIT - FORM 2025 - TIแบพNG ANH 12 GLOBAL SUCCESS - KรŒ 1 (B...
Bแป˜ Bร€I TแบฌP TEST THEO UNIT - FORM 2025 - TIแบพNG ANH 12 GLOBAL SUCCESS - KรŒ 1 (B...Bแป˜ Bร€I TแบฌP TEST THEO UNIT - FORM 2025 - TIแบพNG ANH 12 GLOBAL SUCCESS - KรŒ 1 (B...
Bแป˜ Bร€I TแบฌP TEST THEO UNIT - FORM 2025 - TIแบพNG ANH 12 GLOBAL SUCCESS - KรŒ 1 (B...
ย 
Cross-Cultural Leadership and Communication
Cross-Cultural Leadership and CommunicationCross-Cultural Leadership and Communication
Cross-Cultural Leadership and Communication
ย 
Contiguity Of Various Message Forms - Rupam Chandra.pptx
Contiguity Of Various Message Forms - Rupam Chandra.pptxContiguity Of Various Message Forms - Rupam Chandra.pptx
Contiguity Of Various Message Forms - Rupam Chandra.pptx
ย 
Diversity Quiz Prelims by Quiz Club, IIT Kanpur
Diversity Quiz Prelims by Quiz Club, IIT KanpurDiversity Quiz Prelims by Quiz Club, IIT Kanpur
Diversity Quiz Prelims by Quiz Club, IIT Kanpur
ย 
pol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdfpol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdf
ย 

Onlineshopping

  • 1. 09CSA10 Online Shopping System CONTENTS Phase 1 Project Analysis and Planning 1.1. Study of the Problem 1.2. Project Scope 1.3. Objectives Phase 2 Cost Estimation Phase 3 Modeling the Requirements 3.1. Module Description 3.1.1. Login 3.1.2. Product Details 3.1.3. Add New Products 3.1.4. Updating The Quantity 3.2. UML Diagram 3.2.1. Use case Diagram 3.2.2. Class Diagram 3.2.3. Sequence Diagram 3.2.4. Collaboration Diagram Phase 4 Configuration Management 4.1. S/W Requirements 4.2. H/W Requirements 4.3. Tools 4.4. Software Development 4.4.1. Form Creation 4.4.2. Script Phase 5 Software Testing 5.1. Preparing Test Plan 5.2. Perform Validation Testing 5.3. Validation Test Criteria 5.4. Coverage Analysis 5.5. Memory Leaks
  • 2. 09CSA10 Synopsis This is a small scale project for Online shopping system.The basic idea is that customerโ€™s can buy products using online. It consists of product details, security system, status and exits. The administrator can enter the name and password and generate the report and can perform operations like add , search, delete the products in the database. The Online Shopping system enables vendors to set up online shops, customers to browse through the shops, and a system administrator to approve and reject requests for new shops and maintain lists of shop categories.Also on the agenda is designing an online shopping site to manage the items in the shop and also help customers purchase them online without having to visit the shop physically.Our online shopping mall will use the internet as the sole method for selling goods to its consumers. Shopping will be highly personalized and the mall will provide lower prices than most competitors.
  • 3. 09CSA10 Phase 1 Project Analysis and Planning 1.1. Study of the Problem The Current shopping System is critical to set up online shops, customers to browse through the shops, and a system administrator to approve and reject requests for new shops and maintain lists of shop categories. This is a small scale project for Online shopping System. The basic idea is that the candidates can buy product from anywhere during any time by using their card number and password provided to them. The database will maintain the product details information. Customer can view their product details using the card details. This Online shopping system involves with two types of users. โ€ข CUSTOMER โ€ข ADMINISTRATOR CUSTOMER ROLE: The customerโ€™s can login/logout the System. He/She can view his/her product details and buy their product. The customer can just view the information whereas he/she could not make changes in the database. ADMINISTRATOR ROLE: The administrator plays a vital role in the Online shopping system. The administrator controls the entire database. The report of the product is generated by the administrator itself. The main role of the administrator is to safeguard the database and can add/delete the products from the database. 1.2. Project Scope The supplementary specification applies to online shopping system. This specification defines the non-functional requirement of the system such as: Functionality: Since it stand alone application, one or more user may use it at a time. Usability: Desktop interface Windows 98/2000/XP/7
  • 4. 09CSA10 Reliability: The system is available during online time only . Performance: The performance depends on hardware specification 1.3. Objectives The purpose of this document is to define the requirements of Online shopping system. This supplementary specification lists the requirements that are not readily captured in the use case model. Supplementary specification and the use case model capture a complete set of requirement of the system. Phase 2 Cost Estimation An estimate is a prediction based upon probabilistic assessment. It is the responsibility of the project manager to make accurate estimations of effort and cost. This is particularly true for projects subject to competitive bidding where a bid too high compared with competitors would result in loosing the contract or a bid too low could result in a loss to the organization. This does not mean that internal projects are unimportant. From a project leaders estimate the management often decide whether to proceed with the project. Industry has a need for accurate estimates of effort and size at a very early stage in a project. However, when software cost estimates are done early in the software development process the estimate can be based on wrong or incomplete requirements. A software cost estimate process is the set of techniques and procedures that organizations use to arrive at an estimate. An important aspect of software projects is to know the cost. The major contributing factor is effort. Why SCE is difficult and error prone ? โ€ข Software cost estimation requires a significant amount of effort to perform it correctly. โ€ข SCE is often done hurriedly, without an appreciation for the effort required. โ€ข You need experience at developing estimates, especially for large projects. โ€ข Human bias i.e. An Estimator is likely to consider how long a certain portion of the system would take, and then to merely extrapolate this estimate to the rest of the system, ignoring the non-linear aspects of software development.
  • 5. 09CSA10 The causes of poor and inaccurate estimation โ€ข New software projects are nearly always different form the last. โ€ข Software practitioners don't collect enough information about past projects. โ€ข Estimates are forced to match the resources available. 2.1. Cost and Pricing Our project is of high range and is highly efficient which can satisfy the shopping calculation for almost all software companies. The chances of error occurrence is very limited and so our costs around Rs 10, 00,000(app). โ€ข A team of 11 members is required for completing the task. โ€ข It takes a time span of 3 weeks to shape the project. โ€ข There are no specific environmental constraints. Phase 3 Modeling the Requirements 3.1. Module Description 3.1.1. Login It is the login session for the Administrator, customer and Exit. 3.1.2. Product Details It is used to view the product details from the database. 3.1.3. Add New Products It is used to add a product into the database and it includes searching a product details and removing a product from database. 3.1.4. Updating The Quantity It is used to update the product details from the database.
  • 6. 09CSA10 3.2. UML Diagram 3.2.1. Use case Diagram Use Case diagrams show the various activities the users can perform on the system. The System is something that performs a function. They model the dynamic aspects of the system. It provides a userโ€™s perspective of the system. Actor: An actor is a user of the system playing a particular role. Use case: Use case is a particular activity a user can do on the system. Relationship: Relationships are simply illustrated with a line connecting actors to use cases. customer items di splayed purchase login add item admin 3.2.2. Class Diagram A class diagram describes the types of objects in the system and the various kinds of static relationships that exist among them.i.e.,A graphical representation of a static view on declarative static elements. A class is the description of a set of objects having similar attributes, operations, relationships and behavior.
  • 7. 09CSA10 custom items to display purchase name : variant new name : variant new item name : variant new age : variant itm no : variant itm no : variant address : variant new manuf date : variant quantity : variant city : variant new exp date : variant cost per item : variant total cost : variant view() purchase() view() adminis login add item name : variant new age : variant user name : variant new item name : variant new city : variant new password : variant new item no : variant quantity : variant add items() add items() view() 3.2.3. Sequence Diagram A sequence diagram in Unified Modeling Language (UML) is a kind of interaction diagram that shows how processes operate with one another and in what order. It is a construct of a Message Sequence Chart. Sequence diagrams are sometimes called event diagrams, event scenarios, and timing diagrams. administrator customer add item view item purchase adding the item viewing the item to purchase purchasing updating the items to customer purchasing again 3.2.4. Collaboration Diagram A Collaboration diagram is very similar to a Sequence diagram in the purpose it achieves; in other words, it shows the dynamic interaction of the objects in a system. A distinguishing feature of a Collaboration diagram is that it shows the objects and their association with other objects in the system apart from how they interact with each other. The association between objects is not represented in a
  • 8. 09CSA10 Sequence diagram. A Collaboration diagram is easily represented by modeling objects in a system and representing the associations between the objects as links. The interaction between the objects is denoted by arrows. To identify the sequence of invocation of these objects, a number is placed next to each of these arrows. administrat 1: add the item or add item customer 5: purchasing again 2: viewing the item to purchase 3: purchasing view item purchase 4: updating the items to customer Phase 4 Configuration Management Configuration management is also used in software development, where it is called Unified Configuration Management (UCM). Using UCM, developers can keep track of the source code, documentation, problems, changes requested, and changes made. An advantage of a configuration management application is that the entire collection of systems can be reviewed to make sure any changes made to one system do not adversely affect any of the other systems 4.1. S/W Requirements OS: Windows Language: Visual Basic 4.2. H/W Requirements Intel PII Processor with 300 MHz speed. 64 MB RAM 10MB Hard disk space
  • 9. 09CSA10 4.3. Tools Design Tool: Rational Rose suite 4.4. Software Development 4.4.1. Form Creation Form1: Form2:
  • 12. 09CSA10 4.4.2. Script Coding for form1 (MENU): Private Sub Command1_Click() Form2.Show End Sub Private Sub Command2_Click() Form3.Show End Sub Coding for form2 (CUSTOMER PURCHASE): Dim db As Database Dim rs As Recordset Private Sub Command1_Click() Text7.Text = Text5.Text End Sub Private Sub Command2_Click() If (Text6.Text = "") Then MsgBox "ENTER THE QUANTITY" Else Text5.Text = (Val(Text5.Text) - Val(Text6.Text)) Data1.Recordset.Edit Data1.Recordset.Update Text7.Text = (Val(Text4.Text) * Val(Text6.Text)) MsgBox "TRANSACTION SUCEESSFUL.. PAY TO DEALER" End If End Sub Private Sub Command3_Click() rs.MoveFirst Text1.Text = rs(0) Text2.Text = rs(1) Text3.Text = rs(2) Text4.Text = rs(3) Text5.Text = rs(4) End Sub Private Sub Command4_Click() rs.MovePrevious Text1.Text = rs(0) Text2.Text = rs(1) Text3.Text = rs(2) Text4.Text = rs(3) Text5.Text = rs(4) End Sub
  • 13. 09CSA10 Private Sub Command5_Click() rs.MoveNext Text1.Text = rs(0) Text2.Text = rs(1) Text3.Text = rs(2) Text4.Text = rs(3) Text5.Text = rs(4) End Sub Private Sub Command6_Click() rs.MoveLast Text1.Text = rs(0) Text2.Text = rs(1) Text3.Text = rs(2) Text4.Text = rs(3) Text5.Text = rs(4) End Sub Private Sub Form_Load() Set db = OpenDatabase("Z:BIG SHOP.MDB") Set rs = db.OpenRecordset("SHOP") Text1.Text = " " Text2.Text = " " Text3.Text = " " Text4.Text = " " Text5.Text = " " Text6.Text = " " End Sub Private Sub LO_Click() Form1.Show End Sub Coding for form3 (ADMINISTRATOR LOGIN): Private Sub Command1_Click() If Text1.Text = "bhuva" And Text2.Text = "123" Then Me.Hide Text1.Text = "" Text2.Text = "" Form4.Visible = True Else MsgBox "invalid username and password" Text1.Text = "" Text2.Text = "" Text1.SetFocus End If End Sub Private Sub Command2_Click() End End Sub
  • 14. 09CSA10 Coding for form4 (ADMIN CHECK): Private Sub Command1_Click() Form5.Show End Sub Private Sub Command2_Click() Form1.Show End Sub Private Sub Command4_Click() Form6.Show End Sub Coding for form5 (ADD PRODUCTS): Dim db As Database Dim rs As Recordset Private Sub Command1_Click() Data1.Recordset.AddNew End Sub Private Sub Command2_Click() Text1.Text = "" Text2.Text = "" Text3.Text = "" Text4.Text = "" Text5.Text = "" End Sub Private Sub Command3_Click() Form2.Show End Sub Private Sub Form_Load() Set db = OpenDatabase("Z:BIG SHOP.MDB") Set rs = db.OpenRecordset("SHOP") End Sub Private Sub Label1_Click() End End Sub Coding for form6 (UPDATION OF PRODUCTS): Dim db As Database Dim rs As Recordset
  • 15. 09CSA10 Private Sub Combo1_Change() End Sub Private Sub Command1_Click() If Combo1.List(0) = "NN" Then Text2.Text = rs(4) Text1.Text = (Val(Text2.Text) + Val(Text1.Text)) Data1.Recordset.Edit Data1.Recordset.Update Else If Combo1.List(0) = "HAMAM" Then Text2.Text = rs(4) Text1.Text = (Val(Text2.Text) + Val(Text1.Text)) Data1.Recordset.Edit Data1.Recordset.Update Else If Combo1.List(0) = "MYSORESANDLE" Then Text2.Text = rs(4) Text1.Text = (Val(Text2.Text) + Val(Text1.Text)) Data1.Recordset.Edit Data1.Recordset.Update End If End Sub Private Sub Form_Load() Combo1.AddItem "NN" Combo1.AddItem "HAMAM" Combo1.AddItem "MYSORESANDLE" Set db = OpenDatabase("Z:BIG SHOP.MDB") Set rs = db.OpenRecordset("SHOP") End Sub Private Sub Label1_Click() End End Sub Phase 5 Software Testing 5.1. Preparing Test Plan Preparing test plan is the first step in the last phase of software development cycle .The test plan consists of all the activities that had to be done in the software testing phase. This test plan has been documented using the rational test manager software. 5.2. Perform Validation Testing Software is completely assembled as a package interfacing errors have been uncovered and a final series of software test validation testing may begin. Validation successive when the customer is satisfied.
  • 16. 09CSA10 5.3. Validation Test Criteria Software validation is achieved through a series of black box test that demonstrates conformity with requirements. 5.4. Coverage Analysis Coverage analysis is used to identify untested code. Using rational pure coverage, untested code can easily be identified. 5.5. Memory Leaks Memory leak testing has been done using rational purity software. Result: Based on the system requirements specification ONLINE SHOPPING INFORMATION SYSTEM has been designed and implemented.
  ็ฟป่ฏ‘๏ผš