Preview

Sales Monitoring System

Satisfactory Essays
Open Document
Open Document
305 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Sales Monitoring System
TITLE: Sales Monitoring System
CASE STUDY: SUA stationary
SUPERVISOR: Mr. Sanga

1. INTRODUCTION AND BACKGROUND

2. PROBLEM STATEMENT
The SUA stationary gets difficult in handling and monitoring sales getting from time consuming in recording process that requires a user to fill data in each book manually. Also difficult in determination of price and to check the availability of commodities in the store, this is doing by perusing page by page from books it recorded. Moreover is lack of data integrity here since the system used is paper-based therefore there is no way changing takes place to all books at a time. And also inaccuracy calculation due to human errors. And insecurity of data stored is at high risk in case of theft of book(s) or some pages within the book(s) been removed.

3. SIGNIFICANCE AND JUSTIFICATION OF THE PROBLEM
The proposed system will enable the following activities • It will improve the accuracy calculation of data by allowing just entering data required and hence the system would handle that calculation. • It will enable easy accessing and retrieving of required information rather than perusing paper files. • It will ensure data integrity by having the linking between tables in the database where the update or any change of data could take effect in once at a time. • Also the proposed system will ensure data security by producing backups of data/information in different ways.

4. DEFINITION OF TEMRS USED AND ABBREVIATION

5. OBJECTIVES 1. GENERAL OBJECTIVE The purpose of this proposal is to design and develop a sales monitoring system at SUA stationary. 2. SPECIFIC OBJECTIVES • To easily determine price of commodities. • To determine availability of commodities. • To generate report. • To ensure user authentification and authorization of the database. • To maintain data consistence.

6. LITERATURE RIVIEW

7. METHODOLOGY

8. BUDGET



References:

You May Also Find These Documents Helpful

  • Better Essays

    The different information systems are filing cabinets where hard copies are stores or electronically which can be saved changes can be made and they can be made safe with a password.…

    • 1681 Words
    • 7 Pages
    Better Essays
  • Powerful Essays

    Unit 18 - Database P1, M1

    • 995 Words
    • 4 Pages

    Every database management system should have these feature to protect and ensure the data is safe and accuracy.…

    • 995 Words
    • 4 Pages
    Powerful Essays
  • Satisfactory Essays

    The different information systems are filing cabinets where hard copies are stores or electronically which can be saved changes can be made and they can be made safe with a password.…

    • 802 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    These are basic steps towards securing the central database from attacks such as denial of service that is mainly caused by unauthorised access. The strategy is simple and less costly thus cannot cause strain on the budget.…

    • 349 Words
    • 2 Pages
    Good Essays
  • Good Essays

    The data must be kept secure against unlawful or unauthorised processing, accidental loss or erasure.…

    • 1120 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Cis 111

    • 790 Words
    • 4 Pages

    The relational model would provide end users with improved access, by allowing quick answers to ad hoc queries, which reduces the probability of inconsistent data.…

    • 790 Words
    • 4 Pages
    Good Essays
  • Good Essays

    input is no longer needed to collect data, then this will remain as a hindrance that we can’t avoid.…

    • 512 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Using a database management system (DBMS) is a wise decision for any business that plans to implement the use of a database as part of their IT infrastructure. A database management system, also referred to as a database manager (Rouse, 2005), allows one or many computers to create, query, and manipulate data in the database (Rouse, 2005). The database management system also manages request from users and applications, making the database much more user friendly, since the users nor the applications have to know where the data is physically located for the database (Rouse, 2005). Where multi-user systems are being utilized the database management system does not allow the current user to see who else is accessing the information. The database contains data that needs to be protected from intentional or accidental misuse (Ricardo, 2012). The database management system is instrumental to securing the database; and that system allows the database administrator to setup security restrictions and enforce them on multiple levels, making sure only those with the proper credential have access to the data (Ricardo, 2012). The DBMS also adds to the overall security by having the functionality to encrypt the data before it is stored in the database (Ricardo, 2012). The database management system also helps to ensure database integrity, making sure data is readily accessible and is organized as intended by the database administrator (Rouse, 2005). The DBMS also allows the database administrator to define integrity constraints, which are consistency rules that the database must obey (Ricardo, 2012).…

    • 821 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Hoosier Burger Case

    • 274 Words
    • 2 Pages

    Operational Analysis- Once the new information system is implemented, the system will be much likely to work better than the previous paper based system. The new system will be possibly beneficial in inventory management, marketing, customer service, and food preparation.…

    • 274 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Flyer Envelope

    • 1145 Words
    • 12 Pages

    Without Normalization, it becomes difficult to handle and update the database, without facing data loss.…

    • 1145 Words
    • 12 Pages
    Satisfactory Essays
  • Powerful Essays

    Three main benefits of a relational database are report generation, data storage, and data integrity. When putting information in a relational database the possibilities for running reports from the tables that have been created in the database are endless. As long as the information is organized well, the end user can create queries to generate reports based on the data that has been entering into the database. Another great benefit for creating a relational database is the data storage. Data is stored in tables that have a primary key which holds the identification of that data. It assures the end user that there is no duplication of data and helps to reduce data redundancy. Data integrity assures the end user or database administrator that the data that created follows the rules that are applied so that when reports are generated or queries are created that the data that the end user sees is accurate and good. If integrity rules are created with the relational database then it limits the end user of the type of data they can enter into those fields within those tables.…

    • 402 Words
    • 2 Pages
    Powerful Essays
  • Powerful Essays

    ExcelSolverTutorial

    • 1416 Words
    • 12 Pages

    In order to enter your data and work with it in the most straightforward way it is…

    • 1416 Words
    • 12 Pages
    Powerful Essays
  • Powerful Essays

    We hope that this proposed role of computer security can be achieved with the encouragement and support from all quarters, especially who are directly and indirectly involved in this project.…

    • 5973 Words
    • 24 Pages
    Powerful Essays
  • Good Essays

    Party Plates has been very successful over many years. The proposal will detail the benefits of changing databases and future use of collaborative software. Improvements in the current information systems used in the sales department equals efficiency.…

    • 504 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    monitoring system

    • 639 Words
    • 3 Pages

    Software Quality Management Processes defines processes, process owners, and requirements for those processes, measurements of the process and its outputs, and feedback channels. It involves:…

    • 639 Words
    • 3 Pages
    Satisfactory Essays