Supermarket database-computer coursework Essay Example for Free

Supermarket database-computer coursework Essay Introduction There are many supermarkets around us, but there do you know how it works. In this coursework. , we will anyalsis the problem of the old supermarket system and how to solve this problem. Besides, in this coursework, it will introduce a new supermarket system, introduce its advantage, how to set up, how to use it and what is its advantages. Old supermarket system Disadvantage: piles of papers are used to keep the records it is hard to back up the records, if you really do so, the cost of the ink and the papers can make you bankrupt the payments are calculated by men, if your mathematics is poor, you will bankrupt again you need to spend nights after nights to turn the pages by your hands in order to search the data of the customers and supplier snail mail is used, which means time and money is wasted your customers cannot immediately get the most update news of your product, simply the million-dollar contract will fly to other companies the piles of paper wont remind you when your product is expired, you need to search through the papers it is not easy to comunicate to your branch stores. Many workers are needed to check the store Solution of the problem To solve the problem in the old supermarket system,setup up a database system that would control local store inventory, and cover the ordering of stock from the customers. Advantages of the new system Digital record is used. Millions of information are stored in a 6-inch hard-dish. The records can be backed up inside a DVD or a hard dish drive. the payments are calculated by computer, which decreases the human error In order to search the data of the customers and supplier, you simply need to type the name, or tel. number. email is used, your customers can get the most update news of your product, at once the computer will remind you when your product is expired, so you can make preparations you can communicate the computer form one branch store to another. Information can be transferred immediately computer can do most of the jobs. Less workers are employed Old system Computer system Space needed to keep the records more Much less Back up Very difficult Very easy error High possibility Low possibility Search data Very complicated Very convenient mail Slow and expensive Quick and free Check expired stock By hand automatically Communication Slow and inconvenient Quick and easy Number of employees more less Requirement of the system. It is consider that the supermarket has original system which has only one computer with the following equirement. Working system Windows 2000, standard edition Processor Pentium III 733Mhz, RAM 256MB recommended Drive space 20GB Video 32MB shared ram In order to reach the requirement of the new system, the computers need to replace new ones and connected as the following instructions. Requirement of the server. Working system Windows server 2003, standard edition Processor Pentium 4 3. 0Ghz, 550+ MHz recommended RAM 1024MB/1G recommended Drive space 250GB Video 128MB shared ram or better This computer is highly security. It needed the voice check and the password of the three highest manager 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 shopping or order products from the internet. Requirement of the other computers The other four computres is used to save data. They should have the following requirement. Working system Windows XP, Professional Processor Pentium 4 3. 0Ghz, 550+ MHz recommended RAM 512 MB recommended Drive space 80 GB Video 128MB shared ram or better. Software of the programme The supermarket can use Microsoft Access or Visual Basic The advantages of using MS Access are: Â  It 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 flexible product that cab be used for all kinds of databases. Â  It can be used to build extensive 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. Backup 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 visual basic program helps the programmer to develop a large program without knowing all the variables and their relationships. Â  It is provided by an integrate development environment 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.