If you have any queries please leave a message here
Your Message

A book store proposes to develop a "Book Sales Information System". The information system provides secure login to book store employees. The services offered by this system should include - finding the availability of a book in the book store; taking orders from the customers for the books, which are not available; making an invoice for sale for customers; ordering of the books, which are high in demand and stock of those books have reached a low level.

You may study the requirements for such a system in more details. Perform the following tasks for the system given above :

Q1. a) Which Systems Development Life Cycle (SDLC) will you propose for the specification given above?

Answer : - The systems development life cycle (SDLC) is a conceptual model used in project management that describes the stages involved in an information system development project, from an initial feasibility study through maintenance of the completed application.

There are various SDLC models defined and designed which are followed during the software development process. Some important and popular SDLC models are given below −

I use Waterfall Model for the specification given above.

Q1. b) Justify you selection by evaluating suitability of at least two SDLCs.

Answer : -

Waterfall Model - The Waterfall Model was first Process Model to be introduced. It is also referred to as a linear-sequential life cycle model. It is very simple to understand and use. In a waterfall model, each phase must be completed fully before the next phase can begin. This type of software development model is basically used for the project which is small and there are no uncertain requirements.

At the end of each phase, a review takes place to determine if the project is on the right path and whether or not to continue or discard the project.

V-Model - In software development, the V-model represents a development process that may be considered an extension of the waterfall model, and is an example of the more general V-model. Instead of moving down in a linear way, the process steps are bent upwards after the coding phase, to form the typical V shape. The V-Model demonstrates the relationships between each phase of the development life cycle and its associated phase of testing. The horizontal and vertical axes represents time or project completeness (left-to-right) and level of abstraction respectively.

Q2. a) What would be major costs of the system?

Answer : - Coming Soon

Q2. b) What may be the financial benefits of installing such a system?

Answer : - Coming Soon

Q2. c) Perform a cost-benefit analysis for the proposed software and report its findings.

Answer : - Coming Soon

Q2. d) List the major tasks and milestones of the Project and make a project schedule. The schedule must include both GANTT and PERT charts. Explain the two charts drawn by you.

Answer : - Coming Soon

Q3. a) Study the system and create a software requirement specification. You must identify either the processes or objects while analyzing. During the analysis give consideration to possible input and output of the processes.

Answer : - Coming Soon

Q3. b) After identifying the requirements, create Analysis Models. You may either use the classical approach and draw Entity relationship diagram and data flow diagrams (DFD’s) up to level 2-3; or you may take object oriented analysis approach and create class diagram, use case diagram, use cases etc.

Answer : -

ER- Diagram

Q4. a) Design the system architecture and the database as per the needs of the system. You must perform normalization on tables up to 3rd normal form. The table design must include Primary and Foreign keys and constraints.

Answer : -

Table Name : admin_login

Field NameData TypeConstraintDescription
usernamevarchar(20)Primary KeyUsername for administrator login
passwordvarchar(32)Password for administrator login

Table Name : books

Field NameData TypeConstraintDescription
book_idvarchar(20)Primary KeyBook identification code
titlevarchar(100)Book title
authorvarchar(100)Author name
publishervarchar(100)Publisher name
priceintPrice of the book
stockintNumber of books present in stock

Table Name : customer

Field NameData TypeConstraintDescription
customer_idbigintPrimary KeyCustomer identification number
namevarchar(50)Customer name
addressvarchar(100)Customer address
phonebigintCustomer phone number

Table Name : order_master

Field NameData TypeConstraintDescription
order_nobigintPrimary KeyOrder identification number
order_datedateOrder date
customer_idvarchar(20)Foreign KeyCustomer identification number
order_statusvarchar(20)Order status

Table Name : order_details

Field NameData TypeConstraintDescription
order_nobigintForeign KeyOrder identification number
book_idvarchar(20)Foreign KeyBook identification code
quantityintTotal quantity

Table Name : sales_master

Field NameData TypeConstraintDescription
invoice_nobigintPrimary KeyInvoice identification number
invoice_datedateInvoice date
order_nobigintForeign KeyOrder identification number
amountnumber(10,2)Invoice amount

Table Name : sales_details

Field NameData TypeConstraintDescription
invoice_nobigintForeign KeyInvoice identification number
book_idvarchar(20)Foreign KeyBook identification code
book_quantityintQuantity of the book
total_pricenumber(10,2)Total price

Table Name : purchase_order

Field NameData TypeConstraintDescription
book_idvarchar(20)Foreign KeyBook identification code
order_quantityintTotal quantity
order_generate_datedatePurchase order generate date
purchase_order_statusvarchar(20)Status of the purchase order

Q4. b) Create the system flow chart or detailed process design and state transition diagrams. Also design the user input screens and output report formats.

Answer : - Coming Soon

Q5. Design various unit test cases for different testing techniques/strategies.

Answer : - Coming Soon

ABOUT US is an educational website that helps worldwide students in solving computer education related queries.

Also, different software like Visual Studio, SQL Server, Oracle etc. are available to download in different versions.

Moreover, provides solutions to your questions and assignments also.


Windows Command

UNIX Command

IGNOU Assignment Solution

IGNOU Question Paper Solution


Website Devlopment


Home Learning

Provide BCA, MCA Projects

Provide Assignment & Question Paper Solution


Follow Us