PROJECT PRESENTATION ON Submitted To Department of Computer Science Ganpat University, Kherva. Submitted by Nikul Patel (Exam No.13084231158) Nitin Patel (Exam No.13084231162) 1 Project Profile Project Title Online Jewellery Shopping Objective A Jewellery Shopping is an web Application where the User can register themselves and online Purchase Jewellery item main Objective of this system is maintaining the Jewellery Products online and also provide online payment facility to customer. Type of Application Web Based Application Front End Tool ASP. Net with C# (.NET Framework 4.0)- 2010 Back End Tool Microsoft SQL Server 2008 Other Tools MS Office 2007 , Crystal report,photoshop,flash8. Internal Guide Komal H Patel Submitted To Department of computer Science, Ganpat University. Developed By 1) Patel Nikul 2)Patel Nitin Existing System As the current system is totally manual. Jewellery shop has a manual work on the paper. Existing system is manually, So it increase the chances of errors. Lots of the time consumed for each report generation. Immediate response to the query’s is difficult. More stationary use so they are expensive. Manual system are takes more time. 3 Need For New System System can ganerate immediately getting the data , and report. Avoid Stationary expense. New system provide online payment facility Any record is easy to store and manage. Easy to solve customer query. Provide Better security in new system. Give the feedback answer. Easy to Jewellery purchase. 4 Functional Specification Admin Manage user and Admin Accounts. Admin can Manage Jewellery For User Requirment. Update Jewellery icon and design on site. Send email and text message for new offer. Admin can Generate bill. Admin can View Feedback. Admin Generate category wise report. 5 User Search various Jewellery item. User can View and Select Jewellery product User can make purchase jewellery item. User can select and Order Jewellery product. Payment option by invoice, credit/debit card. User can give the feedback. 6 Hardware & Software Requirement Server Side Minimum Hardware Requirements Processor 2.0 GHz Hard Disk 50 GB Free Space RAM 2GB Minimum Software Requirements Operating System Windows Server 2003 Web Server IIS 6.0 Front-End Tool ASP. Net with C# (.NET Framework 4.0) 2010 Back-End Tool Microsoft SQL Server 2008 Other Tools Adobe Photoshop 6.0, MS Office 2007 , Crystal report,flash8. 7 Client Side Minimum Hardware Requirements Processor 1.0 GHz Hard Disk 2 GB Free Space RAM 1GB Minimum Software Requirements Operating System Windows XP or Any Compatible Operating System. Web Browser Internet Explorer 6.0 or Any Compatible Browser 8 System Flowchart . Start If Registered No Registration Yes No Username/ Password IS Valid Yes Yes IS Admin A No B 9 A B Manage User search item Product Manage/update view/Select item Send Email/Message Purchase item Calculate bill Online Payment View Feedback Give feedback Generate Report logout End 10 90 Days Development Phase 1 to 15 Days 16 to 30 Days 31 to 45 Days 46 to 60 Days 61 to 75 Days 76 to 90 Days Duration (Days) Requirements Gathering 1-15 (15days) Analysis 16-40 (25days) Design 31-70 (40days) Coding 31-80 (50days) Testing 50-85 (35days) Implementation & Deployment Documentation Total Time (Days) 76-90 (15days) 15-90 (75 days) 90days ENTITY RELATIONSHIP DIAGRAM password E-R Diagram User_Id Manage M 1 View User M M 1 1 Admin_Id M M 1 Password Pay M Gives Search Gives M Search Jewellery Order Payment View M Order_id name User_Id Belongs to Product name M M Name Feedback M Product_id product M Feedback_Id Product Name manage manage Admin 1 1 1 USE CASE DIAGRAM Admin Login User manage Product Manage Send Email / Message Admin Calculate Bill View Feedback Generate Report User Registration Login Search Item Select Item Purchase Item Online Payment User Email / Message Give Feedback Logout Activity Diagram Admin . Login Invalid Valid . Product manage . Send mail/message . calculateBill . Logout . View Feedback . GenerateReport User . Registration Invalid Registration Valid . Login Invalid Valid . Search item . View/select item Purchase item . Logout . Online payment . Give feedback CLASS DIAGRAM Admin SEQUENCE DIAGRAM A:Admin S:System Login Successfully Login Update Profile Response Profile Db:Database Request for Login Response for Login Manage Profile Update Profile Update Jewellery Detail Manage Jewellery Detail Successfully Detail Update Update Jewellery Detail Manage User Update User Successfully Update User Send Email/Message Successfully send Email/Message Generate Reports Generate Reports detail Logout Logout Successfully Update User Request for Email/Message Response Email/Message Request for Reports Returns Request data User U:User Db:Database S:System Registration Successfully registration Login Successfully Login Add Profile Response Profile Search Jewellery item Response Jewellary item Purchase Jewellery Response Jewellery Parchage Online Payment Response for Payment Giva Feedback Response Feedback Logout Logout Successfully Request for Registration Response for Registration Request for Login Response for Login Manage Profile Update Profile Search Jewellery item Update Jewellary item Request for Jewellery Purchase Response for Jewellery Manage Payment Update Payment Detail Request Feedback Response for Feedback COLLABORATION DIAGRAM Admin 1:1:Request for Login 2:1:Manage Profile 3:1:Request Jewellery Detail 4:1:Manage User 5:1:Request for Email/Message 6:1:Request for Reports S:System 1:Login 2:Update Profile 3:Update Jewellery Detail 4:Update User 5:Send Email/Message 6:Ganarate Report 7:Logout Db:Database 1:1:1:Response for Login 2:1:1:Update Profile 3:1:1:Update Jewellery Detail 1:1:1:1:Login Successfully 4:1:1:Update User 2:1:1:1:Response Profile 5:1:1:Response 3:1:1:1:Successfully Jewellery Detail Email/Message update 6:1:1:Returns Request Data 4:1:1:1:Successfully Update User 5:1:1:1:Successfuuly Send Email/Message 6:1:1:1:Generate Reports 7:1:Logout Successfully A:Admin User 1:1:Request for Registration 2:1:Request for Login 3:1:Manage Profile 4:1:Search Jewellery item 5:1:Request for Jewellery Purchase 6:1:manage Payment 7:1:Request Feedback S:System 1:Registration 2:Login 3:Add Profile 4:Search Jewellery Item 5:Purchase Jewellery 6:Online Payment 7:Give Feedback 8:Logout 1:1:1:1:Registration Successfully 2:1:1:1:Login Successfully 3:1:1:1:Response Profile 4:1:1:1:Response Jewellery item 5:1:1:1:Response Jewellery Purchage 6:1:1:1:Response For Payment 7:1:1:1:Reponse Feedback 8:1:Logout Successfully U:User Db:Database 1:1:1:Response for Registration 2:1:1:Response for Login 3:1:1:Update Profile 4:1:1:Update Jewellery item 5:1:1:Response for Jewellery 6:1:1:Update Payment Detail 7:1:1:Response for Feedback data dictionary ADMIN LOGIN •Table name :- Admin login •Description :- Table is use to store admin login information •Primary key :- User_Name Sr.No Fields Name Data Type Size Constraints 1 User_name Varchar 30 Primary key 2 Password Varchar 20 Not Null Description It is Store Admin name It is Store Admin password REGISTRATION •Table name :- Registration •Description :- Table is use to store registration information •Primary key :- User _id • Foreign Key:- City, State, Country Sr.No Fields Name 1 User_id 2 First_name Data Type Size Int 25 Varchar 30 Constraints Primary key Not Null Description It is Store Unique user id It is Store Firstname of User 3 4 5 6 7 8 9 10 11 12 13 14 15 Last_name User_name Password Email Gender Date-Of-Birth Address City Pincode State Country Mobile_number Security_question Varchar Varchar Varchar Varchar Varchar Datetime Varchar Varchar Int Varchar Varchar Int Varchar 20 30 20 20 6 MAX 30 6 30 20 12 MAX Not Null Unique Id Not Null Not Null Not Null Not Null Not Null Foreign Key Not Null Foreign Key Foreign Key Not Null Not Null It is Store Lastname of User It is Store Choose Username It is Store Choose Password It is Store Emailid of user It is Store Gender of user It is Store Birthdate of User It is Store Address of user Referance from City Table It is Store Pincode of user Referance from State Table Referance from Country Table It is Store Mobile no of user It is Store Select security question 16 Security_answer Varchar MAX Not Null It is Store Select security answer PRODUCT_MASTER •Table Name: Product _Master •Description: Table is use to store Product information •Primary Key: Product_id •Foreign Key: Category_id Sr.No Fields Name Data Type Size Constraints Description 1 Product_id Int 10 Primary Key It is Store Unique Productid 2 Category_id Int 20 Foreign Key Referance from Category Table 3 Product_name Varchar 30 Not Null It is Store Name of Product 4 Product_material Varchar 20 Not Null It is Store Material of Product 5 Product_Price Varchar 20 Not Null It is Store Price of Product 6 Product_carat Varchar 20 Not Null It is Store Carat of Product 7 Product_image Varchar 50 Not Null It is Store Image of Product Path 8 Product_detail Varchar MAX Not Null It is Store Detail of Product 9 Product_weight Decimal 5,2 Not Null It is Store Weight of Product ORDER •Table Name: Order •Description: Table is use to store user oder information •Primary Key: Order_id •Foreign Key: Product_id Sr.No Fields Name 1 Order_id 2 Data Type Size Constraints Description Int 10 Primary Key It is Store Unique Order id User_id Int 10 Foreign Key Referance from Registration Table 3 Product_Id Int 10 Foreign Key Referance from Product Table 4 Order_No Int 20 Not Null It is Store order no 5 Quantity Int 5 Not Null It is Store Quantity of Product 6 Servicetax Decimal 5,2 Not Null It is Store Servicetax of Product 7 Netprise Decimal 5,2 Not Null It is Store netprise of Product PAYMENT_MASTER •Table Description: Payment_master •Description: table is use store payment information •Primary Key: Bill_id •Foreign Key: User_id Sr.No Fields Name Data Type Size Constraints Description 1 Payment_Id Int 10 Primary Key It is Store Unique id 2 User_id Varchar 50 Foreign Key Referance from User Table 3 Address Varchar 50 Not Null It is Store Address of User 4 Subject Varchar 50 Not Null It is Store Subject of User 5 CardNo Int 14 Not Null 6 Amount Decimal 5,2 Not Null It is Store the Credit Card Number It is Store the Payment Amount 7 Message Varchar 50 Not Null It is Store Massage CATEGORY_INFO •Table Name: Category_Info •Description: table is use to store Category information •Primary Key: Category_id Sr.No Fields Name Data Type Size Constraints Description 1 Category_id int 10 Primary key It is Store category id 2 Category name Varchar 20 Not Null It is Store category name 29 COUNTRY_INFO •Table Name: Country_info •Description: table is use to store Country information •Primary key: Country_id Sr.No Fields Name Data Type Size Constraint Description s 1 Country_id Int 10 Primary key It is Store the country id 2 Country_name Varchar 20 Not Null It is Store the country name 30 STATE_INFO •Table Name: State •Description: table is use to store state information •Primary Key: State_id •Foreign Key: Contry_id Sr.No Fields Name Data Type Size Constraints Description 1 State_id Int 10 Primary key It is Store the state id 2 State_name Varchar 20 Not Null It is Store the state name 3 Country_id Int 11 Foreign key Referance from Contry Table 31 CITY_INFO •Description: table is use to store City information •Table Name: City •Primary key: City_id •Foreign Key: State_id Sr.No Fields Name Data Type Size Constraints Description 1 City_id Int 11 Primary key 2 City_Name Varchar 20 Not Null It represent the city name 3 State_id Int 11 Foreign key It represent the state name It represent the city id 32 FEEDBACK •Table name :- Feedback •Description :- table is use to store User Feedback information •Primary key :- customer _id •Foreign Key: User_id Sr.No Fields Name Data Type Size Constraints Description 1 Feedback_id Int 10 Primary key It is Store Unique Clientid 2 User_id Int 10 Foreign Key Referance from User Table 3 Comment Varchar 60 Not Null It is Store Comment of Client INPUT DESIGN HOME Description:-This is a Home page for all User. 34 ADMIN_LOGIN Description:-Admin can login here. 35 FORGET PASSWORD Description:-Send a temporary password to through email. 36 CHANGE PASSWORD Description:-user can change password. 37 MANAGE USER Description:-Admin can manage user account. PRODUCT_MANAGE Description:-Admin can manage product. PRODUCT_MANAGE Description:-Admin can manage product UPDATE_PRODUCT Description:-Admin can update product. SEND E-MAIL Description:-Admin can send mail to user. REGISTRATION Description:-User can Ragistration. USER_LOGIN Description:- User can login if register. SEARCH ITEM Description:-User can search item. VIEW PRODUCT Description:-User can view product in this page. PROUDUCT DETAIL Description:-User can view product detail. PERSONAL PRODUCT DETAIL Description:-User can view personal product detail PURCHASE ITEM Description:-User can purchase item. PAYMENT INQURY Description:-User can pay payment online. FEEDBACK Description:-User can give Feedback. CONTACT US Description:-User can view contact detail ABOUT US Description:-User can view detail about page. OUTPUT DESIGN PAYMENT DETAIL Description:-view payment detail. 54 BILL REPORT Description:-view bill report detail. ORDER REPORT Description:-view order report detail. ORDER_DETAIL Description:-view order detail. TESTING No Test Case Case Type Excepted Output 1. Admin Login 1.Enter correct Login to the system should Username be try with the login and Password assigned by the admin and the correct password Actual Output Pass / Fail Login should be Pass successful and the user should enter into the system 2.Enter wrong The System give an error Login should fail Pass Username or and denied from the Login. with an error password ‘Invalid Details’ 2. User Login 1.Enter correct Login should be allow and Login successfully Pass Username and user access the application. and user access the Password application. 2.Enter wrong The System give an error Login should fail Pass Username or and denied from the Login. with an error password ‘Invalid Details’ 3. Validation Test Requir_Field cases validation Regular format must be System give error to Pass required in control enter valid input 58 4 Admin Roll 1.Admin access Admin can View data Admin manage all information Pass and all the information of the system. of the site. 5. User Roll 1.User Registration User can register the Admin Confirm registration. Site. Pass 2.Manage Profile User can Profile. Pass 3. Payment User can pay a Purchase Appropriate Product. Pass Payment for Purchasing a Product. 4. Feedback User can Feedback. manage Edit Information. give a Give appropriate Message. Pass 59 POST IMPLEMENTATION REVIEW •Post implementation review is conducted by Users and Analyst. •To determine whether the system has met its objective, that is analysts, want to know if the performance level of Users has improved. If nothing is happening, one may question whether the system can be considered successful. • To evaluate the system, following questions are considered: How have the system changed the way in which operations are performed? How have system changed the completeness of the information? How have system changed the number of user? How have system changed the interaction between users? FUTURE ENHANCEMENT In the future I want to Enhanced my project with thee admin part of online jewellery shopping. Add more jewellery types in web-site. Try to all user contect with phone call. Add more features in site future. BIBLIOGRAPHY Books:1.ASP.NET With C#. Author:-ShyamN.Chavda. 2.The Complete Reference C# 3.0 Author:- Herbert schildt 3.GeorgeShepherd@Microsoft ASP.NET 4 Step by step Author:- George Shepherd Websites:www.shine.com www.tbz.com www.code-project.com www.jaweryandco.com www.tutorialpoint.com 63
© Copyright 2024