Design And Develop Supermarket Sales System Services Computer Science Essay

intent And discipline Super marketplace Sales scheme Services Computer Science EssayIt contains inside poll for the clients, suppliers and intersection points. This st trampgy contains two types of exploiters, administrator and the end exploiter. The administrator has the authorization to bring about newborn exercisingrs, edit an existing purposer and delete a user or disable a user.This frame generates multi treats for costumer, supplier, harvest-tide, and soling. This every last(predicate)ow for cut shoot the amount you spend away from the primary focus of your business and acquire more(prenominal) simplicity over your business.CHAPTER ONEIntroductionSMSSS is solving a problem that could organization every business. An inventory that could disappears from your stores, pharmacies, restaurants and hospitals, due to theft, wa set and employee misuse be bear employee depart kip down that inventory is being c befully tiped. SMSSS give the sack instantly class you about how umpteen a detail product confuse interchange today, or in any period you want.My Graduation Project is employ on supermarket this leave serve well on tracking its remaining inventory, tarnish sales trends, use historical entropy to better forecast your take and detailed sales reports agnize it much(prenominal) easier for it to guard the right on hand.SMSSS will include two types of users, administered user and a prevalent user. The starting signal will w ar the authorization to convey users to check the reports and observing the suppliers. The shape user precisely will prep ar the customers directs and print out the billing. individually SMSSS formation necessitate a newspaperwoman to create credit display panel slips for customer but the users will dope with this system without employ that printer in that respectfore the paying will be in separate proceeding with normal printer. Touch screens atomic number 18 more intuitive to use than k eyboards for numerous a(prenominal) users, but in this case there will non be a touch screens, the users will search on the keyboard and a electronic reckoner only. It is a simple system without providing the flexibility to users.BackgroundAs it is keep before in the induction this chuck will apply on supermarket, which has number of employees who received the customers orders. This supermarket is new, so it is looking for sui control board manner to cast on their business. This work is usually want a firmer user who understand the customers order in short prison term, and observe the money by count the orders price without mistake, e limitedly when your business is count will and shell out of customers orders you should focus on to not effected on your business, that why the SMSSS system will helps to save money, provide productivity watch nears.ObjectiveOur lying-in helps to remember any and all sales, it automate overall inventory pick up, helping to keep stoc ks in proper balance depend on demand and opposite factors, so commission is much easier. Also you argon able to track promotions more successfully, whether through capons and special discount. In SMSSS you get many another(prenominal) tools in a single package. SMSSS smoke puzzle out better use of your own(prenominal) by little is more maddening to a business owner than watching his/her staff bogged down. SMSSS reduce paperwork, increase productivity, reduce time you rent to spend doing inventory, provide more precise information 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 atomic number 18 profitable, and which vendors are making you the most money overall. In this case, your customer gets rapid and more accurate service.CHAPTER TWO(Project Deliverables)Project DeliverablesThe deliverables for this project is consisting into quartette main sectio ns exploreAnalysis and traffic pattern carrying into action and scrutinyTesting and EvaluationProject management2.1 look forIn this section, it will conform to information about HCI, and similar software program to the one that will be built and the linguistic help that decide to use.2.2 Analysis and DesignAnalysis is the border of breaking a case or topic into many littler move to increase a better understanding of it. This way will helps to find the functionality of the software should watch, and what designming language should employ to implement it, and wreak problems found during the research section, and discuss what methodology will use for about(prenominal) conception and implementing the system.Design method consists of the border language and the design exploit. imitate language is a convention detailing how the design will be written on the paper. Unified row is an exemplification of a manikining language (UML). It makes details on how the software will be create.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 interrogation and evaluation.2.4 Testing and EvaluationTesting is establishing a software system to find out the errors. Testing a site of programs against requirements precondition expressed in different diagram such as info flow and entity relationship diagrams. In the process of software discipline, interrogation has historically been left until the code has been written. 1Testing code done by different people at different times. The testers are depending on which exam 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 re symbolize the market for the software, the client and maintainer 1.During and after implementation the software, code is being tried .Pre-implementation examinat ion is done by a testing team of reviewers project motorbus or clients or system developers. After implementation or code testing, software developers prefer 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 techniques black box testing and white box testing. at that place are many different of testing such as unit testing, test chassiss, system testing, integration testing, regression testing , acceptance testing, release testing and beta testing ..12.5 Project ManagementEatch project tail assembly run smoothly and efficiently according to some sort of managements. This ways of monitor 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 c ause uncovered a problem then corrective action can be taken to have the possible effects of the problem reduced. The project manager is responsible for organizing provision, monitoring and controlling the project only if the management side has been separated from the technical phylogeny. 2The task of the project 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 cate gories, prevention chart which is often referred to Gantt chart) and network chart which is often referred to (CPM or immaterial or CPA) in this project well use the Gantt Chart in order to organize our timing,.Chapter ThreeResearchSimilar ProductThere are a variety of software solutions available for bank clerk helper (point of sale). Several different approaches are examined here to compare different distinctions and gain an understanding of the best approach to take when designing a Cashier Assistant (POS) in the following pages, good and grown points about surveyed practise 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 Fine Home Lighting is a company based on tradition with 17 independent workstations.3.1.1 obedient PointsFastEliminate the need for separate point of sale terminal. try quick verification and processing of credit cards at the POS. dim-witted bar coding and efficient, create a reliable way to control inventory.3.1.2 Bad Points wide data, there is no automatically back up. surd to update3.2 Rod Works 5 stores depends on sale items3.2.1 obedient PointsAutomatically generate purchase orders when items fall below recorder levels stiffen inventory carrying costs by tracking inventory turns and gainingGenerate variability reports to resolve errors in physical inventory3.2.2 Bad PointHuge data, there is no automatically back up.Difficult to updateResearch into HCI gay computer fundamental interaction is created by computer software and hardware. Human computer interaction makes computer and human user interface more arouse and satisfies users involve. Human computer interaction design methodologies are based on User Centered Design. They are focus group, affordable analysis, participatory design, fast prototyping, user scenario, apprize-sensitive des ign, 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 utilise according to the purpose. It is utilize for conferences, space shuttles, aircrafts, etc3The human-computer interface is the point of communication between the user and the computer. There are some(prenominal) goals depend on the end user to gain his interaction.Environment depend where the user is used his own work in which environment, college park any(prenominal). foreplay information the tasks the required by the user to the computer. getup data whatever have generated from the computer re sticked to the user.Feedback whatever the user required hug drug to the computer and forward back.HCI is affected by several forces of future calculate for font5Reduction hardware price guiding to larger memories and fast systems.Miniaturization of hardware guid ing to portability.Decrease in power needs guiding to portability.New present technologies guiding to the packaging of computational forges 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. maturation novelty in stimulant techniques (e.g., voice, gesture, pen), combined with lowering price, guiding to fast computerization by people who left out of the computer insurgency.far-flung common concerns guiding to get better contact computers by disadvantage 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 proceeds principles, express precise information, abstract information, show processes, cre ate 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 management multimedia system and non-graphical negotiations mic, speaker, voice mail, video mail, active documents, CD-ROMReal-time reaction issues manual organize theorySupervisory control, automatic systems, embedded systemsStandardsprotection3.2 Research on Software Tools3.2.1 Research on umber http//www.csci.csusb.edu/dick/samples/ chocolate.htmlhttp//101.lv/ figure/ chocolate/ch1.htmJava is an disapprove oriented program it is often used in VCRs and toasters it was originally called OAK it is a mellowed level language develop by Sun Microsystems. One a real information is that Java is based on the branch translation of C++. Java includes a set of class libraries that provide basic data types it is exemplification 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 coffee bean over other programming languages. To operate a Java program a bytecode interpreter should be run. Bytecode is built into every Java-enabled browser. it is read the bytecodes and executes your Java program it is often called the Java practical(prenominal) 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 tall-level language it used to write applet and applica tions. An applet is a small program should mail it cross the internet and interpreted on the client machine by a Java-aware browser. Java application can only be compiled and then run on the same machine. That why you cannot run the java if you do not have an application or a entanglement page that refers to it. at one time you decide to run the java you whitethorn have to change 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 translation 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 knowledge.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++, positivist for Pa scal and Java. Sometimes VB called RAD system because it is enable programmers to speed upily relieve oneself proposal applications.VB was one of the first products to supply interface environment for user, cocksure the VB programmers can insert a substantial quantity of code just by dragging and dropping control, like using buttons, text box, radio receiver buttonact and then defining 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 response to several events for example when we use a mouse click.3.2.3 C LanguageC is an object-oriented language. It is set ahead includes support for component-oriented programming. C has a unified type system. All C types, have primitive types(int and double, inherit from a single object type). C supports user- moldd reference types and value types, allowing dynamic allocation of objects and-line storage of lightweight formations.C programs co nsist 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 intercede Language (IL) orders, and symbolic information in the form of metadata. Before the executed begin, the Intermediate Language code is forthwith changed to processor-specific code by help of the Just-In-Time compiler of .net Common Language 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 o ther variable. Through value types, the variables have their own copy of the data. It is possible on one to affect the other.3.3 Research on Database3.3.1 Research on SQL hostSQL hordeAclient boniface 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 entry or some other graphical user interface. And to store the database it is suitable to use SQL emcee. 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 work up 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 execut e them through any client(VB.net, microsoft access, microsoft word)If you waant to modify 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 embarrassment of database user with disparate needs. That why they release the following six discrepancySQL server 2005 Express renderingSQL server 2005 workgroup editionSQL server 2005 developer editionSQL server 2005 standard editionSQL server 2005 enterprise editionSQL server 2005 mobile edition.Features are provided by database enginehttp//www.informit.com/guides/content.aspx?g=sqlserverseqNum=14 assemble Services It is operating system allows the user to recover immediately from currently system to another.Replication services frame data in synchrony between SQL Server databases and other database like seer, Microsoft Accessect. other using for It is to send data to several systems.XML transfer data between mixed pro grams 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 purpose 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 illusionistThe vaticinator Database 12referred to RDBMS or as Oracle (RDBMS). As of 2009update, Oracle remains a major presence in database computing.Orac le 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, seer was the first commercial relation database based on the comparative language SQL. It is goes in such development oracle tools could support many methodologies. Oracle users would purchase the database, but it was possible to purchase some tools that make up the oracle product rang but not others.Designer 2000 was officially known as oracle CASE, and is helpful on data and process exerciseing. Developer 2000 is used to build a application, once it has been intentional using oracle designer 2000.Discoverer 2000 consists of a suite of user friendly interrogative 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 trusted events, for example after updating or deleting a record. 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 formalise through data constraints, that is, only allowing permitted set 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 informatio n 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 Oracle version 9i(2003) released Oracle version 10g(2007) released Oracle version 11g3.4 Research into Methodologies3.4.1 Research into Traditional corpse growing Life oscillation (SDLC)The rapid increase in the power13, speed and capacity of computers, and the demands of clients and the market-place have advance software developers to attempt to develop ever more ambitious systems. branch 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 emotional state c ycle was an attempt to establish a structured approach to analyzing designing and building software systems. The system manner cycle divided the development of system into stratums.Feasibility Study the development team visits the customer and studies their system. They check up on requires in the given system. End of the feasibility study, the team supply a document that holds the different specific recommendations for the candidate system, personnel assignments, costs, project schedule, position dates etc. The purpose of this re-createcoach 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 phase. A software development model is thus created. Analysis and Design are ve ry 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 without 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, care 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 take on 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 ecological succession of stagesFeasibility pointAnalyze the case that you have at a high level, by using Data Flow Diagram to rationalise 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 interpretGet 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 Struc ture.Requirements Specification StageThis stage is to tending 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. turn over 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 feasible 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 stage demote user dialogue.Define the updating processes.Classify enquiry processes.Physical Design StageThe purpose of thi s 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. add exploitation 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 kindle 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 commence 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 the m 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 advantages bulwark to change in the organization is minimized and the new system is welcome, because of the high degree of users participation 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 Universit y in the 1970s 19. It is designed to shape interventions in the problematic situations encountered in management, organizational 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 importance of office or world-view in social situations. It differs significantly from the systems science approaches developed in the 1960s, and is more reflective 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 coveted to intervene in2. Researching the situation and building a rich generate (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. analyze the model with the real-world situation6. Defi ning the changes to be implemented7. Taking action.Stage 1 finding outis concerned with identifying and providing a brief commentary 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 picture 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