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

ICT Coursework Two - Database Project

Extracts from this document...

Introduction

Analyse Section - GCSE ICT Coursework Two - Database Project Christopher Healey Hardware that will be used For this I will use a QWERTY keyboard for the manual input of data and the commands for the computer. I will need a mouse or trackball to design the database forms, to navigate the GUI of the OS and to move, copy and paste data. I will need to use a 31/2 inch floppy disk and drive or a CDRW disk and drive in order to save my database and to make backups of my database. I will only use a CDRW if the database exceeds 1.38-1.44 MB. CDRW's can hold from 500-700 MB of information. I will need a printer to print out the design of my database of for word documentation of the database. Software that will be used I will need to use a database creation package like MS Access, Fox Pro, DBASE II or IV or Borland Database Explorer to create my database tables, queries, forms, reports and macros easily and also program them with the Visual Basic programming script to make my database into a professional running program. According to the user requirements MS Access is the best one also because it is mostly familiar to people. I will need a word processing package like MS Word, Notepad, WordPad and Word Perfect. ...read more.

Middle

Process of information The information will be calculated by some calculation validations in the database so that certain data is updated by the computer automatically without any more manual tampering. However the calculations depend on two of more different kinds of information for it to work. So this information will be manually inputted and updated if needed and the calculation will create and automatically update its data with this other information. The database will be updated or edited when a video has changed price or new stock has arrived, and when a customers details are incorrect or moved location or changed name etc., or when a customers details are deleted because a ridiculously overdue item. Information Flow Analysis of Output Requirements The outputs that the database will have are, on screen - to see the information as the user edits updates or inputs data. The user on screen will see everything. The table, the form, the report and the queries. Another on is printed out so that the user can keep and store that as a hard copy is the system fails. The user can print out the table will all the data on it, the queries without the design, and the reports as a document so that they can send them to the customers. ...read more.

Conclusion

Each video needs to be catalogued and its details stored. Each member fills out a membership form in order to join the video shop. Once the member completes this form, a membership number is assigned and the form is then filled in a filing cabinet in alphabetical order by surname. The form is then filed back into the cabinet. All the loans are cross-referenced with member and video files. The overdue fee is then calculated using a calculator or calculating device. Members often ask the sales assistants whether certain videos are in stock and when they due back, or when the new releases are due to release. The sales assistant often answers the question from memory, or finds the information by looking through the files. The manager has three assistants, none of them are computer literate, but are willing to be trained. This video store has been running for 9 years. 2 years ago they started trading DVD videos for rental. The Current System and its Problems There are a lot of problems with the old system. They were that all preferences were documented on paper. This causes those preferences to be a waste of paper and will be hard and time consuming to locate, edit and update it. ...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 ICT in Business 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 ICT in Business essays

  1. Business report on Marks and Spencer.

    Instead of having to get permission from their line manager, they are allowed to make more important decisions. Senior managers then become more concerned with external matters than running the internal system. ICT has a very important role to play.

  2. Apple Incorporation - Case Analysis

    / equity ratio - total liabilites / SH equity 161.21% 66.27% 65.64% 53.60% 53.80% 61.38% Debt to tangible net worth = TL / (SHE - intangible assets) 161.21% 66.27% 65.64% 53.60% 55.41% 63.00% Debt ratio is the total liabilities divided by the total assets.

  1. In this coursework I need to produce a detailed business report on one medium-sized ...

    In general, senior managers or a centralised department takes responsibilities for: major financial issues, wages and salaries, manpower planning and personnel records, purchasing. Advantages: * Senior management have more control of the business, eg budgets. * Procedures, such as ordering and purchasing, can be standardised throughout the organisation, leading to economies of scale and lower costs.

  2. In this report I intend to create a detailed report of Tesco's.

    There cloths line is extremely successful it is making around 8 million pounds a month. Tesco's used to only target the lower classes that's E, D, C2 and C1. Now they focus on the whole market they sell to A, B, C1, C2, D and E.

  1. unit10 final account

    Environmental consideration, some firms like tesco do face pressure from the public opinion when locating premises. There can be opposition from pressure group if they attempt to locate in environmentally sensitive areas. 6. Geological suitability: Some businesses require particular geological features.

  2. Business Report on Manchester Airport PLC.

    controlled, there were disadvantages as well, such as: * One of the major problems was that it actually made it more difficult for senior management to stay in touch with developments that happened at all levels of the organisation, and in its external environment.

  1. The purpose of this document is to define the Context of Cain Motors Information ...

    Change Benefits: Benefits include increased revenue. Workflow efficiency removing double bookings. Improve staff communication; be able to access information, which is presented clearly and legibly. Change Costs: Virtual web hosting will incur a continued leasing cost Housing a web site has many long term running costs to be considered such

  2. The Classification of Sainsburys

    (6) Profit sharing (50) (37) (44) (45) (10) Associated undertakings 19 19 16 11 1 Interest receivable/(payable) (59) (76) (78) (50) (72) Group profit before tax, amortisation of goodwill, exceptional costs and non-operating items 764 651 728 755 580 (Decrease)/increase on previous year (5.4)% (14.8)% 11.8% 3.7% (23.2)% Earnings

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