• 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
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  • Level: GCSE
  • Subject: ICT
  • Word count: 4306

Organising the database at Costsloadsless.

Extracts from this document...

Introduction

Emily Catherine Heywood Costs loads less Description Costloadsless is a convenience store, but by renting out DVD /video's they will wish to extend there business greatly I have been employed as the I.T expert, therefore I have to organise for them all the I.T systems e.g. the database's of all the films that have been rented out, One of the worries in the video store is keeping track of all the members and there video's they have and making sure there not overdue or if they are overdue making sure we do get them back, otherwise we are losing out because then we will have to buy new video's using our own money therefore we wont have much money left, if everybody does that. You can send the video's back by post when you order over the internet to make sure we do get it back: one idea is o Put a deposit on it. o Send a reminder, then a bill a week later. o Send e-mail warnings telling the member the consequences Renting an 18+ video is an offence because its not for under 18's its inappropriate for them so its important that the video store keeps check of there members if they do give an under 18 a video then the store could have there licence taken of them that would be a terrible reputation for the store that could possibly lose customers so it is very important they no the age of all the customers. They could even be fined The store also need to keep a database of all the members because then they can be offered all the best offers and then the members will stay members for the offers and then they will spread the word about the excellent offers for just members only and then more people will become members and then that is more money for the business. ...read more.

Middle

But the computer does need a high memory as the amount of customer's data being stored is unpredictable. I recommend that it comes in XP edition, it mostly comes on most computers and it is a reasonable to buy, this operating system is new and very much improved, it has a high speed, it is more convenient to use. * This computer is �269.99, * 80 GB Hard Disk Drive. 256MB DDR RAM. Intel Celeron D 351 Processor, 15" TFT Monitor, This computer is a good buy it is including everything but a printer. You have not got to buy it separately and pay more. It includes soundcard. The Operating-System is widows XP that is an updated operating-system it is the most updated system. It has 1 P.C shot number of USB connections is 6. This computer is only 349.99 and it has, Intel Celeron 356 Processor, 3.33GHz, 533MHz FSB, Microsoft Windows XP Home Edition, 512MB DDR RAM, 80GB Hard Disk Drive, Multi-Format Dual Layer DVD RW Drive, Multi-Format Dual Layer DVD RW Drive, Integrated Graphics, 6 USB Connections, this would be very useful just in case, 1 PCI Slot, 15" TFT Flat Panel Monitor. I think that the first computer is better because it is cheaper and it is has the same amount of Hard Disk Drive, this is important as costloadsless are on a budget. I think that this computer is more important but in this case we are getting what we pay for, this computer. The computer I have chosen is the first choice because it has exactly the same memory as my second choice but the second computer is more money, they both have 6 USB Connections. The one thing that costloadsless are looking for is quite a lot of memory, cheap price for the computer. The first choice is exactly that. The second computer has the same memory and same amount of USB connections. ...read more.

Conclusion

I would be expecting all that customers information to show reports This is basically a detailed report on customer's information of all the customers in a certain area, e.g. customers. I shall print out the report and see if it contains all the information from a customer in that area the queries has called for. My expected result would be all the customers information from just that one area would appear on the sheet. Add new customers In my documents there should be a Delete old customers This process should automatically delete the old customers when they have brought back there DVD and it has been two days. To test this method I shall create a customer and say it has bought back the DVD. I should then see in two days that the customer has been deleted. For this 'costloadsless' project, there are a lot of documents that I will have to test just incase they don't work, I will loose all documents if they are not tested. These are the e.g. of my testing these do show weather the process went right or wrong and what I would do if they did go wrong to make sure for the real database that everything goes right as this would be extremely important. Picture 1. This is a copy of my application form; a customer shall fill in this for a back up copy and customer shall fill this in when he/she applies to the store just so the store has there information, they can just simply copy the information onto the store computers. Testing 2 In my document, I have made a form to put customer information this will just put the customers information in and this is an opportunity to check for spelling mistakes, and it will secure the data in the computer, this is used so a 'costloadsless' worker can just easily call up a customer, and see his/her data. It is very important that all data is correct just incase a letter has to be sent home. Testing 3. ?? ?? ?? ?? 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 GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Use of IT in schools

    as well as using other types of ICT system such as electronic registers, which improve the school's efficiency. However, it must be said that there are disadvantages to using computers in education: * If ICT is used heavily in school, it is likely that the students could become dependent on it, and not be able to work without it.

  2. Hardware & Software Requirements for Database

    Both applications can store data on the disk. An example of an external hard disk in everyday life is a USB mass storage device which is reliable as the data inside the disk cannot get lost unless the drive is damaged.

  1. Spreadsheet Project - computer system for a video hire shop.

    should have increased by �1.50 Food Total Test that the food total is increased when a food is made Input a food transaction Food �2.35 Food total should have increased by �2.35 Food total should have increased by �2.35 Annotated copy of testing When testing the spreadsheets, the main error

  2. Access Database

    record Each table has to have a primary key to uniquely identify each record because without it the table would not work, they are also needed for relationships, if you want to create relationships between several tables. At first it did not work but later after many attempts I achieved the objective.

  1. System requirements analysis

    * Add unlimited resources any time with your admin controls I have taken the features that would be needed for the health centre. The health centre allows the patients, the staff, the technicians and the owners to have some sort of access to the booking software.

  2. Creating a computer system for a video rental shop

    Sending out questionnaires and analyzing results. 3. Observing current procedures with current system. 4. Examine current business and systems documents and outputs. Design The Feasibility of a Computer Based System: It has been required that I should produce a computer based system for the video libary.

  1. Creating a computer system.

    Can you validate data to test if what you are using is correct? * Access- yes you can use table validation * Excel- yes you can use form validation 5) Can they edit and delete data? * Access- Yes * Excel- yes 6)

  2. Moviezone video rental system.

    PinPoint does not offer this feature. Setting up a relational database will avoid the unnecessary duplication of data and make it much easier to update information. The staff of MovieZone don't have much experience with computers so the new system must be user friendly.

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