Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

  • Invoice
  • Order Placement
  • Order Enquiry
  • Product Enquiry
  • Payment
  • Delivery
  • Sales Report

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Retail Management A Strategic Approach

Authors: Barry Berman, Joel Evans, Patrali Chatterjee

13th Edition

0133796841, 9780133796841

More Books

Students also viewed these General Management questions

Question

2. What we can learn from the past

Answered: 1 week ago

Question

2. Develop a good and lasting relationship

Answered: 1 week ago