Preview

Bookshop Automation

Powerful Essays
Open Document
Open Document
4844 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Bookshop Automation
Babu Banarasi Das
National Institute of Technology & Management

Bookshop Automation
System Requirement & Specification
(Project No – P10)

Submitted to: Miss Shweta Kulshereshtha Submitted By:

Vivek Kushwaha
MCA V SEM (M2) Group : G2

Abstract
The project report consists of 2 phases. In the first phase, the problem assigned to us has been mentioned. Second phase provides the solution for the same problem along with an insight into the development process involved. Introduction part gives the information regarding Bookshop Automation System. It also gives brief introduction about the project under the topic PROBLEM DEFINITION .It gives a short introduction about Bookshop and its operations. The next part is the REQUIRMENT ANALYSIS which is mainly concerned with study of various requirements such as user, System, Hardware/Software & Performance. It also includes feasibility study of system. The next part is on SYSTEM DESIGN, which include interface design, detailed design .It also includes function flow, DFD, and ER diagram & database design. Last part is regarding CONCLUSION about above mention problem.

Table of Content
Introduction Approach to problem solving Problem Definition Existing system description Business Processes of Existing System Problems and constraints Feasibility Study Requirement Specification Challenges Problems are solved by system Characteristics of the entities are used to solve the problem General Characteristics Procedural design Detail Data Flow Diagram Use Case Diagram for Entire System Use Case Diagram for Computerized Parts of the System Class Diagram for Entire System Database design Entity – Relationship Diagram Conclusion Reference and Bibliography 4 5 7 8 9 10 11 12 15 16 17 18 19 20 21 22 23 35 38 39 41

Introduction:
The Bookshop Automation System is to automate all operations in a bookshop. Generally it includes the Order Processing, Stock Management and Accounts Management. Before automating a bookshop we have to understand



Bibliography: Australian Computer Society, 2003, ASC Code of Ethics. Retrieved March 15, 2007, from http://www.acs.org.au.htm Elmasri, R. and Navathe, S. 2004. Enhanced Entity Relationship and UML. In Fundamentals of Database Systems, 3rd Edition Out Source 2 India n.d. :Why Do Software Projects Fail? Retrieved 22 March 2007 from http://www.outsource2india.com/software/SoftwareProjectFailure.asp Six Sigma n.d. : Applying Six Sigma to Software Implementation Projects Retrieved 22 March 2007 from http://software.isixsigma.com/library/content/c040915b.asp Sommerville, Ian 2004. Object Oriented Design Software Engineering, 7 Edition th Start your journey the easy way n.d : Retrieved 4th February 2007 from http://www.liverpooljohnlennonairport.com/TravelServices/CarParking.php Ramakrishnan, R. and Gehrke, J. 2003. The Relational Model In Database Management Systems, 3rd Edition

