a project presentation on item auction information system prepared by :- guided by :- patel...
TRANSCRIPT
Slide 1
A Project Presentation On Item Auction Information System Prepared By :- Guided By :- Patel Neeki(13034212058) Dr. J . N . DHARVA Patel Shraddha(13034212075) Group No:- 30
Acharya Motibhai Patel Institute of Computer Studies(Constituent College of Ganpat University)Ganpat Vidyanagar -384012
Object ContentProject TitleItem Auction Information SystemObjectiveThe aim of this system is to provide a better online auction through website for 24X7 with more facilities at any place any time with effective functionality to the user.Front EndPHP 5.3.5Back EndMYSQL 5.5.8ServerApache 2.2.17ToolsMicromedia Dreamviewer CS6,Notepad++Internal Guide Dr J.N.DharvaGroup No30Project ProfileRequirement Specification
Problem Statement .There is no multi bidding facility for user..The problem with public auction is that the participation of the general public is very limited..This public auction is managed manually and involves lot of paper work..Most online Auction website are difficult to understand by user
Need For New System *The products should have a profile that shows the details.
* Paperless Auction System.
* Advance Search:-Account to category wise User can search for product.
* We provide multi_bidding option into our site. So that user can do multiple bidding on a specific product. Functional SpecificationAdmin :- LoginManage the UserManage the AdvertiesManage the ProductManage the Product categoryLogoutUser :- Registration LoginEdit own ProfileChange the PasswordManage ProductManage Product GalleryProduct Bidding Give FeedbackLogout
Server side Hardware Processor2.0GHZRAM2GBHDD3.5GB free space in hard disk SoftwareBack End ToolsMySql5.5.8Front EndPHP 5.3.5Oprating SystemLinux/Unix server O.S other equivalentHardware & SoftwareRequirementClient Side HardwareSoftwareProcessor
1.6GHZRAM
512MBHDD
1GB free space in hard disk.Oprating System
Windows XP or equivalent OSBrowser
Internal Explorer 6.0 OR Compatible Browser8
New UserRegistered UserNoIs ValidYesUserAdminActivity DiagramUse-Case DiagramLoginRegistrationView Product Give feedbackLogoutAddEditDeleteUpdate
User
Product Bid Change Password Give bid Manage User Admin LoginManage ProductLogoutManage CategoryManage AdvertisementAddVerify ProductEditDeleteVerify UserUpdate
Edit
Delete
E-R Diagram
Table Name:- adminData DictionaryDescription:- This table is store admin informationPrimary Key:-admin_idField NameData TypeSizeConstraintsDescriptionControl NameValidationadmin_idint11Primary keyDefine id -
Not Null & numeric valueusernamevarchar20NotNullName of theUserTextbox
Not Null passwordVarchar15NotNullDefine password
Textbox
min & max 8 to15 Characteremailvarchar30NotNullDefine email Textbox
Valid [email protected]:- Table Name:- user Description:- This table is store user informationPrimary Key:- user_idField Name
Data Type
SizeConstraints
Description
ControlNameValidationuser_idint11primary key
Define idTextboxNot Null & numeric valuefirstnamevarchar20NotNullDefine first nameTextboxNot Nulllastnamevarchar20NotNullDefine last nameTextboxNot Nullpasswordvarchar15NotNullDefine passwordTextboxNot Nulladdresstext 25NotNullDefine addressTextarea
Not Nullphonevarchar15NotNullDefine phoneTextboxNot Null7emailvarchar30NotNullDefine emailTextboxValid Email
8gendervarchar1NotNullDefine genderRadio ButtonNot Null9cityvarchar10NotNullDefine cityTextboxNot Null10statevarchar10NotNullDefine stateTextboxNot Null11descriptiontext-NotNullDefine descriptionTextareaNot Null12datedate-NotNullDefine dateTextboxNot Null13statusenum-NotNullDefine statusTextboxNot NullUser_idFirstname
PasswordEmail
Gender
MaleActiveLogin details ofUser.Example:-Table Name:- product_category Description:- This table is store product_category informationPrimary Key:- product_category_idField Name
Data Type
SizeConstraints
Description
ControlNameValidationpro_cat_id
int11primary key
Define idTextboxNot Null & numeric valuenamevarchar20NotNullDefine nameTextboxNot NullimageVarchar30NotNullDefine imagefileJpg, png, jifdescriptiontext-NotNullDefine descriptionTextareaNot NullSr.NoPro_cat_id
Name
ImageDescription
11MobileMobile pro.jpgDetail of mobile22T.VLCD-TV.jpgDetail of T.VExample:-Table Name:- product Description:- This table is store product informationPrimary Key:- product_idForeign Key:-user_id, product_category_idField Name
Data Type
SizeConstraints
Description
ControlName Validationproduct_id
int11primary key
Define idTextboxNot Null & numeric valueuser_idint11foreign key
Define user idTextbox
Not Nullpro_cat_idint11foreign key
Define product category idTextbox
Not Nullproduct_namevarchar20NotNullDefine product nameTextbox
Not Nullimagevarchar30NotNullDefine imageFileJpg, png, jifprice
varchar15
NotNullDefine priceTextbox
Not Nullbid_start_datedate-NotNullDefine bid start dateTextboxNot Nullbid_end_datedate-NotNullDefine bid end dateTextboxNot Nulldescriptiontext-NotNullDefine descriptionTextareaNot Nullisvarifiedenum-NotNullDefine isvarifiedTextboxNot Nulldatedate-NotNullDefine dateTextboxNot NullProduct_id
User_idPro_cat_id
Product_name
Price
StatusDate123Samsung
12000Sold20-9-14Example:-21Table Name:- product_imagesDescription:- This table is store product_images informationPrimary Key:- product_image_idForeign Key:-user_id, product_idField Name
Data Type
Size
Constraints
Description
ControlNameValidationProduct_image_idint11primary key
Define idTextboxNot Null & numeric valueuser_idint11foreign key
Define user idTextboxNot Nullproduct_id
int11foreign key
Define product idTextboxNot Nulltitlevarchar10NotNullDefine titleTextboxNot Nullimagevarchar30NotNullDefine imagefileJpg, png, jif
descriptiontext-NotNullDefine desTextareaNot NullProduct_images_id
user_id
product_idtitle
imagedescription233hiiiiii
Desert.jpg
Nice one
Example:-Table Name:- feedback Description:- This table is store feedback detailsPrimary Key:- feedback_idForeign Key:-user_id, product_idField Name
Data Type
SizeConstraints
Description
ControlNameValidationfeedback_id
int11primary key
Define idTextboxNot Null &Numeric value
user_id
int11foreign key
Define user idTextboxNot Null
product_id
int11foreign key
Define product idTextboxNot Null messagetext20NotNullDefine messageTextareaNot Nullpost_datedate-NotNullDefine post dateTextboxNot Nullfeedback_id
user_id
product_idmessage
post_date
4
211hiiiiiii
2-8-2014Example:-Table Name:- auction Description:- This table is store Auction detailsPrimary Key:-auction_idForeign Key:-user_id, product_idField Name
Data TypeSizeConstraints
DescriptionControlNameValidationauction_idint11primary keyDefine idTextboxNot Null &Numeric value
user_idint11foreign keyDefine user idTextbox
Not Nullproduct_idInt11foreign key
Define product idTextbox
Not Nullpricevarchar15NotNullDefine priceTextbox
Not Nullbid_datedate-NotNullDefine bid dateTextboxNot Nullauction_id
user_id
product_idprice
bid_date
1210120008-12-2014
Example:-Table Name:- auction_master Description:- This table is store auction_master detailsPrimary Key:-auction_master_idForeign Key:-user_id, product_idField Name
Data Type
SizeConstraints
Description
ControlNameValidationauction_master_id
int11primary key
Define idTextboxNot Null &Numeric value
user_id
int11foreign key
Define user idTextboxNot Nullproduct_id
int11foreign key
Define product idTextboxNot Nullsale_datedate-NotNullDefine sale dateTextboxNot Nulldescriptiontext -NotNullDefine descriptionTextareaNot Nullauction_id
user_id
product_idsale_date
121010-11-2014
Example:-Table Name:- advertise Description:- This table is store Advertise informationPrimary Key:-adv_idField Name
Data TypeSizeConstraints
Description
ControlValidationadv_idint11Primary keyDefine idTextboxNot Null &Numeric valuetitlevarchar10NotNullDefine title TextboxNot Nullimagevarchar30NotNullDefine imageFileJpg, jif, pngclient_namevarchar20NotNullDefine client nameTextboxNot Null
client_mobilevarchar15NotNullDefine client mobileTextboxCharacter not allowstart_datedate-NotNullDefine start dateTextboxNot Nullexapiry_datedate-NotNullDefine exapiry dateTextboxNot Nulldescriptiontext50NotNullDefine descriptionTextareaNot NullExample:-adv_id
titleimageclient_name
start_dateexpiry_date3hiiiiisamsung2.jpg
nirja21-10-201431-10-2014
Sequence Diagram
Class DiagramLoginAdmin1.Login User2.Manage UserProduct_category3.Manage Product_categoryProduct4.Verify ProductAdvertise5. Manage AdvertiseCollaboration DiagramAdminUserReg.1.Reg.2.LoginLogin Profile3. Edit Profile Password4.Change PasswordProduct_category5.View CategoryProduct _gallery
6.View ProductFeedback7.View FeedbackBid8.Manage bidUserInput/output
*Home PageDescription: - This Page Is Show Information Of Auction Home Page.*About Us PageDescription: - This Page Is Show Information Of About An Auction.
*Product Category PageDescription: - This Page Is Show Information Of Product Category.
*Contact Us PageDescription: - This Page is Show Information of a Contact Us.
*Registration PageDescription: - This Page Is Show Information Of A Registration.
*Dashboard PageDescription: - This Page Is Show Information Of A Dashboard.
*Profile Edit PageDescription: - This Page Is Show Information Of A Profile Editing.
*Password Change Page Description: - This Page Is Show Information Of A Change Password.
*Add New Product PageDescription: - This Page is Show Information of an Add New Product.
* Product List PageDescription: - This Page is Show Information of a Product List.
*Product Bid PageDescription: - This Page is Show Information of a Product Bid.
*Feedback PageDescription: - This Page is Show Information of a Feedback.Admin*Admin Login Page
Description: - This Page is Show Information of a Admin login.*Add new product Category Page Description: - This Page is Show Information of an Add New Product Category.
*Add new product Page Description: - This Page is Show Information of an Add New Product.
*User Add page Description: - This Page is Show Information of an Add User.
*Add new AdvertisesDescription: - This Page is Show Information of an Add New Advertisement.
TestingUnit Testing:- Unit testing is the smallest unit of software design the software component or module such as. Creating new user or user login process code written by user is correct or not.Constrains Testing:- If tests whether all the specified constrains are satisfied or not? for e.g. Memory limit should always be greater than maximum upload size. Black box Testing:- This is also called functional testing. Boundary:-test cases generated using extremes of input domains. Integration Testing:- All the major modules developed separately where integrated & then testing was carried out. This testing checks whether all the modules have been correctly and properly integrated to give correct results. No Test case Input Expected Result Actual Result Status 1New Product Insert New product add with validation Record insert into database Expected out put Successful2ValidationUser email id, bid price, valid date Proper Validations should be placed to program Expected out put Successful3Database Field & Size All the table fields & size Field size is proper Expected out put Successful4Delete Product Delete product if product sold Record delete if not further use Expected out put Successful5Update Product User can update product price Update product price in product table Expected out put SuccessfulFuture EnhancementIn future we will add online payment system.
In future we will add sums functionality.
In future we will add upload pdf document videos of product. Bibliography/References Books Referred:- * PHP6 and MYSQL6 Bible by Steve Suehring,Time Converser, Joyce Park
* PHP Cookbook by David scalar, Adam Trachtenberg.
Reference:-
*www.tutorialpoint.com
*www.w3school.com/php
AMPICS Khushbu Patel,Pinaj PatelMulti Level Marketing(MLM)