ER Diagram of enterprise "Online Bookstore" Database
Import/Delete/Update book
information: Administrator needs to manage their book
list so customers can see latest list of books. (Related files: adminoptionbooks.php, bookinsert.php,
bookupdate.php, bookdelete.php,
book_delete1.php, book_update1.php)
Figure 1. Book Insert page
Figure 2. Book delete page
Figure 3 & 4. Book update pages.
Registering new member: deleting existing member, update member information. This is also required because user management is priority privilege for administrators. Admin can add/delete/update the users. (Related files: adminoptionmem.php, registration.php, memdelete.php, mem_delete1.php, memupdate.php, mem_update1.php)
Figure 5. Registration page
Figure 6. Member delete
page
Figure 7. Member information update
Creating new order: deleting existing order, update order information based on id and order number. Admin also needs management access to orders, because sometimes it needs to be modified. (Related files: adminoptionorder.php, orderinsert.php, order_insert1.php, orderdelete.php, order_delete1.php, order_delete2.php, orderupdate.php, order_update1.php, order_update2.php)
Figure 8. Order
Creation
Figure 9. Order delete
Updating Order_Detail table: This is required for admin (also users) because there are some times admin need to make changes on order details. (Related files: adminoptionorderdet.php, orderdetail.php)
Figure 10. Order_detail
update page
Search list of books using course numbers: Students can find their course books easily. (Related files: course.php, book_recommandation.php)
Figure 11. Book search with course
Advanced query tab provides two searches: one is to search people who spent over certain amount (user input), and other is to purchased book based on shipped state and credit card type. These queries can be used to keep user interests based on the price and location. (Related files: search.php, search1.php, search2.php, search2_1.php, search3.php, search3_1.php)
Figure 12. Advanced Query page
Figure 13. First advanced query page
Figure 14. Second advanced query page
Figure 15. Third advanced query page (Search what items are in cart of people who made a purchase before)