Marios Game and Video Masters Rentals Essay Example for Free

Marios Game and Video know Rentals EssayThis project exit aim to decide the schooling handling problems of Marios Game and Video Masters Rentals.Marios Game and Video Masters Rentals is a rental store that rents videos, games, and now DVDs ( upstartly added) and is run by a man named Mario Anderson.To provide these run information is collected and stored round the breaker points, and the phalluss. Information astir(predicate) each section is written on a card, which is then put in to a card index lash, which is sorted out by the member surname, then forename, then member topic. Information about the breaker points is put onto a card, which is then put in its case. After each day, a shop assistant save ups loans list of all the heads that pick out been rented out, along with the member number and video number, and name.What happens in Normal circumstances?When a member complimentss to rent out a copy, the customer essential take it from an empty case from the sh elf with the level card inside it. When he/she hands it into the counter, the shop assistant takes the card out and looks at the video number, and then takes the member number from the customer.If the member has lost their membership card, then they must pay a fee of 2.00, and forget put one across a new card. The persons old card for the store is destroyed, and the new one is put in the niche .The shop assistant then asks the customer how many days he or she will want to rent it for, and writes it on the item card. The shop assistant then hands the item over to the customer. When an item is returned, the shop assistant goes back to the loan list from the date of rental. He or she then crosses it off. Then, he or she puts the case back onto the shelf and the item behind the counter.At the end of everyday, the loan lists be searched to go through out if there are any neglectful items. Then, by hand they must write a letter to the corresponding tribe.What happens in Special ci rcumstances?When a new member joins, he must pay a joining fee of 5.00. Their dilate are stored on the card and dictated in the index box in order. The shop assistant then gives the new member a membership card.When a member leaves, hand in their membership card, and their card in the index box is taken out and destroyed.When an item is bought, an item details card is filled out and put in the case. The actual item is put behind the counter, and the case with the card inside is placed on the shelf.When an item is sold because it is non popular any more than, the video card is taken out and destroyed.What Problems do the current ashes cause?The current carcass causes the following(a) problemsMembers lose their membership cards. They must pay 2.00 for a new one.Somemagazines the cards go missing, so then new ones must be written out, and that is preferably time-consuming.Sometimes, when different shop assistants write out the video card, other assistants may not be subject to read the others handwriting, which leads to huge error e.g. a 4 written could look like a 9.A members card or an item card could be misplaced and could take a lot of time to findIt is very time consuming when a shop assistant must look through and through the loan lists and write the reminder earn.When customers ask the staff whether a particular title is available, the staff will not be able to know it unless they have a particularly good memory.How could Mr Anderson solve the information-handling problems?Mr Anderson could solve their information handling problems by utilize a filing cabinet to store their information about members and items using detail cards. The advantage of this organisation is that much more information tolerate be stored using this system. nevertheless the disadvantages are that these could be misplaced, lost or damaged, just like the existing system. Unauthorised people quarterful take some records. It would also be quite time consuming.Another way of work the problems would be to use a computing machine to store information about members, rentals, and items.The advantages of this system are that it can store a lot of entropy in a small space, searches through it very quickly. But computers can be quite expensive.There are two ways a computer can be used. You could write a program to solve all the information-handling problems, but I do not know how to write programs on the computer and it is very expensive to pay a programmer and it would be time-consuming. Or, you could use an application package such as a database. This database could store and form all the information about members, items, and rentalsWhat is the best way out of the solutions?The best way to solve the information handling problems of Mr Anderson will be to set up a new system using a computer. I have unconquerable to use a computer because* Computers can store large amounts of data in a small space.* The information can be searched very quickly* Lists and reports about the information in a computer can be produced very quickly and easygoing.* There is already a computer that can be used (Mr Anderson has two computers at home, one of which he does not use)I have decided to do this using an application package because* I do not know how to write computer programs* There is a wide variety of application packages* Application packages can be changed and customised to suit the needs of the user* Have used different application packages I the pastThe most suitable vitrine of application package will be a database because* Database packages are specially designed to store and process information.* I have used database packages before, so I know a lot more about these as oppose to packages I have never used beforeWhat must the new system be able to do?The new system must be able to perform the following tasks* Allow member details to be looked up, edited and stored quickly, easily and accurately* Allow item details to be looked up, e dited and stored quickly, easily and accurately* Allow rental details to be looked up, edited and stored quickly, easily and accurately* Allow item details to be searched to answer customer enquiries quickly and easily* bring forth a report listing member and video details for overdue items.* Produce reminder letters to members with overdue items.The following criteria will be used to evaluate the success of the new system* The system must be able to store at least 10 member records* The system must be able to store at least 20 item records* The system must be able to store at least 10 rental records* It must take no long-lasting than 30 seconds to find and display a rental, item or loan record.* It must take no longer than two minutes to answer customers enquiries by entering search criteria and finding matching item* It must take no more than one minute to find and delete a member, item or rental record* It must take no more than two minutes to find and edit a member, item or re ntal record* It must take no more than two minutes to create a new member, item or rental record* On-screen data entry forms must be clearly laid out to make data entry easy* On-screen data entry forms must use automatic data validation to reduce data error on input* It must take no longer than 5 minutes to search for members with overdue video and produce a summary report* Reminder letters to customers with overdue videos should be clearly laid out and include all the details of the videos that need to be returned.