1 / 32

DB DESIGN

DB DESIGN. Module: Database and Web Assignment: Shulaptop Project Company Innosolution Co.,Ltd . DATABASE RELATIONSHIP. SELL, BUY, BASKET RATING, TOP10. POST SUPPORT. REQUEST NON-STOCK ITEM. CUSTOMER BEHAVIOR. BLOG. TOP 10 BEST SELLER. SELLER’S RATING. SHULAPTOP.

phil
Download Presentation

DB DESIGN

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DB DESIGN Module: Database and Web Assignment: Shulaptop Project Company Innosolution Co.,Ltd.

  2. DATABASE RELATIONSHIP SELL, BUY, BASKET RATING, TOP10 POST SUPPORT REQUEST NON-STOCK ITEM CUSTOMER BEHAVIOR BLOG

  3. TOP 10 BEST SELLER

  4. SELLER’S RATING

  5. SHULAPTOP Module: Database and Web Assignment: Shulaptop Project Company Innosolution Co.,Ltd.

  6. 1) MUST HAVE

  7. STUDENT FRIENDLY E-BUSINESS IMAGE (M1)INTERNET & COMMONLY USED BROWSER (M2) User Friendly Interface with Simple Menu Quick Search can helps user to search Laptop easily 2 1 The website can support many browser ex. Internet Explorer, Google Chrome and Firefox. 3

  8. REGISTER (M3)PASSWORD ACCESS (M4) Register User 1 Every page will redirect to login except to homepage, search and blog page. 5 Login 3 Logout 4 Faculty & Course to make statistic data in the future 2

  9. DETAILS OF FULL DESCRIPTION (M5) Buyer can compare Description Price Price Availability Condition Maker Specifications such as Memory, chip, clock speed 1 Buyer can search product easily. 2

  10. RESERVATION IN SHOPPING(M6)BASKET STYLE Go to reserved basket 1 Proceed Checkout 3 Buyer can add laptop into reserved basket 2

  11. RESERVATION IN SHOPPING (M6)BASKET STYLE (cont.) Complete Payment 4 Buyer get seller information 6 Fill Payment and Delivery Confirmation 5 Status will change to “SOLD”

  12. IN-STOCK ITEM WILL BE TREATED “SOLD” END TRANSACTION(M7) CHECKOUT PROCESS (BY PASS PAYMENT PROCESS) 1 Status Change to “SOLD” 2

  13. SEARCH PRODUCT EASILY (M8) QUICK SEARCH 1 SEARCH BY MODEL to check IN-STOCK QTY 3 SEARCH EVERY MACHINE 2 ALL IN-STOCK QTY Seller can search non-stock requested. 4

  14. TOP 10 BEST SELLER @ HOMEPAGE (M9) TOP 10 BY MODEL 1 Show at Home Page and admin can set Number of Top Selling How long to calculate ** Not implemented yet. 2

  15. 2) SHOULD HAVE

  16. EASY TO ADD DETAILS FOR SALES (S1) JUST 2 MIN TO REGISTER & POST SELL 1 Need to register & Login before post selling When Click “Post Sell” web will redirect to login page Fill Information 3 New User Has to Register 2 Upload Picture(s) 4

  17. SELLER RATING SYSTEM (S2) Average Rating shows at searching page 2 Buyer fills rating from 1-5 After Payment 1 • AVG Rating = sum rating point / no sold items • Excluded Rate “0” ( non-rating ) • Group by each seller

  18. IMAGE UPLOAD (S3) Show image when Preview Selling List or Search • UPLOAD IMAGE (Other pages) • Request & Answer Post-Support Page • Blog Upload Image when they are selling

  19. BROWSE & COMPARE (S4) BROWSE / SEARCH 1 COMPARE 2 3 Select to Compare Spec * Not implemented compare selected laptops

  20. AFTER SALES SERVICE (S5)E-MAILING AND PHONE NO 1 Buyer Send E-mail from System Seller Check E-mail and Go to Website to Post message 2 Telephone No’s Seller 4 3 Link to MS.Outlook Request Support by Seller Answer by Seller

  21. E-MARKETING (S6)& E-MAIL FOLLOW CUSTOMERLINK TO CUSTOMER PROFILE & SALES PRODUCT Admin can follow waiting list and reserved item in basket 5 Admin can search non-stock request to follow up customer 1 Admin choose status in basket 2 Customer profile Both e-mail & phone no 6 Send-mail by MS outlook Send e-mail from system Link to find similar spec to send e-mail to customer Link to check e-mail log sent by system or admin 3 4 8 7 *E-mail log & Find similar item are not implemented yet.

  22. E-MARKETING (S6)& E-MAIL FOLLOW CUSTOMERLINK TO CUSTOMER PROFILE& SALES PRODUCT Need to login as admin role based 1 4 Admin can follow by Microsoft Outlook 2 Admin can follow by sending e-mail from system (It will record in DB) Some user try to access admin’s webpage directly 5 3 If no has admin role, users cannot go the admin page directly

  23. HOMEPAGE DISPLAY IMAGE LINKED TO OTHER SITES (S7) Image is linked from Apple website 1 http://www.apple.com/macbookpro/images/overview_hero20110811.png 2 Link to Support Page of each laptop maker. Link to Sheffield Hallam 3 Image is linked from Dell website http://i.dell.com/images/global/products/latit/why_latit_banner_931x232.jpg

  24. When User Search on web, System will record the searching criteria to Database CUSTOMER PROFILES / MONITOING OF (S8)CUSTOMER BEHAVIORRecord Detail About Customer Behavior 1 Back Office Can Monitor by Crystal Report Software 2 4 Ex. Details of User’s behavior 3 Which Brand is Popular ? Can check by User 5 6 Can export to Excel

  25. 3)COULD HAVE

  26. BLOGGING / WIKI SYSTEM (C1)input data about particular machine Choose Model to preview or post blog User can search blog by each model Only registered user can post blog 3 2 1 4 Anonymous user can preview blog only

  27. WEBSITE DESIGN SHOULD (C2) INCORPORATE THE LASTEST SECURITY FEATURESACCESS TO CUSTOMER DETAIL WILL BE BY PASSWORD ACCESS ONLY Need to login as admin role based Every Menu except Home Page Search & Blog Preview Need to Login Firstly. 1 3 Try to type webpage directly 2 4 If no has admin role, users cannot go the admin page directly System will redirect to login page

  28. LAPTOP WANTED FACILITY(C3) Buyer can post to request non-stock and unavailable Laptop at the same page 3 1 Regarding non-stock item, user can link from search page to fill non-stock item. 2 When seller post mating laptop the system will check and send e-mail immediately

  29. REQUEST E-MAIL NOTIFICATION FOR NOT CURRENTLY FOR SALES(C4) Buyer can post unavailable Laptop 3 The site will send e-mail to prospected Customer when it is available 1 The E-mail can link to Required Laptop Item directly 4 When seller post mating laptop the system will check and send e-mail immediately 2

  30. PRICE NEGOTIATION (C5) Request Discount from Buyer at Basket Page Return Feedback by Seller 1 2

  31. WEEKLY REPORT (C6) 2 Best Selling Report • Fill date criteria • From Date • To Date • Number of Best Selling 1 Sale Volume and Income Report

  32. XML FEED INPUT-OUTPUT (C7) 1 Increase customer from other website by XML and Web Service 4 • Partner call web service using SOAP protocol and can use many developing technology. • Data from Web Service • XML on Web Service 2 3

More Related