• 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

    Grimsdell, the pre-prep only has a small network of 5 computers, but have access to the Mill Hill Intranet. Middlesex University has by far the biggest network out of all my sources of primary information. Over the space of 7 campuses, they have over 3500 PCs, 700 Apple Macs, 600 printers and several servers.

  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

    This is very helpful. For example: I can add the field name Customer_ID from the Customer form, and the field name Video_ID from the Video form to the Invoice from. In the end, I managed to achieve the objective. * Each table has a primary key to uniquely identify each

  1. System requirements analysis

    Here is a screenshot of these features, I think this software would have been suitable for the health centre as it provides a range of different characteristics that would be ideal for the health centre. The disadvantage is that it would be very expensive and that it is an Australian/American based software.

  2. Creating a computer system for a video rental shop

    had had to collect my own user information on the requirements of the new system and what the problems were with the new system there are four techniques I could use these are: - 1. Interviewing staff at different levels about the present system and what they would like to see from the new system.

  1. Creating a computer system.

    * Access- Yes * Excel- yes 6) Can you backup data? * Access- yes * Excel- yes 7) Can you add macros, to shorten the time taken to perform tasks? * Access- yes * Excel- yes 8) Can you use Visual basic to allow macros to be written?

  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