You May Also Find These Documents Helpful

  • Good Essays

    A dependable database is required to provide tracking of the scheduled and unscheduled maintenance for their fleet. The development will contain a database with forms, tables, queries, and reports which track maintenance records, inventory of parts, and any purchases from vendors. The entity relationship diagram (ERD) project will reduce down time of each truck in the fleet and guarantee parts availability. The project will also minimize profits loss due to accessibility of trucks, and each hub will be able to access this database. The overall objective is to bring that proposed database to life and allow Huffman Trucking Company to use that database across all of their various locations.…

    • 699 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    MSCD600 Course Project

    • 1578 Words
    • 18 Pages

    The Project “Grocery store” deals with the automation of supermarket. This software will help salespersons in managing the various types of Records pertaining to his/her customer. The product will help the user to work in highly effective and efficient environment.…

    • 1578 Words
    • 18 Pages
    Powerful Essays
  • Good Essays

    Cis 515week 3

    • 1024 Words
    • 4 Pages

    Bibliography: (2012). Database systems: Design, implementation, and management. (10 ed.). United States of America: Joe Sabatino.…

    • 1024 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Kroenke, D. M., & Auer, D. J. (2010). Database Concepts (4th ed.). Retrieved from https://ecampus.phoenix.edu/content/eBookLibrary2.…

    • 553 Words
    • 3 Pages
    Satisfactory Essays
  • Best Essays

    Rob, P., & Coronel, C. (2002). Database systems: design, implementation, and management (5th ed.). Boston, MA: Course Technology.…

    • 1383 Words
    • 5 Pages
    Best Essays
  • Satisfactory Essays

    Week2 Discussion2 DBMS

    • 480 Words
    • 3 Pages

    References: 1) Database system Design implementation and management 9th edition Coronel, C., Morris, S.,& Rob, P(2011).…

    • 480 Words
    • 3 Pages
    Satisfactory Essays
  • Better Essays

    Dbm 381 Week 1 Individual

    • 971 Words
    • 4 Pages

    Pratt, P.J., & Adamski, J.J. (2012). Concepts of database management (7th ed.). Retrieved from The University of Phoenix eBook Collection database.…

    • 971 Words
    • 4 Pages
    Better Essays
  • Powerful Essays

    References: Rob, Peter and Coronel, Carlos. (2005). Database Systems: Design, Implementation, and Management. United States: Thomson Course Technology.…

    • 2376 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    Cis 111

    • 790 Words
    • 4 Pages

    “The benefits of using the relational model would result in an easy to use, flexible, high performance database at a low cost.” (Anita, 2010) Therefore, allowing them to participate in the entire design process of the logical construction. The relational model provides an easy and flexible way of manipulating data with a system that offers:…

    • 790 Words
    • 4 Pages
    Good Essays
  • Good Essays

    References: Coronel, C., Morris, S., & Rob, P. (2013). Database systems: Design, implementation, and management (10th ed.). Independence, KY: Cengage.…

    • 906 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Entity-Relationship models were first published in 1976 by Peter Chen, which was in basic model form. Now, the basic model was extended to create the extended entity-relationship model, which is used extensively in today’s businesses. The E-R model used today consists of entities, attributes, identifiers, and relationships. These will be discussed in more detail to explain how they were used in creating the current database for Huffman Trucking.…

    • 728 Words
    • 3 Pages
    Good Essays
  • Good Essays

    References: Coronel, C. (2013). Database Systems: Design, Implementation, and Management, Tenth Edition. Mason, Ohio, United States: Cengage Learning.…

    • 799 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Athabasca Assignment

    • 837 Words
    • 4 Pages

    Relational databases are not new technology. Commercially, they gained importance in the early 1980s with the introduction of Oracle’s relational database, and since then they have been an essential tool for most businesses. Databases are critical tools that help to support various business functions in an organization. These information systems help a business to build and maintain competitive advantage. Databases not only support the operational levels of business—they are also used to support the activities of managers.…

    • 837 Words
    • 4 Pages
    Good Essays
  • Good Essays

    References: Pratt, P.J, & Adamski J.J, (2011). Concepts of Database Management. Ohio, OH: CENGAGE Learning.…

    • 688 Words
    • 3 Pages
    Good Essays
  • Better Essays

    In this paper I am going to discuss about the database and software used in my construction company. Oracle database is a multi platform database, meaning it can run efficiently on any operating system and this makes Oracle flexible and more secure when compared to its competitors. Our Oracle database is running on a Sun server, using the Sun Solaris enterprise operating system. Oracle databases are an enterprise database system, only medium and large companies would need an enterprise database. Oracle Corporation uses RDBMS rational database management systems to maintain all data within the organization. Various data items can be organized according to their relationships with each other, such as the relationship of Employee name and Employee ID, rational databases give Oracle a great deal of flexibility when describing the relationship between data elements. Oracle follows Dr.Cobbs 12 rules on how a true RDBMS should be evaluated. The following are Cobb's 12 rules.…

    • 807 Words
    • 4 Pages
    Better Essays