• 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. 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. Free essay

    Data Protection

    Such conditions tend to cause rusting and damage to your hardware parts. * Drives: Making sure the hard drive is properly connected inside the system. If not properly connected, your computer might not boot up.

  2. Database Design

    Phone number This is the list of all the data I will include in the database. There are 6 entities with different attributes. The entities are in bold below with their attributes following: Customer: (customer ID, contact name, customer address, city, postcode, date of birth, employee telephone number)

  1. The purpose of this document is to provide a design for an electronic payment ...

    1.3 Definitions, Acronyms, Abbreviations Administrator A built-in role responsible for administrating the site, the database and application users. Administrator has full access to the application data and functionality. CSV The 3 digit security code on the back of credit cards.

  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.

    This seems to be one of the characteristics common to this society of abductees. And while John Mack claims that no real physical evidence can be found, Philip Klass begs to differ yet again. If these abducees have been implanted with different devices, wouldn?t that serve as the physical evidence

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

    In condition zero, people can cheat, create maps and different mods such as zombie?s game play.

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