Supermarket Database-Computer Coursework Essay Example for Free

Supermarket selective informationbase-Computer Coursework Essay cosmosThere are many supermarkets around us, but there do you know how it works. In this coursework., we willing anyalsis the problem of the old supermarket strategy and how to solve this problem.Besides, in this coursework, it will allege a new supermarket system, introduce its advantage, how to fit out up, how to use it and what is its advantages.Old supermarket systemDisadvantagepiles of papers are used to make unnecessary on the recordsit is hard to back up the records, if you really do so, the cost of the ink and the papers put forward instal you bankruptthe payments are calculated by men, if your mathematics is poor, you will bankrupt againyou necessitate to drip nights after nights to turn the pages by your hands in modulate to search the data of the guests and supplier collect publicise off is used, which means time and money is wastedyour customers endurenot immediately get the most up assure d iscussion of your convergence, simply the million-dollar contract will fly to other companiesthe piles of paper wont instigate you when your harvesting is expired, you need to search through the papersit is not easy to comunicate to your fall apart stores. Many role players are call for to check the storeSolution of the problemTo solve the problem in the old supermarket system, apparatus up a database system that would control local store inventory, and cover the stateing of stock from the customers.Advantages of the new systemdigital record is used. Millions of selective information are stored in a 6-inch hard-dish.The records can be backed up at bottom a DVD or a hard dish drive.the payments are calculated by computer, which decreases the large-minded-hearted errorIn redact to search the data of the customers and supplier, you simply need to type the name, or tel. fall.e-mail is used, your customers can get the most update news of your product, at oncethe computer will remind you when your product is expired, so you can make preparationsyou can communicate the computer form one branch store to another. Information can be transferred immediatelycomputer can do most of the jobs. less(prenominal) doers are employedOld systemComputer systemSpace needed to keep the records moreMuch lessBack upVery difficultVery easyerror postgraduate possibilityLow possibilitySearch dataVery complicatedVery convenientmailS showtime and expensiveQuick and freeCheck expired stockBy hand automaticallyCommunicationSlow and inconvenientQuick and easy fleck of employeesmoreless destiny of the system.It is regard that the supermarket has original system which has only one computer with the undermentioned equirement. working(a) systemWindows 2000, standard variationProcessorPentium III 733Mhz,RAM256MB recommended thrusting quadriceps20GBVideo32MB shared ramIn order to r each(prenominal) the requirement of the new system, the computers need to replace new ones and con nected as the pursuit instructions.Requirement of the server.Working systemWindows server 2003, standard editionProcessorPentium 4 3.0Ghz, 550+ MHz recommendedRAM1024MB/1G recommendedDrive space250GBVideo128MB shared ram or betterThis computer is highly security. It needed the join check and the password of the three highest jitney to open the report of the profit and also to open the economy condition of the supermarket.Besides, the server is connected to a internet server with domain name. This is because this can convenient the customers to shop or order products from the internet.Requirement of the other computersThe other four computres is used to save data. They should beget the following requirement.Working systemWindows XP, ProfessionalProcessorPentium 4 3.0Ghz, 550+ MHz recommendedRAM512 MB recommendedDrive space80 GBVideo128MB shared ram or betterSoftware of the programmeThe supermarket can use Microsoft Access or Visual stapleThe advantages of using MS Access are* I t is a relational database, which makes the data management easier.* It integrates easily with other Microsoft packages such as Word and Excel.* It is inexpensive.* It is a fictile product that cab be used for all kinds of databases.* It can be used to build spacious database applications.* All the information is held in one place and the information only needs to be updated once.* It can retrieve and update information quickly and easily.* Reports, standard letters can be easily produced.* supporting and archiving is easy.The disadvantages of using MS Access are* It lacks in high volume capacity.* It is limited to a low transaction rate.* It can bring down the entire servers if it is not used properly.The advantages of using Visual Basic are* It provides a user-friendly interface.* The modular structure in optical basic program helps the coder to develop a large program without knowing all the variables and their relationships.* It is provided by an integrate development envir ons that helps the programmer in debugging syntax errors.The disadvantages of using Visual Basic are* It is limited in the kind of application that visual basic can code.* That tag onitional memory might be required because of the graphics.* That visual basic is not a matural programming language.* That successful operations are crucial.* It has a slower bear on in many applications.* It is more difficult to recover.Set up of the programmeIn this system, the programme is base on the Microsoft AccessCreate a new database file first and then create a table which should contain the following keepsake* Image of the* power point description* bar code* gunpoint code* item location in store* price* maximum (amount to order)* current stock* date ordered* date received* quantity received* expired date* supplier* supplier cross* supplier email* supplier telephone number*The characteristic of each item of data, such as The data on the documents have been analysed, where on the next pag e tables have been completed to show what information is contained. The information that is contained involves* What tables and column are presented.* The names of the current tables and columns.* Any validations on the values of certain columns.Data ItemDescriptionData TypeValidation* item descriptionThe description of the producttext* bar codeThe bar code of a product text editionLetters only* item codeThe code of a productTextLetters only* item location in storeThe location of the product in the supermarketTextLetters only* priceThe price of a product song* maximum (amount to order)The number of product in the supermarketNumbers* current stockWhether the obligate is hardback or paperbackTextLetters only* date orderedThe order of the product by the customerNumber* date receivedThe order of the product ordered by the customersNumberAfter create the above table, by using the Microsoft Access, a new table will be created to input the data of each product.Besides, to show the out an d in of each product, by using the Microsoft Access, a report can be created.Shopping from the InternetSome customers will order products from the internet. Therefore a website should be set up for their confident. In order to get associate with the system, roughly more items are needed to create in order to record the information of each customer. It can be through as shownContain of the tableThis table is about the information of the customers which order products from the internet. The table should contain the following item* customer name* Customer no.* address* Contact method* Phone number* Credit card numberData ItemDescriptionData TypeValidation* Customer nameName of the customerText* Customer id.The id of the customer in the systemnumber* AddressThe home address of the customerTextLetters only* Contact methodHow to contact to the customerE-mail/phonechoose* Phone numberThe mobile/home number of the customerNumbers* Credit card numberThe Credit card number of the customerN umberThis website should also be think to the main server of the supermarket and the website should have the following function.FunctionA laiding form will need to be printed, which will accompany the freight rate to the store, and should include the following information* (from) address of supplier, (to) supermarket ID,* supermarket address,* department,* handlers name* and order number,* as well as a list of item descriptions,* item codes,* amount requested,* and amount sent.When the shipment reaches the store, the manager initials the bill of laiding, confirming that the shipment has arrived. This form is then returned to the warehouse where an invoice must be generated. The invoice, which will be sent to the store should be in some form that can both be printed (and subsequently mailed), or simply sent via email to the specific store.The proccess is done as shown. job of the securityAs it is easily to shopping on the Internet, and is easily to hacked by the hackers in the In ternet and the person-to-person information of each customers will be stolen. Thus, to prevent this happen, security is needed.SECURITY of the systemThis system requires some form of a hierarchical security system which should consist of three categories.* Level one entrance should be for the Head managing director. The Head Manager should have rile to everything in the system, and should be able to add new people to the system, and delete them when necessary. It should also be possible for the Head Manager to easily transformation people between different security levels, and to add/delete departments as required.* Level two access should include privileges for Department Managers. These managers should have complete access to everything in their department, including the placing of orders and allocation of access for cashiers/stockers in their departments. However, they should not have access to any other department functions* Level three access is intended for cashiers/stock ers. essentially they should be allowed to change the amount of stock in the current inventory, either through the selling of an item to a customer, or in the stocking of shelves with new inventory.In order to nominate the power of the different manager in the system to ontogeny the security. The table should contain the following items* Worker ID* Worker Name* Working position* Power of the worker* Date of birth* Address* Phone numberAnd then setup the table ass shownData ItemDescriptionData typeManager IdThe Managers IDNumberManager nameManager nameTextThe working positionworking position of the managerTextPowerPower of the worker in the systemTextDate of BirthBirth of the workerNumberaddressAddress of the workerTextPhone numberPhone number of the workerNumberThis table is used to input the data of each worker in the supermarket. It also identify the power of the worker in the system. It decides what the worker can see in the system.Work and power of the managerManagers also ha ve the ability to cancel an order altogether, and to change the supplier. As new products hit the market, they should be able to add a new item to the database. Similarly, managers should be able to delete an item from the database in the case that it may not be selling, or is discontinued by the manufacturerSome mechanism allowing the manager to adjust the information contained in the database will be a beneficial tool. This mechanism should include among other things the ability to change the product point of order value, change the product maximum order value, transfer items between departments, and add and delete departments as necessary.Changing current inventory stock is a function that should be given to everyone in some form. For example, cashiers will automatically decrease the item debate when a product is sold to a consumer. Stockers and/or managers will also need the ability to increase current stock count as new stock arrives.The order form should contain the default amount of stock to be ordered for each item, and should be able to be adjusted by the manager under special circumstances (such as a promo). When the manager gives his/her OK to the system, the system should send the order to the warehouse.If some product has been ordered, and it takes a while for that product to arrive, we do not want the selfsame(prenominal) product ordered several days in a row. The system must contain some sort of list of items on order. As the items received come in, they should be taken off this list.The objectives of the proposed system are* To make grease ones palmsing things an easier process.* To produce reports on overdue books.* To check which products are currently on tap(predicate) in the supermarket.* For the staff to be able to obtain information of who has ordered a particular product.* To keep a record of customers and their details.* To be able to add, edit or deleted details concerning the customers* For each customer to have a unique id in c ase two people have the same name* For each product have a unique id* The system should only allow authorised people to the data. task of this systemWhen using the Microsoft Access to setup the programme, it will take a long time to set up. As it needs to create a lot of tables, besides, each table is linked together and entirely linked to the server to the internet. When linked to the internet,it is difficult to get a good domain name. Also, it is easily linked wrong.Solution of the problemTo solve the problem* First, set up the system more carefully.* Try to buy a good Domain