Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started