• 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)

    This can also be useful whilst searching for information. The Coverage Emerald is always up to date as it gets new information in everyday. The type of material usually depends on what has been searched. An example would be NHS.

  2. Datbase Project newsagent shop

    This is to stop competitors from stealing the database and details of his customers. The hardware that I will use for creating this database includes a monitor, keyboard, mouse, CPU (central processing unit.), printer, scanner, digital camera and the Internet.

  1. Standard Operating Procedures (Sop) recruitment policies and procedures.

    Once again, confidentiality must be maintained for all examination materials and results. An applicant may appeal an examination rating within 10 work days following the date his examination rating was postmarked. Certification of eligible is authorized only after the administrative review period has elapsed.

  2. ICT coursework: Designing and implementing a book rental system

    Pinpoint has the following: * Data can be saved in file formats and used in other applications. * Graphs and charts can be made quickly. * You can design question sheets very easy and quick. * You can search very quickly.

  1. Home Office LTD company. Database

    Moreover, after each order the user manually changes the quantity remaining which makes sure the quantity remaining is always checked. The worksheet works by four main column headings: product code; product name; price and quantity remaining. All work together to provide the necessary information that the user would require.

  2. Designing a booking system for an Estate Agent.

    Each role involves specific tasks but as mentioned before there aren't enough employees within the branch. This is why they are trained to do several simple tasks as well as their own. Raj said that everybody is responsible for booking a client.

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

    Bradshaw's skill level. Ashley Bradshaw possesses limited IT skills but is keen to introduce a computer-based system again for the rentals of his DVDs if it meets the requirements. Identification of client and potential users Client The client is Mr Bradshaw who is the owner and the manager of JenJams.

  2. Video World Database as ICT project.

    edit relationships * Create forms and reports based on tables * Create customised input screens and using Visual Basic facilitate searches and validation procedures * Create queries to find specific data * Create a menu driven system * Implement security provision.

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