1 / 21

DESIGNED BY AMIT KUMAR DUTTA(0405071) FAHIAN AHMED(0405072)

ONLINE BOOK SHOP MANAGEMENT. DESIGNED BY AMIT KUMAR DUTTA(0405071) FAHIAN AHMED(0405072). ABSTRACT. This project is about management of book shops online. Online book shop system handles most of the functionality present in a real world online shop.

aphrodite-stephenson
Download Presentation

DESIGNED BY AMIT KUMAR DUTTA(0405071) FAHIAN AHMED(0405072)

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. ONLINE BOOK SHOP MANAGEMENT DESIGNED BY AMIT KUMAR DUTTA(0405071) FAHIAN AHMED(0405072)

  2. ABSTRACT • This project is about management of book shops online. • Online book shop system handles most of the functionality present in a real world online shop. • This project is aimed to provide scopes to the book stores of our country to maintain, advertise and sell books online.

  3. FUNCTIONAL OVERVIEW • CUSTOMER FUNCTIONS • MANAGER FUNCTIONS

  4. CUSTOMER FUNCTIONS • Login first. (Needs registration). • Can select any branch of the shop. • Can select any number of books into cart. • Remove books from cart before submitting order (if necessary) . • Cash On Delivery system.

  5. CUSTOMER FUNCTIONS ISBN • SEARCHING TITLE CAN SEARCH BOOKS BY AUTHOR PUBLISHER CATEGORY

  6. MANAGER FUNCTION • Manager controls all the branches of the shop. • Needs to login with manager account to configure database. • Can insert,delete,update database. • Can process and cancel orders ordered by customer • Can compute profit and loss between any time interval. • Can give special offers ,discounts etc.

  7. SPECIAL FEATURE • Customer can share their views. • Can order for books that are currently not available at the book shop. • Manager can reply. COMMUNICATION CORNER

  8. The proposed project is presented with E-R diagram, Entity sets and Schemas in following section

  9. ENTITY SETS Title Author id Name ISBN Publisher id BOOK AUTHOR Category Price Edition

  10. ENTITY SETS(CONT.) ISBN Author id Publisher id Name WRITTEN BY PUBLISHER

  11. ENTITY SETS(CONT.) ISBN Shop id Shop name Shop id Entry id SHOP ENTRY INFO Date Address Phn no Quantity

  12. ENTITY SETS(CONT.) ISBN Shop id Price STOCK Total disposed Entry date Total entry

  13. ENTITY SETS(CONT.) Customer id Address Shop id Dispose id DISPOSE OF CUSTOMER Customer id Name ISBN Phn no Password Dispose date

  14. ENTITY SETS(CONT.) Shop id ISBN Order id Customer id ORDER BOOK ORDER Order id Price Quantity

  15. ENTITY SETS(CONT.) Message id Manager comment Customer comment MESSAGE

  16. ENTITY SETS(CONT.) CUSTOMERID TOTALBOOKS CUSTOMERID TOTALBOOKS ORDER PROCESSED ORDER CANCELLED TOTALPRICE TOTALPRICE

  17. Author id E-R DIAGRAM Customer id Author Writtenby ISBN Customer Shop id Order id Stock Order book Order by Book Shop Published by Order Disposed by Entry by Publisher Entry info Dispose of Publisher id Disposed no Entry no

  18. E-R DIAGRAM ORDER MESSEGE ISA MESSEGEID ORDER PROCESSED ORDER CANCELLED

  19. All schemas at a glance :: • 1.book(isbn,publisherid(fk),title,category,price,edition) • 2.author(authorid,name) • 3.writtenby(isbn(fk),authorid(fk)) • 4.publisher(publisherid,name) • 5.shop(shopid,shopname,address,phone) • 6.stock(shopid(pk,fk),isbn(pk,fk),price,totalentry,entrydate,totaldisposed) • 7.entryinfo(shopid(pk,fk),isbn(pk,fk),entryid(pk),date,quantity) • 8.disposeinfo(shopid(pk,fk),isbn(pk,fk),disid(pk),customerid,disdate) • 9.customer(id,pass,name,address,phone) • 10.order(orderid,customerid) • 11.orderbook(shopid(pk,fk),isbn(pk,fk),orderid,quantity,price) • 12.orderprocessed(customerid,totalbooks,totalprice) • 13.ordercancelled(customerid,totalbooks,totalprice) • 14.message(messageid,customercomment,managercomment)

  20. TECHNICAL OVERVIEW ORACLE9i BACKEND ASP.NET WITH C# FRONTEND

  21. Concluding Remarks: • We will try our level best to implement the project in due time. THANK YOU

More Related