37.9k views
2 votes
Mr. Alexandra, the manager of KIMEP Book Store (KBS), decides to computerize KBS’s Books Ordering and stock control system. A feasibility study has strongly suggested that a relational database system be installed. The details of KBS's Books procurement and stock control are as follows: Professors of IM often send "Requisitions-for-Text-Books" for their courses roughly two months before the beginning of their course. Each professor may send Zero, one or many requisitions. Each requisition contains request(s) for variable quantities of one or more text books from various publishers. KBS keeps a stock file showing for each book, edition and its publisher, the quantity in stock, and then place "Purchase-Order(s)-for Books" for fresh stock, if required. On arrival of these books, KBS updates its stock and sale those books to the students and raise "Invoice"/ "Bill-of-Purchase" and collect "Payments". KBS usually sales books on cash, but do offer maximum of two moths of credit on request and maintains records of "Accounts-Receivables" for each invoice. Generally publishers keep sufficient stock of books. The books that are out of stock are often placed on a back-order-list and often re-order them from alternative sources. A student may buy one or many books at a time and in response to the requirements of students, KBS prepare invoice and collect payments. Sometimes KBS receives payment for one invoice, several invoices or part-of an invoice. Notes: Invoice = Bill of Purchase – a commercial term.

Use BNF, Production and Data Structure methods to describe the structure of the followings:
A Professors Requisition for text Books"
B Requisition for Purchase
C Invoice for the students
Develop the following doc.

User GFPF
by
7.8k points

1 Answer

7 votes

Final answer:

KIMEP Book Store (KBS) can benefit from economies of scale and improved processes by adopting a computerized ordering and stock control system, taking cues from Amazon's successful transition to an online model with highly computerized distribution centers.

Step-by-step explanation:

Transitioning from a traditional retail bookstore model to a computerized ordering and stock control system is a significant move for KIMEP Book Store (KBS). Economies of scale play an essential role in this decision, as seen in the success of Amazon, which transformed book retail by moving to online sales, vast, computerized warehouses, and optimized logistics for convenient purchasing and prompt delivery. As KBS is looking to improve its processes for requisitions, purchasing, and inventory management, it is vital to look at the efficiency gains and cost savings through automated systems and scalable solutions that companies like Amazon have leveraged.

For a smooth transition, KBS needs to model its data structures to reflect the various entities involved in their procurement and sales process. This includes creating relational databases for Professors Requisitions for Text Books, Requisition for Purchase, and Invoices for students. In the KBS context, these databases will help track the interaction between professors' requisitions, the store's purchase orders, and the subsequent sale to students, alongside the financial records such as accounts receivables and payments.

Amazon's business model showcases the advantages of selling without the limitations of physical retail locations, indicating an opportunity for KBS to explore online sales or at least a hybrid model utilizing both physical and digital channels for book sales. This new system will also need to address the essential aspect of availability and prompt delivery of textbooks, ensuring that students receive their required materials in time for their courses. By emulating these successful strategies, KBS can position itself to better serve its customers and maintain relevance in the dynamic educational resources market.

User Dmitrii Smirnov
by
8.0k points