E-Commerce Super SolutionsIntroduction to the ProjectSlide 3The Programming ProcessDatabase StructureAdministrative InterfaceThe Website StructureCustomer InterfaceWarehouse InterfaceThank you for your time!E-Commerce Super E-Commerce Super SolutionsSolutionsE. Christopher CaynorE. Christopher CaynorJesse MusgroveJesse MusgroveTyler SigleyTyler SigleyEmerson SklarEmerson SklarIntroduction to the ProjectIntroduction to the ProjectWe are building an e-commerce solution We are building an e-commerce solution for a West Virginia University Bookstore for a West Virginia University Bookstore partner.partner.This site will allow users to browse This site will allow users to browse products, see what is required by their products, see what is required by their class, and order these products online.class, and order these products online.The backend to this website will be server-The backend to this website will be server-based and allow for a variety of functions based and allow for a variety of functions by the Sales and Warehouse by the Sales and Warehouse Administrators.Administrators.The database is the central repository for The database is the central repository for all information used by the company.all information used by the company.The company will track sales, track The company will track sales, track inventory, and update the information for inventory, and update the information for each product.each product.The website will effectively just allow users The website will effectively just allow users to view this information, the only to view this information, the only information it will process will be the billing information it will process will be the billing order.order.The Programming ProcessThe Programming ProcessWe are using a data-centered architecture We are using a data-centered architecture in our system. This can best be seen in in our system. This can best be seen in the following graph.the following graph.Database StructureDatabase StructureSalesItemPK salesid quantityinstock new coursenumbers ordercost restock feedbackids warehouseids isbn priceCustomerAccountPK customerid customername creditcardnum creditcardexp billingaddress phonenumberFK1 cartid restocktitles email pendingorderids pastorderids feedbackids mailingaddress creditcardtypeFeedbackPK feedbackidFK1 customerid information ratingWarehouseStatisticsPK warehouseid pendingorders statusreport contactphone contactaddressOrderInformationPK orderidFK1 customerid orderdate shippingdate orderstatus comments trackingnumbers itemidsShoppingCartPK cartidFK1 customerid itemidsBookPK isbn itemname author edition copyright publisherFK1 salesidAdministrative InterfaceAdministrative InterfaceThe Website StructureThe Website StructureCustomer InterfaceCustomer InterfaceWarehouse InterfaceWarehouse InterfaceThank you for your time!Thank you for your time!Please ask any questions at this time!Please ask any questions at this time!We appreciate your patience and interest We appreciate your patience and interest during our presentation.during our
View Full Document