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 −
- Waterfall Model
- Iterative Model
- Spiral Model
- V-Model
- Agile Model
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 Name | Data Type | Constraint | Description |
|---|---|---|---|
| username | varchar(20) | Primary Key | Username for administrator login |
| password | varchar(32) | Password for administrator login |
Table Name : books
| Field Name | Data Type | Constraint | Description |
|---|---|---|---|
| book_id | varchar(20) | Primary Key | Book identification code |
| title | varchar(100) | Book title | |
| author | varchar(100) | Author name | |
| publisher | varchar(100) | Publisher name | |
| price | int | Price of the book | |
| stock | int | Number of books present in stock |
Table Name : customer
| Field Name | Data Type | Constraint | Description |
|---|---|---|---|
| customer_id | bigint | Primary Key | Customer identification number |
| name | varchar(50) | Customer name | |
| address | varchar(100) | Customer address | |
| phone | bigint | Customer phone number |
Table Name : order_master
| Field Name | Data Type | Constraint | Description |
|---|---|---|---|
| order_no | bigint | Primary Key | Order identification number |
| order_date | date | Order date | |
| customer_id | varchar(20) | Foreign Key | Customer identification number |
| order_status | varchar(20) | Order status |
Table Name : order_details
| Field Name | Data Type | Constraint | Description |
|---|---|---|---|
| order_no | bigint | Foreign Key | Order identification number |
| book_id | varchar(20) | Foreign Key | Book identification code |
| quantity | int | Total quantity |
Table Name : sales_master
| Field Name | Data Type | Constraint | Description |
|---|---|---|---|
| invoice_no | bigint | Primary Key | Invoice identification number |
| invoice_date | date | Invoice date | |
| order_no | bigint | Foreign Key | Order identification number |
| amount | number(10,2) | Invoice amount |
Table Name : sales_details
| Field Name | Data Type | Constraint | Description |
|---|---|---|---|
| invoice_no | bigint | Foreign Key | Invoice identification number |
| book_id | varchar(20) | Foreign Key | Book identification code |
| book_quantity | int | Quantity of the book | |
| total_price | number(10,2) | Total price |
Table Name : purchase_order
| Field Name | Data Type | Constraint | Description |
|---|---|---|---|
| book_id | varchar(20) | Foreign Key | Book identification code |
| order_quantity | int | Total quantity | |
| order_generate_date | date | Purchase order generate date | |
| purchase_order_status | varchar(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