• 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

    Once they reach the secondary school, they are expected to be able to type essays, have a good working knowledge of word processors, and research information on the Internet. These skills would be needed at university as well. There are also specific uses for ICT in certain subjects.

  2. Hardware & Software Requirements for Database

    that storage device based on a fixed, permanently mounted disk drive(permanently stores data in a computer). It may either be internal - part of the computer itself or external - a separate but connected component. Both applications can store data on the disk.

  1. 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

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

    My findings are as follows: Test Name Test What? How? Test Data? Expected Outcome Actual Outcome Valid Membership Test that only numbers between 0 and 2000 can be input Inputting valid and invalid numbers and text 39 2930 horse 605 Allow input Validation error message Validation error message Allow input

  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

    However if I were to document the complete production of the system I would have used the systems life cycle. The systems life cycle helps designers to approach the design of a system in a methodical way. There are several variations of the cycle but below is the most common.

  1. Moviezone video rental system.

    databases; � Data entry forms can be created and customised quickly and easily; � Powerful queries to search the database can be generated using wizards and saved; � Reports can be can be generated quickly using wizards and formatted very easily; � Tasks can be automated using Macros; � Access

  2. I will design a new video database for the video shop that will also ...

    on the actual database so it doesn't become too full and confusing. The system will have a large memory capacity as the video shop has to keep records of a large number of customers. Any documentation that is needed for the system will also be created, such as a user-guide and a technical manual.

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