• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Ict - Changing the system of a video library.

Extracts from this document...


Ict coursework Jonny Sharpe Identify section The current system is a hand written and hand handled by Mr Roberts. It is a paper database where all details of the members, transaction and return details are stored. Mr Roberts currently operates all the system by himself and he does this to keep a record of all the bookings out of the videos, he does this by pen. He finds the page in the book allocated to the member, writes when the person needs to bring it back in, takes the payment then gives the video to the member. When a new member joins Mr Roberts takes all the details down in his book, then gives the new member a member number. Mr Roberts has to check every night for overdue videos. When a member's page is full, then Mr Roberts has to get a new page, this just adds to the ever-growing file of Mr Roberts. There are lots of problems with the system, it is very slow, it would wear down with over use, he cannot cope with the growing number of customers, He has to check every night to see which videos are overdue and hand type each letter and send them off the same night. This would be increasingly difficult when lots of members join. ...read more.


Software Justification Justify choice of software: Word: The program needs to handle numbers but word is very good at typing letters. Excel: This program would be ok for the video shop but there would have to be 1 sheet for the videos and 1 sheet for the member's details. This program would not be able to type letters up and print the letters off. Access: This program is excellent, this is because you can merge the video details and the members details together to give records of loans. This program can also produce reports in letter form and print them off. Data needed 1. This database is for the videos, it should show the number code, name. 2. Member's details should be shown on this page, name, address, membership number, telephone number, current video rented and the date it is due back. Design section This shows that I have made two tables to store information, one for the members details and one for the video details. I have entered 50 videos and 5o members into the tables. I have designed the system to alert me when there are overdue videos and to be able to book out videos and book in videos with ease. I linked the two together by making a link between the membership number and the video number as shown below. ...read more.


To collect data from new members I have a form that they fill out. They write on it their name, address, tel. number, and date of birth. I write their new membership number on it. 3) Each member has a membership number. It is a four-digit number, starting at 1000. 4) I don't use credit card details as there is too much security needed. 5) For new members I need two forms of identification, one with their name and address, i.e. a bank statement or gas bill for example and one with their photo on, i.e. theirs drivers licence or passport. 6) I haven't got a password system. If you think I should have one let me know how you think it would work. The problem is that customers would have to tell me their password and other customers could overhear it so it wouldn't be that secure. Evaluation I think the final product meets the standards set by Mr. Roberts. The only mistakes I have made is that I have given the example members, membership numbers starting at 200 and they are only 3 digit. The final product can do everything specified in the design requirements made by Mr. Roberts. The opinions of the users would be on the questionnaire I made. The only improvements that could be made to my database is that I could maybe produce an automatic report displaying all the information of the member on a report who's video is late, instead of just having a basic template. ...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 Computer Science 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 Computer Science essays

  1. Visual basic

    And X5.Visible = True And X7.Visible = True Then MsgBox "Player X wins", vbOKOnly, "The End" Timer2.Enabled = False lösch p1p = p1p + 1 Timer2.Enabled = True End If If X4.Visible = True And X5.Visible = True And X6.Visible = True Then MsgBox "Player X wins", vbOKOnly, "The End"

  2. Hardware and software ICT revision notes

    These help you and others to understand (or remember) the purpose of small parts of the program. You will learn to use comments to explain your programs at each stage. Macro Programs Programs that are used to automate actions in applications software are called macros.

  1. Video Rental System

    Y EMP_LNAME Employee Last Name Text 100 X(100) Y EMP_SSN Employee SSN Text 12 X(12) Y EMP_PHONE Employee Phone Text 12 X(12) Y EMP_ADDRESS1 Employee Address Text 100 X(100) Y EMP_ADDRESS2 Employee Address Text 100 X(100) EMP_CITY Employee City Text 100 X(100)

  2. AS ICT Corsework - Mr Brookes K-Fit Ltd

    has to be easy to use for both customer and employee's alike. The reason a lot of work is being lost is down to the fact that customer's just simply live to far away from our work range and advertising range so if there was anyway to improve this which is cost effective would be excellent.

  1. You have been asked to create a database to handle various account combinations of ...

    -Yes -No Thank you. USER SPECIFICATION AND USER SKILLS Below you are able to view the results of this questionnaire based upon 10 people: In order to identify the type of working model that the user would want I designed a questionnaire.

  2. Smart Card System

    Each PC will have the router that connects the LAN to the Internet defined as its default gateway. A default gateway is seen in a routing table of a host as follows: the default route will be listed as the destination network, and the IP address of the default gateway will be listed as the next hop router.

  1. Flexible Architectures in Communication Security Application

    { t0 = (sbox1[x[jj][0]] � sbox2[x[jj][1]] � sbox3[x[jj][2]] � sbox4[x[jj][3]]); t1 = (sbox1[x[jj�1][3]] � sbox2[x[jj�1][0]] � sbox3[x[jj�1][1]] � sbox4[x[jj�1][2]]); x[jj�3] = x[jj�3] <<< 1; x[jj�2] = x[jj�2]�(t0+t1+key[ii<<1]); x[jj�3] = x[jj�3]�(t0+(t1<<1)+key[(ii<<1)+1]); x[jj�2] = x[jj�2] >>> 1; } output[0] = IV[0] = x[2] � key[0]; output[1] = IV[0] = x[3] � key[1];

  2. Future Developments in ICT

    Samsung have just showcased a prototype of such technology with peak transmission speeds of 1Gbps, faster than most (if not all) wire based solutions in use today for networking. According to Samsung the technology will allow you to download a full-length movie over the air in less than a second.

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