Photoshop Management System(part 2) e4v68
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report 2z6p3t
Overview 5o1f4z
& View Photoshop Management System(part 2) as PDF for free.
More details 6z3438
- Words: 1,706
- Pages: 32
PHOTO-SHOP MANAGEMENT
gANtT CHART 1.
Project Search
2.
Finalization
3.
Allocation
4.
Investigation of System Requirements
5.
Data & Process Modeling
6.
System Design
7.
Program Design
8.
Program Coding
9.
Unit Testing
10 .
System Integration
11 .
System Implementation
12 .
Acceptance Testing
1
2
3
4
5
6
7 8
9
10
11
12
W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13 W14 W15 W16 W17 W18 W19 W20 W21
1
PHOTO-SHOP MANAGEMENT
SYSTEM analysis
Event tables 2
PHOTO-SHOP MANAGEMENT
Event
Trigger
Source
Activity
Response
Destination
Entering Customer Details
Request for entering customer details
Entering customer details
Customer
Entering Dealer Details
Request for entering dealer details
Entering dealer details
Dealer details
Entering
Request for entering item details
Entering item details
Item Details
Entering Lab details
Request for entering photo wash details
Entering photo wash details
Lab Details
Purchasing Orders
New Order
Create new order
Order details
Dealer
Info Ordering
Checking availability of component for fulfillment of Order
Customer
Look up for component and fulfills the order
Order details and totals the amount of Order placed
Produce Reports
Reports
Generating Reports
Detailed Report
Item
Details
Details
Use case diagram
Create new Customer Record
3
PHOTO-SHOP MANAGEMENT
Update
Customer
Customer record Delete Customer
Look up Customer record
record
Display Customer record
e.R.D (ENTITY
DEALE R
RELATIONSHIP DIAGRAM)
PHOTOSHOP MANAGEMENT
PURCHASE ORDER
4
PHOTO-SHOP MANAGEMENT
CUSTOM ER
ACTIVITY DIAGRAM Customer come to Photo studio
Called the bill and write details
Enter the Order detail
Validate
Triggers generate receipt Printing
Printing the bill receipt
Verifies Availabil ity
Issues receipt
5
PHOTO-SHOP MANAGEMENT
Order modify
Not
Ok Ok
Ok
Ok Trigger fair process
Not Collect fair amount Trigger update
Arrival at the fair amount Alter to next Confirm proces s Ok with the
process
CLASS DIAGRAM
6
PHOTO-SHOP MANAGEMENT
SEQUENCE DIAGRAM Photo Create new customer Photo information
Create information (information)
Photo ID=get photo ID Update photo (Photo ID, Photo
detail)
7
PHOTO-SHOP MANAGEMENT
Photo
Photo ID=get photo ID (information) Delete photo (photo ID) Worker ID (EXIT) deletes worker detail
Photo
Create request for salary
look up for delay
Orde r Create new order receipt (order information)
Orde r Print order receipt
Order 8
PHOTO-SHOP MANAGEMENT
Create a chart
Order
Change information receipt(customer)
receipt no. = get order Update (customer receipt no.)
Order
Print order receipt
STATE DIAGRAM Exit , edit & open
Enter
Entry |set echo to start ; . reset () Exit | set echo normal digit |handle character Clear | . reset() Help| display help Prompting for Entry| show screen. Exit/hide
Sending
Entry| send
9
PHOTO-SHOP MANAGEMENT
failed Validating
Valid
Entry | show failed screen. Exit\ hide screen. Sending failed Entry | show send failure screen. Exit |hide Sending successed Entry | show send success screen. Exit | hide
system design 10
PHOTO-SHOP MANAGEMENT
Deployment Diagram Server/Configuration Body, Acces s
Configuration GUI
PC
11
PHOTO-SHOP MANAGEMENT
Component diagram
Body, Access
GUI
12
PHOTO-SHOP MANAGEMENT
Package diagram
Photoshop Management
Cancel
Connection
13
PHOTO-SHOP MANAGEMENT
System Flow chart
Product Database Customer program
Custom erRepor t
Customer Program Program
Customer information
Customer Database
Customer Program Database
Customer Program
Database Dealer Database
Program
Dealer Informatio n database
Dealer Program Dealer Information
Purchase order Prog
Purchase Order Databas e
Item Database Purchase Report
Structure chart
14
PHOTO-SHOP MANAGEMENT
Photo-Shop Management System Reciept Amount Item Qty, Amt Details
Placing Order
Detail Information
Generate Purchase Order Reciept
Give Reports
Item Oty
Purchase Total Amt Order
Detai
Order Detail
ls Customer Informatio n
Dealer Informatio n
Purchase order
MENU TREE
Item Information
MASTER
Customer Information
15
PHOTO-SHOP MANAGEMENT
Dealer Information Lab Information Order Information
ORDER INFORMATION
Photo Shooting Order Purchase
TRANSACTI ON
Purchase Order Receipt
MENU REPOR
Item Information Customer Dealer Purchase Order Calculator
TOOL S
Notepad
HE LP Programming list
Log
16
PHOTO-SHOP MANAGEMENT
Sr.n o.
Forms
1
Frmsplash
2
for
3
Item Detail
4
Customer Details
5
Dealer Information
6
Lab Information
7
Order Details
8
Photo Order
9
Shooting Order
10
Purchase Information
11
Purchase Reciept
12
Report
13
Exit
Description This from is used for splash screen. It contain the overview (or name) of my organization This form is used to entered . The & should be correct to enter in the system. This form is contain information of Item This form is contain information of customer This form is contain information of Dealer This form contain details of Lab This form contain all the details of Order Information This form shows the Photo Order This form shows the Shooting Order This form contain particular records of the Purchase Order This form contains Purchase Receipt This form contains report of that particular form This is used for close the system
17
PHOTO-SHOP MANAGEMENT
TABLE deSing
Table Listing 18
PHOTO-SHOP MANAGEMENT
Item Information:
Sr.n o
Field name
Data Type
Descripti on
1
Item_no
Text
Use for serial no only
2
I_code
Text
Use for Item code
3
I_name
Text
Use for Item name
4
I_cost
Number
Use for Item cost
Customer Information: Sr.N o.
Field Name
Data Type
1
Cust_no
Number
Use for serial no only
2
Cust_code
Text
Use for Customer code
3
Cust_name
Text
Use for customer name
4
Cust_ Number
Use for customer
5
Cust_add
Use for Customer Address
Text
Description
19
PHOTO-SHOP MANAGEMENT
Dealer Information: Sr.N o.
Field Name
Data Type
Description
1
Dealer_no
Number
Use for serial no only
2
D_code
Text
Use for Dealer code
3
D_name
Text
Use for Dealer name
4
D_
Number
Use for Dealer
5
D_address
Text
Use for Dealer Address
20
PHOTO-SHOP MANAGEMENT
Lab Information: Sr.N o.
Field Name
Data Type
Description
1
Lab_no
Number
Use for serial no only
2
L_code
Text
Use for Lab code
3
L_name
Text
Use for Lab name
4
L_
Number
Use for Lab
5
L_Address
Text
Use for Lab Address
Order Information:
21
PHOTO-SHOP MANAGEMENT
Sr. No
Field Name
DataTyp
Description
e
1
Order_no
Number
Use for serial no only
2
O_code
Text
Use for Order code
3
O_Date
Date&time
Use for Order date
4
O_name
Number
Use for Order name
5
O_add
Date&Time
Use for order address
6
O_tamt
Number
Use for Total amount
7
O_pamt
number
Use for Paid amount
8
O_bal
number
Use for Balance
9
O_odate
Date&time
Use for Order -orderdate
10
O_
number
Use for order
11
O_ddate
Date&time
Use for OrderDuedate
22
PHOTO-SHOP MANAGEMENT
Order Detail: Sr. No
Field Name
DataTyp
Description
e
1
Order_no
Number
Use for serial no only
2
Size
Text
Use for Order size
3
Ptype
Text
Use for Photo type
4
Pcost
Number
Use for Photo cost
5
Quantity
Number
Use for order Quantity
6
Ptotal
Number
Use for Total amount
7
Stype
Text
Use for Shooting type
8
Scost
Number
Use for Shooting cost
9
Mixing
Number
Use for Order mixing
10
Stotal
number
Use for Total amount
11
Shooting Hours
Text
Use for Shooting hours 23
PHOTO-SHOP MANAGEMENT
Photo Information:
24
PHOTO-SHOP MANAGEMENT
Sr. No
Field Name
DataTyp
Description
e
1
Photo_no
Number
Use for serial no only
2
P_code
Text
Use for P_Order code
3
P_Date
Date&time
Use for P_Order date
4
P_name
Number
Use for P_Order name
5
P_add
Date&Time
Use for P_order address
6
P_tamt
Number
Use for Total amount
7
P_pamt
number
Use for Paid amount
8
P_bal
number
Use for Balance
9
P_odate
Date&time
Use for P -orderdate
10
P_
number
Use for P_order
11
P_ddate
Date&time
Use forP-Duedate
25
PHOTO-SHOP MANAGEMENT
Photo Detail: Sr. No
Field Name
DataTyp
Description
e
1
Photo_no
Number
Use for serial no only
2
Size
Text
Use for Photo size
3
Ptype
Text
Use for Photo type
4
Pcost
Number
Use for Photo cost
5
Quantity
Number
Use for photo Quantity
6
Ptotal
Number
Use for Total amount
26
PHOTO-SHOP MANAGEMENT
Shooting Information: Sr. No
Field Name
DataTyp
Description
e
1
Shooting_no
Number
Use for serial no only
2
S_code
Text
Use for S_Order code
3
S_Date
Date&time
Use forS_Order date
4
S_name
Number
Use for S_Order name
5
S_add
Date&Time
Use for S_order address
6
S_tamt
Number
Use for Total amount
7
S_pamt
number
Use for Paid amount
8
S_bal
number
Use for Balance
9
S_odate
Date&time
Use for S -orderdate
10
S_
number
Use for S_order
11
S_ddate
Date&time
Use forS-Duedate
27
PHOTO-SHOP MANAGEMENT
Shooting Detail: Sr. No
Field Name
DataTyp
Description
e
1
Shooting_no
Number
Use for serial no only
2
Size
Text
Use for Shooting size
3
Stype
Text
Use for Shooting type
4
Scost
Number
Use for Shooting cost
5
Quantity
Number
Use for Shooting Quantity
6
Stotal
Number
Use for Total amount
28
PHOTO-SHOP MANAGEMENT
Purchase Information: Sr.N o.
Field Name
Data Type
Description
1
P_Id
Number
Use for serial no only
2
Dealer_code
Text
Use for Dealer code
3
Dealer_name
Text
Use for Dealer name
4
Dealer_conta ct
Number
Use for Dealer
5
Dealer_Addre ss
Text
Use for Dealer Address
6
Date
Date&time
Use for Purchase date
7
Total
Number
Use for Purchase total
29
PHOTO-SHOP MANAGEMENT
Purchase Detail: Sr. No
Field Name
DataTyp
Description
e
1
P_Id
Number
Use for serial no only
2
I_name
Text
Use for Item name
3
Cost
Text
Use for Item cost
4
Qty
Number
Use for Item quantity
5
Total
Number
Use for Total amount
30
PHOTO-SHOP MANAGEMENT
Report no
Name Of Report
1
Item Information
2
Customer Information
3
Dealer Information
4
Purchase Information
REPORT LIST
31
PHOTO-SHOP MANAGEMENT
CODING CONVENTION SR. NO. 1
FORM frm item detail
CONNECTION 1
Cn
connection
2
Rs
Recordset
2
frm customer detail
1
Rs
Recordset
3
frm dealer detail
1
Cn
connection
2
Rs
Recordset
4
frm lab detail
1
Rs
Recordset
5
frm purchase Order
1
Cn
connection
2
Rs
Recordset
DESCRIPTION To Create connection with ADODB . To create Recordset with ADODB. To create Recordset with ADODB. To create Connection with ADODB. To create Recordset with ADODB. To create Recordset with ADODB To create Connection with ADODB To create Recordset with ADODB.
32
gANtT CHART 1.
Project Search
2.
Finalization
3.
Allocation
4.
Investigation of System Requirements
5.
Data & Process Modeling
6.
System Design
7.
Program Design
8.
Program Coding
9.
Unit Testing
10 .
System Integration
11 .
System Implementation
12 .
Acceptance Testing
1
2
3
4
5
6
7 8
9
10
11
12
W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13 W14 W15 W16 W17 W18 W19 W20 W21
1
PHOTO-SHOP MANAGEMENT
SYSTEM analysis
Event tables 2
PHOTO-SHOP MANAGEMENT
Event
Trigger
Source
Activity
Response
Destination
Entering Customer Details
Request for entering customer details
Entering customer details
Customer
Entering Dealer Details
Request for entering dealer details
Entering dealer details
Dealer details
Entering
Request for entering item details
Entering item details
Item Details
Entering Lab details
Request for entering photo wash details
Entering photo wash details
Lab Details
Purchasing Orders
New Order
Create new order
Order details
Dealer
Info Ordering
Checking availability of component for fulfillment of Order
Customer
Look up for component and fulfills the order
Order details and totals the amount of Order placed
Produce Reports
Reports
Generating Reports
Detailed Report
Item
Details
Details
Use case diagram
Create new Customer Record
3
PHOTO-SHOP MANAGEMENT
Update
Customer
Customer record Delete Customer
Look up Customer record
record
Display Customer record
e.R.D (ENTITY
DEALE R
RELATIONSHIP DIAGRAM)
PHOTOSHOP MANAGEMENT
PURCHASE ORDER
4
PHOTO-SHOP MANAGEMENT
CUSTOM ER
ACTIVITY DIAGRAM Customer come to Photo studio
Called the bill and write details
Enter the Order detail
Validate
Triggers generate receipt Printing
Printing the bill receipt
Verifies Availabil ity
Issues receipt
5
PHOTO-SHOP MANAGEMENT
Order modify
Not
Ok Ok
Ok
Ok Trigger fair process
Not Collect fair amount Trigger update
Arrival at the fair amount Alter to next Confirm proces s Ok with the
process
CLASS DIAGRAM
6
PHOTO-SHOP MANAGEMENT
SEQUENCE DIAGRAM Photo Create new customer Photo information
Create information (information)
Photo ID=get photo ID Update photo (Photo ID, Photo
detail)
7
PHOTO-SHOP MANAGEMENT
Photo
Photo ID=get photo ID (information) Delete photo (photo ID) Worker ID (EXIT) deletes worker detail
Photo
Create request for salary
look up for delay
Orde r Create new order receipt (order information)
Orde r Print order receipt
Order 8
PHOTO-SHOP MANAGEMENT
Create a chart
Order
Change information receipt(customer)
receipt no. = get order Update (customer receipt no.)
Order
Print order receipt
STATE DIAGRAM Exit , edit & open
Enter
Entry |set echo to start ; . reset () Exit | set echo normal digit |handle character Clear | . reset() Help| display help Prompting for Entry| show screen. Exit/hide
Sending
Entry| send
9
PHOTO-SHOP MANAGEMENT
failed Validating
Valid
Entry | show failed screen. Exit\ hide screen. Sending failed Entry | show send failure screen. Exit |hide Sending successed Entry | show send success screen. Exit | hide
system design 10
PHOTO-SHOP MANAGEMENT
Deployment Diagram Server/Configuration Body, Acces s
Configuration GUI
PC
11
PHOTO-SHOP MANAGEMENT
Component diagram
Body, Access
GUI
12
PHOTO-SHOP MANAGEMENT
Package diagram
Photoshop Management
Cancel
Connection
13
PHOTO-SHOP MANAGEMENT
System Flow chart
Product Database Customer program
Custom erRepor t
Customer Program Program
Customer information
Customer Database
Customer Program Database
Customer Program
Database Dealer Database
Program
Dealer Informatio n database
Dealer Program Dealer Information
Purchase order Prog
Purchase Order Databas e
Item Database Purchase Report
Structure chart
14
PHOTO-SHOP MANAGEMENT
Photo-Shop Management System Reciept Amount Item Qty, Amt Details
Placing Order
Detail Information
Generate Purchase Order Reciept
Give Reports
Item Oty
Purchase Total Amt Order
Detai
Order Detail
ls Customer Informatio n
Dealer Informatio n
Purchase order
MENU TREE
Item Information
MASTER
Customer Information
15
PHOTO-SHOP MANAGEMENT
Dealer Information Lab Information Order Information
ORDER INFORMATION
Photo Shooting Order Purchase
TRANSACTI ON
Purchase Order Receipt
MENU REPOR
Item Information Customer Dealer Purchase Order Calculator
TOOL S
Notepad
HE LP Programming list
Log
16
PHOTO-SHOP MANAGEMENT
Sr.n o.
Forms
1
Frmsplash
2
for
3
Item Detail
4
Customer Details
5
Dealer Information
6
Lab Information
7
Order Details
8
Photo Order
9
Shooting Order
10
Purchase Information
11
Purchase Reciept
12
Report
13
Exit
Description This from is used for splash screen. It contain the overview (or name) of my organization This form is used to entered . The & should be correct to enter in the system. This form is contain information of Item This form is contain information of customer This form is contain information of Dealer This form contain details of Lab This form contain all the details of Order Information This form shows the Photo Order This form shows the Shooting Order This form contain particular records of the Purchase Order This form contains Purchase Receipt This form contains report of that particular form This is used for close the system
17
PHOTO-SHOP MANAGEMENT
TABLE deSing
Table Listing 18
PHOTO-SHOP MANAGEMENT
Item Information:
Sr.n o
Field name
Data Type
Descripti on
1
Item_no
Text
Use for serial no only
2
I_code
Text
Use for Item code
3
I_name
Text
Use for Item name
4
I_cost
Number
Use for Item cost
Customer Information: Sr.N o.
Field Name
Data Type
1
Cust_no
Number
Use for serial no only
2
Cust_code
Text
Use for Customer code
3
Cust_name
Text
Use for customer name
4
Cust_ Number
Use for customer
5
Cust_add
Use for Customer Address
Text
Description
19
PHOTO-SHOP MANAGEMENT
Dealer Information: Sr.N o.
Field Name
Data Type
Description
1
Dealer_no
Number
Use for serial no only
2
D_code
Text
Use for Dealer code
3
D_name
Text
Use for Dealer name
4
D_
Number
Use for Dealer
5
D_address
Text
Use for Dealer Address
20
PHOTO-SHOP MANAGEMENT
Lab Information: Sr.N o.
Field Name
Data Type
Description
1
Lab_no
Number
Use for serial no only
2
L_code
Text
Use for Lab code
3
L_name
Text
Use for Lab name
4
L_
Number
Use for Lab
5
L_Address
Text
Use for Lab Address
Order Information:
21
PHOTO-SHOP MANAGEMENT
Sr. No
Field Name
DataTyp
Description
e
1
Order_no
Number
Use for serial no only
2
O_code
Text
Use for Order code
3
O_Date
Date&time
Use for Order date
4
O_name
Number
Use for Order name
5
O_add
Date&Time
Use for order address
6
O_tamt
Number
Use for Total amount
7
O_pamt
number
Use for Paid amount
8
O_bal
number
Use for Balance
9
O_odate
Date&time
Use for Order -orderdate
10
O_
number
Use for order
11
O_ddate
Date&time
Use for OrderDuedate
22
PHOTO-SHOP MANAGEMENT
Order Detail: Sr. No
Field Name
DataTyp
Description
e
1
Order_no
Number
Use for serial no only
2
Size
Text
Use for Order size
3
Ptype
Text
Use for Photo type
4
Pcost
Number
Use for Photo cost
5
Quantity
Number
Use for order Quantity
6
Ptotal
Number
Use for Total amount
7
Stype
Text
Use for Shooting type
8
Scost
Number
Use for Shooting cost
9
Mixing
Number
Use for Order mixing
10
Stotal
number
Use for Total amount
11
Shooting Hours
Text
Use for Shooting hours 23
PHOTO-SHOP MANAGEMENT
Photo Information:
24
PHOTO-SHOP MANAGEMENT
Sr. No
Field Name
DataTyp
Description
e
1
Photo_no
Number
Use for serial no only
2
P_code
Text
Use for P_Order code
3
P_Date
Date&time
Use for P_Order date
4
P_name
Number
Use for P_Order name
5
P_add
Date&Time
Use for P_order address
6
P_tamt
Number
Use for Total amount
7
P_pamt
number
Use for Paid amount
8
P_bal
number
Use for Balance
9
P_odate
Date&time
Use for P -orderdate
10
P_
number
Use for P_order
11
P_ddate
Date&time
Use forP-Duedate
25
PHOTO-SHOP MANAGEMENT
Photo Detail: Sr. No
Field Name
DataTyp
Description
e
1
Photo_no
Number
Use for serial no only
2
Size
Text
Use for Photo size
3
Ptype
Text
Use for Photo type
4
Pcost
Number
Use for Photo cost
5
Quantity
Number
Use for photo Quantity
6
Ptotal
Number
Use for Total amount
26
PHOTO-SHOP MANAGEMENT
Shooting Information: Sr. No
Field Name
DataTyp
Description
e
1
Shooting_no
Number
Use for serial no only
2
S_code
Text
Use for S_Order code
3
S_Date
Date&time
Use forS_Order date
4
S_name
Number
Use for S_Order name
5
S_add
Date&Time
Use for S_order address
6
S_tamt
Number
Use for Total amount
7
S_pamt
number
Use for Paid amount
8
S_bal
number
Use for Balance
9
S_odate
Date&time
Use for S -orderdate
10
S_
number
Use for S_order
11
S_ddate
Date&time
Use forS-Duedate
27
PHOTO-SHOP MANAGEMENT
Shooting Detail: Sr. No
Field Name
DataTyp
Description
e
1
Shooting_no
Number
Use for serial no only
2
Size
Text
Use for Shooting size
3
Stype
Text
Use for Shooting type
4
Scost
Number
Use for Shooting cost
5
Quantity
Number
Use for Shooting Quantity
6
Stotal
Number
Use for Total amount
28
PHOTO-SHOP MANAGEMENT
Purchase Information: Sr.N o.
Field Name
Data Type
Description
1
P_Id
Number
Use for serial no only
2
Dealer_code
Text
Use for Dealer code
3
Dealer_name
Text
Use for Dealer name
4
Dealer_conta ct
Number
Use for Dealer
5
Dealer_Addre ss
Text
Use for Dealer Address
6
Date
Date&time
Use for Purchase date
7
Total
Number
Use for Purchase total
29
PHOTO-SHOP MANAGEMENT
Purchase Detail: Sr. No
Field Name
DataTyp
Description
e
1
P_Id
Number
Use for serial no only
2
I_name
Text
Use for Item name
3
Cost
Text
Use for Item cost
4
Qty
Number
Use for Item quantity
5
Total
Number
Use for Total amount
30
PHOTO-SHOP MANAGEMENT
Report no
Name Of Report
1
Item Information
2
Customer Information
3
Dealer Information
4
Purchase Information
REPORT LIST
31
PHOTO-SHOP MANAGEMENT
CODING CONVENTION SR. NO. 1
FORM frm item detail
CONNECTION 1
Cn
connection
2
Rs
Recordset
2
frm customer detail
1
Rs
Recordset
3
frm dealer detail
1
Cn
connection
2
Rs
Recordset
4
frm lab detail
1
Rs
Recordset
5
frm purchase Order
1
Cn
connection
2
Rs
Recordset
DESCRIPTION To Create connection with ADODB . To create Recordset with ADODB. To create Recordset with ADODB. To create Connection with ADODB. To create Recordset with ADODB. To create Recordset with ADODB To create Connection with ADODB To create Recordset with ADODB.
32
Related Documents c2h70
Photoshop Management System(part 2) e4v68
November 2021 0
Tutorial Photoshop 2 703q4u
March 2021 0
Photoshop 2r132
February 2021 0
Photoshop 2r132
May 2020 6
Photoshop 2r132
April 2023 0
Photoshop 2r132
May 2020 29More Documents from "Sourabh Hebbar" 196f5g
Photoshop Management System(part 2) e4v68
November 2021 0
Employee Empowerment Questionnaire 5s4p44
October 2019 124
Design Of Chimney 494v43
October 2019 48
Jiet Btech Report Template Final 6h6f3z
November 2019 34
Three Level Architecture Of Database System 6f2l21
December 2019 30