• 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

    Of Birth Date Other Details Text Searches The searches needed for this will be the search for patients who have not booked within the designated time so a query will be needed to enable the search I will need to search upon the appointments table, under the appointment date and

  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.

    swipe card system will work by containing all the information for one customer - from name, address , name of DVD/ video and the date is due back, when the card is swiped through the computer all the information will automatically be transferred on the computer screen, **advantages** **disadvantages** o You don't need to again rely on staff.

  1. Smarts Leisure Park Database Booking System

    It also needs quite a lot of ram to deal with the demands of the database. Data Requirement I will need certain data to make my booking system work. This data is the Customers, Activities and the bookings that are made.

  2. System requirements analysis

    CRTs also emit electrical, magnetic, and electromagnetic fields, which are harmful for not only the patients but also the receptionist. It may also interfere with hospital equipment. The next output device that I shall be discussing is the printer. There are three types of different printers and I shall be discussing advantages and the disadvantages of each one of them.

  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