• 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. GCSE Database Project ICT

    The report is saved and printed and the Mail Merge is created and the query results linked with word (having the template already completed) the relevant information. Fields Required, searches, sorts and reports that will be needed Fields Table Fields Field Type Table Fields Field Type Patients Appointments Patient ID

  2. ICT database newer identify

    He creates the card by designing it on Microsoft publisher and printing it off using a dot matrix printer and laminates it. He also keeps a paper record. It has a table with the same details as on the card and the name of the DVD rented and the date it must be returned by.

  1. Design Section

    box -source from the staff table, column 1 on the login page Title on the Customer Details Page Text List box - source from the customer title list on customer details page Gender on the Customer Details Page Text List box - source from the customer title list on customer

  2. Organising the database at Costsloadsless.

    o If you lose the card all the information has gone. o You don't need to remember anything because all the information is stored on the card. o If the computer is having trouble recognising the card then there will be no other way of getting hold of the information.

  1. Smarts Leisure Park Database Booking System

    - Customer Data I will need data about the customer such as Name, Age, Gender, Address, DOB, and E-Mail. This data will come from the customer, giving the details on booking. It will be entered by the receptionist. - Activity Data I will need data about the activity such as

  2. System requirements analysis

    They are also very good according to costs as they are much cheaper than LCD's. The disadvantage of using a CRT monitors are that they consume a lot of space and they are also quite heavy. CRTs are not as bright s LCD's and are not as sharp.

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

    to give an image to your public without having to meet anyone. The drawbacks for the website for my patient are that they might not have internet to go on to the website. They will have to go to the dentist that might be far away just to get an

  2. Create a database solution for a college tutor.

    Windows XP. Include the cost, necessary upgrades. Existing hardware that my user has access to: > 1.1 GHz processor. > 16 MB Ram > 6 GB Hard Disk > 3.5" Floppy Disk > 17" Monitor > CD ROM > Keyboard > Scroll optical mouse > Inkjet colour printer > 56

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