• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

IT Database Identify Section

Extracts from this document...


Identify * Background of Business My database is going to be about a pet shop. It is called "Paws'n'Claws". It is a large pet shop with many breeds of different species. It is not a chain but has one large store that is 14000 square meters of floor space over two floors and employs 180 staff for a range of jobs including pet care, stacking shelves, working the till, assisting employees, filing or managing. It is located in South West London. The pet shop has members with different levels of membership. They receive a percentage discount on certain discount on certain pet shop accessories. The pet shop sells a range of animals plus breeds and crossbreeds of those animals. It also sells accessories that are adapted especially for each animal breed and size. If you buy a pet and become a member at that point you get percentage discounts for every accessory that is adapted especially for that animal. * The System When somebody comes in to buy a pet in the shop they choose the pet and that pet has a price which they pay at the cash register. ...read more.


The shop records are all kept in paper copies in the form of receipts and records of purchases, memberships and pet check ups. These records are made by filing staff but an immediate record must also be made by the till staff. All records must be kept due to tax requirements, mandatory pet shop requirements from the NPSA (National Pet Shop Association) and also just for personal shop records. * Drawbacks of the Current System One drawback of the current system is that members of staff require a lot of training to be able to remember the species and all the implications that come with buying those animals. The staff member needs to learn every animal and whether check ups are needed; how often those check ups are required; what type of accessory the animals must come with and also some must learn how to use the membership card reader. This training is time consuming and mistakes can easily be made. The information they currently must know is stored in a word document and is distributed to all staff members. This is a waste of paper and is bad for the environment. ...read more.


The database would be free to make and the PDAs would have little to no running cost, unlike the Blackberries that would cost money to run the internet on them. * User Requirements o Must store members' information such as contact details, address, transaction history, pets owned, check ups required, date of last check up, unique member ID, date of birth and membership type. o Must store animals' information such as breed name, size, weight, colour, price, mandatory accessory requirements, check up requirements and unique pet ID o Must store accessories' information such as price, pet aimed at, eligibility for percentage discounts for members and unique accessory ID. o Must link members' information with what they have the right to discounts on. o All viewable tables, queries, forms and reports must be clear and viewable on any size screen. o Must be easy to use with little to no training required for even staff with no experience of IT based tasks. o Have a field for "current date". o Send letters to those that have not visited the store in the last month telling them about any offers that may be on in the shop at that time. ?? ?? ?? ?? ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. Creating a computer system for a video rental shop

    The presentation of the results would better in a form this is because of a number of reasons, which include: * It is easier to read from forms than tables. * Forms display one record at a time, rather than all of them at once, like on a list, which make it harder to isolate one particular record.

  2. Smarts Leisure Park Database Booking System

    I will extract all of the information from "tblBookings" I will produce this query in a similar way to the first one. I will extract all of my data though from the Bookings table: First I clicked on the wizard for creating a Query.

  1. System requirements analysis

    Below is a screen shot that shows the patients records: The software allows you to view different aspects of the patients' details. The doctor can search for a patient by typing in their surname or their first name. Having a small search engine like this would save the doctor a

  2. Different types of technology How I use ICT at home and at school

    the periodical payment as I already pay a periodical payment for my internet. Another periodical payment would go over my given budget and I would have to cut one or the other, with the obvious cut being the PSN as internet is too valuable to me.

  1. Organising the database at Costsloadsless.

    easy to use & easy to understand form for customers to use to join the store I shall make sure that the form has all the relevant fields (name, post code, etc...) An accurate easy to read & understand, detailed form used by customers to join the store.

  2. GCSE Database Project ICT

    The receptionist and the Dentist can either have synchronised computers or have computers on a network. When the receptionist has to send reminder letters multiple criteria can be used to search and manipulate data. After she has found the results of the search she then can connect to Microsoft Word

  1. Design Section

    Using Spreadsheets I can also use formulas. This will save me time as it is just like a calculator and is linked to different cells so if one cell changes the main cell will also change. Lists of inputs, outputs and processes Inputs Data Item Data Type Data Range Staff Name on Staff Login Page Text List

  2. Benefits and drawback for patients and staff of using a database system

    The benefits for my website for my staff is that they can answer patients question much better by looking at the website that has lots of information also if you have new information for the patients you can update the website easily and quickly and you can personalise the website

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work