Design And Develop Supermarket Sales System Services Computer Science Essay

conception And Develop Supermarket Sales System Services Computer Science EssayIt contains lucubrate for the customers, suppliers and increases. This clay of rules contains deuce types of hirers, administrator and the end exploiter. The administrator has the authorization to create new users, edit an existing user and delete a user or disable a user.This system generates multi reports for costumer, supplier, product, and soling. This allow cut down the amount you spend a personal manner from the primary focus of your rail line and getting more(prenominal) than think out over your business.CHAPTER ONEIntroductionSMSSS is solving a problem that could face any business. An inventory that could disappears from your stores, pharmacies, restaurants and hospitals, due to theft, wa microscope stage and employee misuse because employee leave alone know that inventory is universe cargonfully tracked. SMSSS can instantly tell you about how many a particular product fetch sold to day, or in any dot you want.My Graduation ascertain is applied on supermarket this result do on tracking its rebrinying inventory, spot sales trends, use historical entropy to fracture forecast your call for and precise sales reports puzzle out it much easier for it to living the right on hand.SMSSS will include two types of users, administered user and a average user. The first will have the authorization to add users to check the reports and observing the suppliers. The normal user just will prepare the customers orders and print out the billing. every(prenominal) SMSSS system needs a printer to create credit card slips for customer but the users will deal with this system without using that printer therefrom the paying will be in separate operation with normal printer. Touch screens are more intuitive to use than keyboards for many users, but in this case there will not be a touch screens, the users will depend on the keyboard and a computing device only. It is a sim ple system without providing the flexibility to users.BackgroundAs it is mention before in the introduction this project will apply on supermarket, which has number of employees who received the customers orders. This supermarket is new, so it is face for suitable manner to mould on their business. This work is usually want a faster user who understand the customers order in short condemnation, and deport the money by count the orders price without mistake, eespecial(a)ly when your business is run will and lot of customers orders you should focus on to not effected on your business, that wherefore the SMSSS system will helps to save money, appropriate productivity gains.ObjectiveOur project helps to record any and all sales, it automate overall inventory control, helping to keep stocks in proper balance depend on demand and other factors, so management is much easier. Also you are able to track promotions more successfully, whether through capons and special discount. In SMSSS you get many tools in a single package. SMSSS can make better use of your personal by undersize is more maddening to a business owner than watching his/her staff bogged down. SMSSS reduce paperwork, increase productivity, reduce time you have to spend doing inventory, provide more precise instruction on the rate at which each product in your inventory moves so you know when and how much of each item to order, showing you what selling and what not, which vendor product are profitable, and which vendors are making you the around money overall. In this case, your customer gets faster and more accurate service.CHAPTER TWO(Project Deliverables)Project DeliverablesThe deliverables for this project is constituteing into four main sections exploreAnalysis and DesignImplementation and TestingTesting and valuationProject management2.1 ResearchIn this section, it will gather information about HCI, and similar package to the one that will be built and the language that decide to use.2. 2 Analysis and DesignAnalysis is the treat of breaking a case or topic into many smaller parts to increase a better understanding of it. This way will helps to find the functionality of the software program should have, and what curriculumming language should apply to implement it, and solve problems found during the research section, and discuss what methodology will use for both construction and implementing the system.Design method consists of the modeling language and the design process. Modeling language is a convention detailing how the design will be written on the paper. incorporate Language is an casing of a modeling language (UML). It makes details on how the software will be highly-developed.2.3 Implementation and TestingThe design section will contain screen designs as well as the core design of the software and the way it is implemented and it will include the testing and evaluation.2.4 Testing and EvaluationTesting is establishing a software system to find out t he errors. Testing a set of programs against requirements specification expressed in varied diagram much(prenominal) as information flow and entity relationship diagrams. In the process of software outgrowth, testing has historically been left until the enter has been written. 1Testing code through by different people at different times. The testers are depending on which testing is being done and the resources allocated in order to tasting a particular software product. The testers could be the programmers, a team of testers, people represent the market for the software, the client and maintainer 1.During and after executing the software, code is being tested .Pre-implementation testing is done by a testing team of reviewers project manager or clients or system developers. After implementation or code testing, software developers pick out to taste the system from the bottom up, in order to check if they launch to have coded correctly. The testers applying two main testing te chniques black box testing and whitened box testing. There are many different of testing such as unit testing, test kinds, system testing, integration testing, regression testing , word sense testing, anaesthetise testing and beta testing ..12.5 Project ManagementEatch project can run smoothly and efficiently according to some sort of managements. This ways of monitoring the project is important in order to controlling the costs and benefits of any project. If there are occurred reasons that make the work is running late, or make the costs are beginning to escalate, it is necessary and essential to discover this as soon as possible and to be able to recovery these bugs . That cause open a problem then corrective action can be taken to have the possible effects of the problem reduced. The project manager is prudent for organizing planning, monitoring and controlling the project only if the management side has been separated from the technical development. 2The task of the proj ect management, plan, estimate time and effort, identify tasks for the team, use prior experience, schedule work, use resources, monitor and control the progress of the project, evaluate what is priority , and identify quickly the causes of problems all these are expensive, in terms of both time and money. 2It is important to project manager to be able to identify areas of risk, such as lack of knowledge, occurred new technologies or problems relating to requirements, and to obviate these all plans should be prepared.2 most of project managers use such as graphics of charts to scheduling their work there are many different types of char, they mainly fall into one of two categories, bar chart which is often referred to Gantt chart) and network chart which is often referred to (CPM or PERT or CPA) in this project well use the Gantt Chart in order to fancy up our timing,.Chapter ThreeResearchSimilar ProductThere are a variety of software solutions available for Cashier Assistant ( ge t of sale). some(prenominal) different approaches are examined here to compare different features and gain an understanding of the best approach to take when designing a Cashier Assistant (POS) in the wining pages, good and bad points about surveyed application will be examined on what to add or to improve in the software to be.The layout of this examination is followThe name of the being applicationA list of good points about the applicationA list of bad point about the application3.1 Harolds exquisite Home Lighting is a company based on tradition with 17 independent workstations.3.1.1 equitable PointsFastEliminate the need for separate point of sale terminal.Provide quick verification and processing of credit cards at the POS.Simple bar coding and efficient, create a reliable way to control inventory.3.1.2 Bad PointsHuge selective information, there is no automatically back up.Difficult to update3.2 Rod Works 5 stores depends on sale items3.2.1 Good PointsAutomatically generat e purchase orders when items fall below recorder levelsReduce inventory carrying costs by tracking inventory turns and gainingGenerate discrepancy reports to crack up errors in physical inventory3.2.2 Bad PointHuge data, there is no automatically back up.Difficult to updateResearch into HCIHuman computer fundamental interaction is created by computer software and hardware. Human computer interaction makes computer and human interface more interesting and satisfies users needs. Human computer interaction design methodologies are based on User Centered Design. They are focus group, affordable analysis, participatory design, rapid prototyping, user scenario, value-sensitive design, and contextual design, etc.In Human computer interaction design seven principles are considered, tolerance, simplicity, Visibility, Affordance, Feedback, Structure, Consistency, etc. web interface and normal GUI are use according to the purpose. It is used for conferences, space shuttles, aircrafts, etc3The human-computer interface is the point of communication between the user and the computer. There are several goals depend on the end user to gain his interaction. purlieu depend where the user is used his own machine in which environment, college park any(prenominal). input signal information the tasks the required by the user to the computer.Output data whatever have generated from the computer represented to the user.Feedback whatever the user required pass to the computer and forward back.HCI is affected by several forces of future computing for interpreter5Reduction hardware price guiding to larger memories and quicker systems.Miniaturization of hardware guiding to portability.Decrease in power needs guiding to portability. bleak present technologies guiding to the packaging of computational machines in new shapes.Specialized hardware guiding to new roles.Improved progress of network communication and shared out computing.Increasingly extensive use of computers, especially by user who are outside of the computing occupation.Growing novelty in input techniques (e.g., voice, gesture, pen), feature with lowering price, guiding to fast computerization by people who left out of the computer insurgency.Widespread common concerns guiding to get better gather computers by disadvantaged groupsInterview Techniquesinterview Inputsinterview Outputsinterview Interaction Techniquesinterview Issueskinds of input principle s (e.g., choice, distinct parameter specification, nonstop control)Input techniques keyboard, menus, mouse-, pen-based, voice.kinds of output principles, express precise information, abstract information, show processes, create illustration of information)Output techniques like scrolling present, windows, animation, sprites, fish-eye displays)Screen describe issues (e.g., focus, clutter, visual logic)Dialogue type and techniques for example form filling, menu selection, icons and direct treatment, generic functions)searching, error managementMultime dia and non-graphical dialogues mic, speaker, voice mail, video mail, active documents, CD-ROMReal-time reaction issuesManual organize theorySupervisory control, automatic systems, embedded systemsStandardsprotection3.2 Research on ticklishware Tools3.2.1 Research on chocolate http//www.csci.csusb.edu/dick/samples/java.htmlhttp//101.lv/learn/Java/ch1.htmJava is an endeavor oriented program it is often used in VCRs and toasters it was originally called OAK it is a high level language developed by sunniness Microsystems. One a real information is that Java is based on the first rendering of C++. Java includes a set of class libraries that provide basic data types it is standard Java environment, system input and output capabilities, and other utility functions. Java is Platform that means it is easy to move the program from one computer to other. This is as an advantage of java over other programming languages. To execute a Java program a bytecode interpreter should be run. By tecode is built into every Java-enabled browser. it is read the bytecodes and executes your Java program it is often called the Java virtual machine or the Java runtime.Java is a language that should compiled into the special machines code to then interpret. The role of the interpreter is to protect the machine from errors that can break down operating systems in C++. Compiled code can run on different systems, so a Java program can be across via a network to a machine with any different operating system you have it and with different GUI. Since java is high-level language it used to write applet and applications. An applet is a small program should transfer it cross the network and interpreted on the client machine by a Java-aware browser. Java application can only be compiled and then run on the aforesaid(prenominal) machine. That why you cannot run the java if you do not have an application or a WWW page that refers to it. Once you decide to run the java you may have to stir the properties of your browser this is a security issue in order to have the trust from your browser in order to use the compiler, that why when you do not recognize the compiler version you will face that your applet is rejected.3.2.2 Visual BasicIt is a programming language and environment developed for such type of windows or web application or reports and many purpose belong to development.10. since its launch in 1990, the Visual Basic come up to be the custom for programming languages. Now there are visual environments for many programming languages, including both C and C++, plus for Pascal and Java. sometimes VB called rad system because it is enable programmers to speedily build proposal applications.VB was one of the first products to supply interface environment for user, plus the VB programmers can insert a substantial quantity of code just by dragging and dropping control, like using buttons, text box, radio buttonact and then be them by using the properties functions. Although not a true OOP language, it is sometimes known as an event-driven language because each object can act in repartee to several events for example when we use a mouse click.3.2.3 C LanguageC is an object-oriented language. It is further includes support for component-oriented programming. C has a unified type system. in all C types, have primitive types(int and double, inherit from a single object type). C supports user-defined reference types and value types, allowing dynamic allocation of objects and-line storage of lightweight formations.C programs consist of one or more source files .Concepts in C are programs, namespaces, types, members, and assemblies. Programs declare types, which contain members and can be organized into namespaces. Classes and interfaces are examples of types. Fields, methods, properties, and events are examples of members. When C programs are compiled, they are physically packaged into. Assemblies have both executable code in the form of Intermedi ate Language (IL) orders, and symbolic information in the form of metadata. Before the executed begin, the Intermediate Language code is directly transmuted to processor-specific code by help of the Just-In-Time compiler of .net Common Language trial run time (CLR).Variables types value types and reference types. value types include their data where variables of reference types store references to their data. With reference types, it is likely to have two variables to reference the same object helping for operations on one variable to affect the object referenced by the other variable. Through value types, the variables have their own transcript of the data. It is possible on one to affect the other.3.3 Research on Database3.3.1 Research on SQL waiterSQL ServerAclient server is made of two components an application that is used to present the application data, and a database system that is used to store it. The application may used the visual studio 2005 or price of admission or some other graphical user interface. And to store the database it is suitable to use SQL server. Database is a collection of objects stored in the SQL server. This collection of objects including tables, views, stored procedures, functions and other object necessary to build the database. As know the tables are the first generally thing that you add to a SQL server. And each table contains information about specific case. Once the tables are created the user should mentioned the keys for each table. SQL server stored procedures and compiled code and executed on the server. You can execute them through any client(VB.net, microsoft access, microsoft word)If you waant to interchange the a stored procedure you can modify it from the server. The change you do impact to all user client thet call the stored procedure.Microsoft recognize that there is a plethora of database user with disparate needs. That why they release the following six versionSQL server 2005 Express editionSQL server 2005 workgroup editionSQL server 2005 developer editionSQL server 2005 standard editionSQL server 2005 endeavor editionSQL server 2005 mobile edition.Features are provided by database enginehttp//www.informit.com/guides/content.aspx?g=sqlserverseqNum=14Clustering Services It is operating system allows the user to recover at one time from currently system to another.Replication go remains data in synchronization between SQL Server databases and other database like prophet, Microsoft Accessect. other using for It is to send data to several systems.XML transfer data between mixed programs or data sources.SQL Server 2008 allow the user to report on SQL Server 2008 adds a new Policy Based Management system to SQL Server, which allows you to report on and put in force a exact pattern for any database object.SQL Server 2008 can track the performance and other data in a central location and raise a report.In SQL server a provider for power shell is including. This helps the user to save scrip programs and for windows, Microsoft exchange, and Microsoft office too. The SQL Server provider deals with SQL Server Instances, Databases and Database Objects . this let the user deal with them in perceptive way.Reporting services has been built in SQL server 2000 and to SQL server 2005 and next other modern versions. The feature helps the user to do their work through SQL server directly via the browser.3.2.3 Research on oracleThe Oracle Database 12referred to RDBMS or as Oracle (RDBMS). As of 2009update, Oracle remains a major presence in database computing.Oracle RDBMS stored data logically in table spaces and in data files if the it is in physicaly form.Oracle DBM tracks the data stored with the help of the information that is stored in the system table space itself.In 1970, oracle was the first commercial relation database based on the relational language SQL. It is goes in such development oracle tools could support many methodologies. Oracle users would purchase the d atabase, but it was possible to purchase some tools that make up the oracle product rang but not others.Designer 2000 was formally known as oracle CASE, and is helpful on data and process modeling. Developer 2000 is used to build a application, once it has been designed using oracle designer 2000.Discoverer 2000 consists of a suite of user friendly query tools designed for ad-hoc reporting. The oracle database management system is central to these tools, through many ends -user are hardly aware of its presence.The main method of communicating directly with the oracle database is by using the SQL language. Although this stands for SQL. It enables the experienced user to do more than just handle queries. There are extensions to the basic SQL language provided on Oracle and together they from PL/SQL. The SQL optimizer attempts to make each SQL statements as efficient as possible when executed.SQL procedure can be trigger by certain events, for example after updating or deleting a recor d. The security feature are now very sophisticated you need system previleges to access the database and object level privileges at different levels to query, insert, delete and updating, any object stored in the database. Data is validated through data constraints, that is, only allowing permitted values of data to be entered into the databaseOracle database management tracks its data storage with the help of information stored in the system space table. Oracle RDBMS is supported localy managed table space which help store space management information in their headers better than in the table space.The history of Oracle database.(1979) was the first released Oracle version 2(1982) released Oracle version 3(1984) released Oracle version 4(1986) released Oracle version 5(1988) released especial version for OS mackintosh Oracle version 1(1989) released Oracle version 6(1993) released Oracle version 7(1997) released Oracle version 8(1999) released Oracle version 8i(2001) released Oracl e version 9i(2003) released Oracle version 10g(2007) released Oracle version 11g3.4 Research into Methodologies3.4.1 Research into Traditional System Development Life Cycle (SDLC)The rapid increase in the power13, speed and capacity of computers, and the demands of clients and the market-place have encouraged software developers to attempt to develop ever more ambitious systems. First attempt was in 1960s and early 1970s but this was a complex and system, it was difficult to maintain and did not do what was required. The system life cycle was an attempt to establish a structured approach to analyzing designing and construct software systems. The system life cycle divided the development of system into stages.Feasibility analyse the development team visits the customer and studies their system. They investigate requires in the disposed system. End of the feasibility study, the team supply a document that holds the different specific recommendations for the candidate system, person nel assignments, costs, project schedule, target dates etc. The purpose of this chassis is to find out the need and to define the problem that needs to be solved.Analysis and design The software development process, the softwares overall structure and its nuances are defined. In terms of the client/server technology, the number of tiers needed for the package architecture, the database design, the data structure design etc are all defined in this grade. A software development model is thus created. Analysis and Design are very crucial in the whole development cycle. Any glitch in the design phase could be very expensive to solve in the later stage of the software development. Much care is taken during this phase. The logical system of the product is developed in this phase.Code Generation The design must be translated into a machine-readable form. The code generation step performs this task. If the design is performed in a detailed manner, code generation can be accomplished witho ut much complication. Programming tools like compilers, interpreters, debuggers etc are used to generate the code. Different high level programming languages like C, C++, Pascal, Java are used for coding. With respect to the type of application, the right programming language is chosen.Testing The software program testing begins when the code is generated. There are Different testing methodologies are available to solve the bugs.Maintenance Once the software delivered to the customer, maintenance phase is important for many reasons could change once the system is used by the clients. Bugs could happen because of some unexpected input values into the system and system directly affects the software operations. The software should be developed to accommodate changes that could happen during the post implementation period.3.4.2 Structured System Analysis and Design Method (SSADM)it is one of the methodologies that launch to analysis and design of IS. It is consist into sequence of stage sFeasibility set upAnalyze the case that you have at a high level, by using Data Flow Diagram to beg off how system is work and to think about the problems. These parts are including to this stageBuild up a Business Activity Model(BAM).Study the requirements.study the processing.Study data.Get logical view of present services.Define Requirements StageGet an idea about the old environment, by know the system requirements and recognized the business environment by modeled them by using a DFD and Logical Data Structure.Requirements Specification StageThis stage is to assist the management, by using BSOs will telling the range and functionalities to provide and present them. They also need financial and risk evaluations to be prepared, and require to be supported by outline implementation reports. These parts are including to first stageDevelop mandatory data model.Receive system functions.Grow user job specifications.Enhance mandatory data model.Develop specification samples.Build up processing specification.Verify system objectives.Logical System Specification StageOfficially this stage is to choice the practicable options. The development/implementation environments are particular based on this choice.Logical System Specification StageIn this stage Both Processes and logical designs should update, as well the dialogs are specified these parts are including to this stageClassify user dialogue.Define the updating processes.Classify enquiry processes.Physical Design StageThe purpose of this stage is to denote the physical data and process design. The way to define them is to use the language and features of physical environment and incorporating installation.These parts are including to this stageArranging for physical design.Supplement the specification of functions.Increase developing for both data and process designs.3.4.3 Rapid Application Development (RAD)15 Rapid application development is one of the agile method, it is shorten the life cycle and to bugg er off information system more quickly in order to respond to rapidly changing business requirement . it develops the projects faster and higher quality by using groups to gather requirements.Requirement planningUser designconstructionscutoverin requirement phase , developer seek to obtain input from users in order to determine set of system requirements.In the user phase, is based on the sample cycle, involving experienced users and developers. This phase is consisting of a sequence of workshops, each one of them may be takes three days. During this phase the Tool CASE is used to build the prototype.The construction phase is to produce or generate the code from the CASE prototype, and the new system is validated by users.The final phase is cutover. It is cover the system testing, users training and introduction of the system into the client organization.RAD has a number of obvious advantagesResistance to change in the organization is minimized and the new system is welcome, becaus e of the high degree of users interest in the whole process.The system is developed and delivered more quickly than with traditional development approaches.The speed of the development and the use of relatively small teams means that the RAD tend to be cheaper than their traditional counterparts.The speed of RAD means also it is closely related to current needs of the business.3.4.5. Soft System MethodologySoft systems methodology (SSM) was developed by Peter Check land and his colleagues atLancaster University in the 1970s 19. It is designed to shape interventions in the problematic billets encountered in management, organisational and policy contexts, where there are often no straightforward problems or easy solutions. Though informed by systems engineering approaches, it breaks with them by recognizing the central immensity of perspective or world-view in social situations. It differs significantly from the systems science approaches developed in the 1960s, and is more reflect ive of action research in its philosophy and approach.SSM is widely described as a seven-stage process, as follows1. Identifying the problematic situation that it is desired to substitute in2. Researching the situation and building a rich picture (interpretive representation) of it3. Selecting perspectives and building root definitions (key processes that need to take place within the desired system)4. Developing a conceptual model of the change system5. Comparing the model with the real-world situation6. Defining the changes to be implemented7. Taking action.Stage 1 finding outis concerned with identifying and providing a brief description of thesituation it is desired to intervene in.Stage 2 modelingThis stage is concerned with producing definitions of transformation processes that should achieve the desired intervention(s).Stage 3 dialogueConceptually the dialogue stage involves examining the change model against the real-worldsituation, usually as represented by the rich pictu re and associated analyses, and checking that it makes sense. Often the change model needs adjusting, and sometimes the rich picture needs to be developed further.Stage 4 defining and taking actionThis stage will vary depending on the specific change project, but essentially it involves developing the (revised) change model into a concrete