Case Study: System Analysis and Design of Top Text Publishing Database

This case study analyzes the system analysis and design of a database for Top Text Publishing, a company dealing with large volumes of books. The assignment addresses the need for a system to manage book inventory, track authors, and streamline operations across multiple sales offices. The project scope includes defining system requirements, such as book searching and buyer-seller interactions. The student utilizes the agile adaptive SDLC, outlining phases like planning, design, code development, release, and maintenance, with associated costs. Diagrams such as use case, sequence, entity relationship, and data flow diagrams are used to model the system. A Gantt chart illustrates the project timeline. The analysis highlights the importance of a well-defined system design to meet user requirements and facilitate efficient database management. The case study emphasizes the significance of system analysis and design in ensuring the successful delivery of a functional and user-friendly database system.

Student Name
Course Name
System Analysis and Design
Database
Case Study of Top Text Publishing
Institution Affiliation

Introduction
System analysis and design is a very wide topic, thus this calls for one to have a better
understanding of all the terms related to it before one go in to design concepts. Ideally, for one to
understand the concept in details a detailed analysis will need to be done to explain the problem
solution (Pedrycz, 2016). After the analysis has been done, it becomes easy for one to choose the
specific designs for the scenario and thus coming up with a good database systems (Gupta,
2017). In the given case study, Top Text is a publishing company that is known for selling books
in large quantities. Top Text headquarter is located in a big town. The company owns a
warehouse and much more three other sales offices where each office is usually headed by a
sales manager who manages sales representatives. In understanding this case study, it will be
good for one to understand clearly the concepts and principals of the system analysis and the
design (Dennis, Wixom and Tegarden, 2015). In more details, it is good for one to understand
the SDLC stages. In conclusion, one will need to apply the modelling tools for the system
analysis and design.
Need for System Development
In any case, since the publishing company is dealing with large quantity of books, this
may be tiresome when they do it manually considering they have more than location with
different sales centers. Ideally to understand this, the system will be able to help in identifying
the number of writers by use of a universal code usually named as ISBN. Ideally, being a big
company that usually contains a list of more than 100 books it will not be easy for one to indicate
the catalogues for each book and for each author considering one author may have more than 10
books with different ISBN that helps in identifying them. Ideally, if the system was to be
implemented then it will help in easy management of the three sales offices from the
headquarters without having to go to the sales offices directly.
Benefits of Project Implementation
Like in any project, the project will ease the work of the company in identifying the
books in the stock and those that need to be added. In this case, one will be able to know which
books are available and those that need to be restored and much more with regards to the amount
each book cost (Azar and Vaidyanathan, 2015). Nevertheless, by use of a unique ISBN, the

system will be able to identify the books without having to look one by one and thus ensuring a
suitable searching and sorting technique is put in to place (Balanis, 2016). Lastly is that, the
records will be stored in a manner that it will be easy to access and retrieve them when need be
arises in all situations and thus making the system a good point of reference in case such records
are needed in the future.
Project Scope
In this scope, the project will major on defining the requirements of the project and the
process of such requirements. Ideally, some of the project requirements are such as building a
system that will help one to be able to search a certain book from the system and get the results.
In this case, the scenario will also dwell on how the buyers and sellers will interact with the
books or product and how such will affect other in the business.
Schedule analysis and Project cost
Ideally, the project analysis schedule will follow that of a normal software development
life cycle using the agile adaptive SDLC which will be rapid in the manner that the system will
be implemented in a short time (Krishnan, 2017). According to the schedule of the adaptive agile
SDLC, the system will follow the following the procedure.
Figure 1 Stages in Agile Adaptive Planning

Projection Cost
Phase Anticipated Cost ($)
1. Plan and Analysis (Concept) 500
2. Design 2,000
3 Code Development 5,000
4 Release 2,000
5 System Deployment and Maintenance 3,000
TOTAL $12,500
As shown in the above table. The estimated project cost as per the requirements of the
clients will be about $12,500. The code development phase is anticipated to be costly as the
coding stage is much involving and it may need a big development team in that the iteration done
gives the best as discussed in the requirements.
Diagrams Designs
Use Case Diagram
Figure 2 Use Case Diagram
In this diagram above, there are three major actors namely the system, author and the
sales rep who performs various actions as shown in the diagram such as to maintain, transfers,
manages, writes and sells.

Sequence Diagram
Figure 3 Sequence Diagram
This is an extension of the use case diagram showing how the sales rep interacts with the
customers when selling the textbooks to the customers who may be schools or individuals.
Entity Relationship Diagram
Figure 4 Entity Relationship Diagram

This diagram has been used as pillar to show the various entities and how such entities
relates with each other regardless of each entity attributes. In explaining further each textbook is
easily identified by a unique attribute named ISBN Number which makes it easy for one to
identify a book in any location even from the headquarter.
Data Flow Diagram
Figure 5 Data flow Diagram
Gantt chart
Figure 6 Gantt chart

Conclusion
As seen above, it is crystal clear that all the activities and processes involved during the
analysis and design of the system databases will need a high concentration in all ways. In this
case, such errors and faults that occurs in the implemented system can be highly monitored in all
aspects and thus making this system easy to correct bugs. In any implementation of a system, the
analysis and design phase determines the deliverable or the end product of the system in ways. In
this way, the system can be able to meet the requirements of the users.

References
Azar, A.T. and Vaidyanathan, S. eds., 2015. Chaos modeling and control systems design (Vol.
581). Germany: Springer.
Balanis, C.A., 2016. Antenna theory: analysis and design. John wiley & sons.
Dennis, A., Wixom, B.H. and Tegarden, D., 2015. Systems analysis and design: An object-
oriented approach with UML. John wiley & sons.
Dennis, A., Wixom, B.H. and Roth, R.M., 2018. Systems analysis and design. John wiley &
sons.
Gupta, A.K., 2017. Response spectrum method in seismic analysis and design of structures.
Routledge.
Krishnan, R., 2017. Switched reluctance motor drives: modeling, simulation, analysis, design,
and applications. CRC press.
Pedrycz, W., 2016. Granular computing: analysis and design of intelligent systems. CRC press.