• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22

I have been asked by a General Sports shop using a manual system to design a database.

Extracts from this document...


ICT Coursework By Kaleem Sajad 11H1 Table of Contents Situation: 3 Analysis 4 Searching 5 Sorting 7 Back-up Procedures 9 Printing options 10 Data Security 11 Input Devices 12 Computer Processor 13 System Specification 14 Questionnaire 15 Letter 16 Validation and Verification 17 Data structure 18 Program Structure 19 Testing 20 User documentation 21 Evaluation 22 Situation: I have been asked by a General Sports shop using a manual system to design a database. Using this database they will be able to keep track of members, print out information, use the database for emergency contact and so forth. The problem with there old system was that they could not search quickly for the items they needed e.g. football boots in a certain size, if they could have a computer to do this for them rather than having to search through lots of paper they would save time and the customer will be more satisfied with the service. They could not sort products into manufacturer, price etc. They need to store their information on one computer rather than lots and lots of pieces of paper, this will save them space and it will be tidier. They where not able to print out there list of stock for customers so they would have to walk round and search manually. They could use the database to send out leaflets with information about stock on so people could see what they sell. ...read more.


Mouse PACKARD BELL INTER MOUSE Price Inc VAT �14.99 Features - 3 buttons - Scroll function - Ps2 / USB Connection - Scroll function 2. Scanner 3. OMR 4. Keyboard Microsoft Internet keyboard Features - Customisable hotkeys - Direct Internet access - PS/2 compatible 5. Microphone Computer Processor Computer processors are needed to complete the job. Saving data, security, editing data, adding, deleting and changing records or data. To do these a program will be needed, I have selected Microsoft Xp office edition for the sports club. PRICE INCLUDING VAT �259.99 It features: Word, Excel, Outlook, PowerPoint 600x1200 dpi resolution Standard Edition 42 bit colour depth A smarter way to work USB interface Effective collaboration Includes Photo suite III Reliable tools System Specification This is a table showing all the hardware and software the sports club will need to get started, it also includes the prices of the hardware and software. System Specification Hardware Total Type Description Supplier Cost Quantity VAT Cost Computer Elite Business Plus Mesh �992.88 1 �173.75 �1,166.63 Printer MINOLTA DESKLASER Magi colour �999.99 1 �175.00 �1,174.99 Monitor 15" TFT Proview �249.00 1 43.575 �292.58 CD-RW 16x10x40 Buslink �119.99 1 �21.00 �140.99 Mouse Inter mouse Packard bell �14.99 1 �2.62 �17.61 Software Database Access Microsoft �125.00 1 �21.88 �146.88 Operating system Xp office edition Microsoft �259.99 1 �45.50 �305.49 Virus remover Virus Scan McAfee �24.99 1 �4.37 �29.36 Additional Costs Mouse Mat Microsoft �3.50 1 �0.61 �4.11 Total ...read more.


Technical guide Amending fields- Click on a field then highlight the text in it, then type in what you want the field to say. Evaluation In my specification I have said that the user should be able to input data. I have given them sufficient equipment to input the data they need. They have a keyboard and mouse because all they will need to do is open files and type in what they want. In the future I could make this better because if I had suggested other equipment, for example, a microphone they could enter the data without having to use a keyboard if they could use a voice recognition software package. Then they could just say what they want entered and it will type it for them, making it much easier to use. In my specification I have also said that the user should be able to output data. There is easily enough for what they need to output the data that they need. They have a printer so they can print of information they need, but they also have a Cd-Re writer so if they need to take the information of the computer to take to another computer i.e. a home computer, to amend it. Also the Cd-Re writer can be used for backing up the software. They obviously have a monitor so they can view the information they need to see. Kaleem Sajad Databases 08/05/07 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Management & Manipulation of Information 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 AS and A Level Management & Manipulation of Information essays

  1. Marked by a teacher

    Information Retrieval tools. I have used a database to carry out my searches. ...

    3 star(s)

    You can also write down unwanted words that can narrow down the search and will keep the quality of information high. This will increase the proximity, as the information that is searched will be found. The Coverage Search engines are normally up to date because if you search for something that is new, it always comes up.

  2. Designing a booking system for an Estate Agent.

    Whilst talking to Raj I asked whether they have an organisational chart structure and he answered no. All the workers are on the same level and they work independently whilst still keeping in contact with colleagues. The audience are the clients who booked an appointment for property viewings.

  1. Planning a payroll system for a martial arts school.

    * The program should use a menu system with three options of: o Entering and processing an employee's details. o The pay slips details with the ability to print. o Exiting the system. * The operator need not be computer literate so it should be easy to enter with suitable validation procedures and be as simple as possible.

  2. Background and investigation for designing a database for a DVD rental shop.

    to provide an ICT based solution and he will be providing me with all the information I require to design and make the proposed system. Users Ashley Bradshaw devotes most of his time to the running of the shop and this deems him the main user.

  1. Free essay

    Data Protection

    Set the alarm if there is one available. * Mark all of your hardware with assets tags and ultra violet pens. Write in big letters "STOLEN FROM x*x COMPANY POSTCODE x*x" using a UV pen will make sure that it is seen when it is examined.

  2. Evalution of my database

    they are prevented through security but I still had to do a few more research on other threats and find ways to prevent them. I have learnt how to rearrange data , take out data , replace data and change data in my database I have also learnt how to create a relationship, queries and query reports.

  1. Using the Internet to research UFOs.

    There is a need for explanation, for comfort, etc. And although I was not a part of this community, just by reading the postings and responses I felt an undeniable sense of community. The process was long but well worth the effort.

  2. ITGS Mod and Open Source Essay - Counter Strike game and Gimp photo editing.

    Some plug-ins which I find interesting is the Pandora where we can stitch pictures together forming a panorama picture. Even though on mobile phones such as Samsung and Iphone has this feature, but when taken with a camera the quality would be better.

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