This project will aim to solve the information handling problems of Mario's Game and Video Masters Rentals.

Authors Avatar
This project will aim to solve the information handling problems of Mario's Game and Video Masters Rentals.

Mario's Game and Video Masters Rentals is a rental store that rents videos, games, and now DVD's (newly added) and is run by a man named Mario Anderson.

To provide these services information is collected and stored about the items, and the members. Information about each member is written on a card, which is then put in to a card index box, which is sorted out by the member surname, then forename, then member number. Information about the items is put onto a card, which is then put in its case. After each day, a shop assistant writes loans list of all the items that have been rented out, along with the member number and video number, and name.

What happens in Normal circumstances?

When a member wants to rent out a copy, the customer must take it from an empty case from the shelf with the item 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 will receive a new card. The person's old card for the store is destroyed, and the new one is put in the box .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.
Join now!


At the end of everyday, the loan lists are searched to find out if there are any overdue items. Then, by hand they must write a letter to the corresponding people.

What happens in Special circumstances?

When a new member joins, he must pay a joining fee of £5.00. Their details are stored on the card and placed 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 ...

This is a preview of the whole essay