School
*We aren't endorsed by this school
Assignment Type
Subject
Uploaded by Malaysia Assignment Help
Date
Case Study:
APU’s E-Bookstore
The availability of books and reading material for purchase within the Asia Pacific University (APU) is quite inadequate. Although the APU library has a vast collection of books (both hardcopy and e-books), its availability it is quite limited and bound by many restrictions. Students and staff only have the option of a small bookshop within the enterprise. Larger books stores in the city are often sought for other varieties.
In view of the growing population within APU, the university is planning to establish an ebookstore. The online store will facilitate the purchase of latest books of many genres. Your team is assigned the project to design and implement a database system for online APU’s eBookstore System.
Scenario:
• Publishers frequently send lists of latest books to the e-bookstore manager. The bookstore manager compiles a list of needed books and sends an order to the publishers. The publisher supplies the ordered books to the university. The bookstore manager records the details of the order and books that have arrived at the bookstore. The orders sent to publishers need to be recorded in the database
• Customers, who wish to purchase books online, need to initially register as members. Members will be able to view the book, read reviews and compare the online products with other similar ones.
• Members who wish to purchase can select their books into the website’s shopping cart. The cart will show the summary of the selection and total cost to be paid. Once the payment is made, the order is confirmed, the bookstore will send the books to the customers within 7 working days.
• The system should manage information about books in the bookstore, members and books they have ordered as well as payment details and delivery status.
• Members can also provide ‘rating’ for a book, as a score (1-10 which is 0= terrible, 10= masterpiece) along with optional short text comment. No changes are allowed; only one feedback per user per book is allowed.
Looking for reliable assignment writing service in Malaysia? Your search ends here! Our platform offers top-tier Coursework Writing Help tailored specifically for students in Malaysia. Whether it's delving into Database Systems or any other subject, our experts are here to assist. Malaysian students can confidently pay our professionals for comprehensive guidance throughout their courses. Rely on our expertise to enhance your academic journey. Connect with us today and experience unparalleled support!