suggest project ideas on informatics practices for 12th [Archive]

Basant pandey

07-03-2008, 09:10 PM

Project

The following case study is to be adopted for the development of project
A book publishing company B R Publishing Group is in existence since1950. They were untouched with latest technological inventions. They are still using a traditional approach of bookkeeping and accounts maintenance.
A company, Nova technology, introduced themselves as system integrator and developers who can change existing working system into the latest concept of paper less office. They wanted few details from the company about its working. The details are as under:
Name of the company is B R Publishing Group.
The company is having 20 employees. One Managing Director, Two Managers
(Work manager and Marketing Manager) and 17 employees who work as a team for book publishing.
The company publishes books in different Indian languages and different topics.
Every book involves an Author and its detail.
The book is sold in the market at a variable discount options
Book Seller: 30%
Schools: 20%’
Customer: 15%
The company is maintaining information about Author and all its details such as Personal Information, Royalty etc.
The company manages information about the book such as Book Name, Author, Quantity Sold, Quantity in Stock, etc.
The company maintains Customer (Book Sellers) information. Books Sold, Subject, Language, and Amount Pending etc.
Reports are required at different levels, such as
Customer Listing
Book Listing
Language Wise Book Listing160
Topic Wise Book Listing
Pending Amount Listing (Customer Wise, Book Wise)
Author Royalty Detail
Bill Generation etc.
As a developer you are required to design the project and develop it as per customer needs (Developer can also visit a publishing company to collect customer details and live data). Suitable assumptions can be made during implementation. A proper normalized database is to be maintained in the RDBMS and the front end is to be developed using advanced interface controls.
User-friendly interface is to be generated.
Note: This is a sample case study. Similar type of cases can be developed on different application areas such as Library, Hospital, Transport Authority, Transporters, Wholesale Merchants, and Chemist Shops etc. The cases to be developed should preferably be obtained from live situations.