• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
  33. 33
  34. 34
  35. 35
  36. 36
  37. 37
  38. 38
  39. 39
  40. 40
  41. 41
  42. 42
  43. 43
  44. 44
  45. 45
  46. 46
  • Level: GCSE
  • Subject: ICT
  • Word count: 4500

Database design for a games shop.

Extracts from this document...


Database Coursework Contents: Task 1; Identify: Organization: page 3 Problem: page 3/4 Solutions: page 4/5 User requirements: page 5/6 Task 2; Analyze Hardware page 7 Software page 7 Data collection page 7 Data manipulation page 8 Data flow page 8 Outputs page 9 Back up methods page 9 Security methods page 9 Task 3; Design Initial design page 11 Final design page 14 Test plan (expected results) page 15 Feedback from user page 16 Task 4; Implement Presentation Test plan (actual results) page 18 Task 5; Evaluation: Quantitative objectives page 20 User feedback page 20 Evaluate page 21 Identify My client The name of my client is MR. Walcott, he is lazy and unemployed, he loves his video games, and whenever there was a new game out MR. Walcott had it, whether it was for PS3, Nintendo wii and Xbox. He had so many games that after a while he started lending some games to his family and friends, this became so popular hence the reason he decided to start a mini business of loaning games for a small fee to family and friend. This became very famous that his little brother, Ben and his friends decided to loan of him and after 3 months Mr. Walcott decided it's time to make his business official. MR. Walcott and Ben are both laid-back men He set up his business in south London's best location, Croydon, his shop is called blockgamester, and on 28/12/2004 he opened his business. His little brother Ben worked with him, Ben charged �1 a day for the game and maximum time was ten days, he used to record data such as his customers and time loaned on scrap paper. MR. Walcott decided to stick with this idea as it was the quickest and easiest way for him. They decided only one person will work at the shop at a time The problem The problem is that MR. ...read more.


The password must have 6 letter and 2 numbers. You should have a password on the database just to make sure nobody can hijack it and get private and confidential client information. Design On the following pages are my initial designs which will be viewed by Mr. Walcott and then improved following his feedback. Here is some information on the initial designs which I will create and they solve the problem of the user: * Games and members details form: the games details and members details forms was one of the main problems Mr. Walcott had. My solution will allow MR. Walcott to just type in the data into the relevant field hence the database will update automatically. There will be a primary key, this will help incase there is a confusion. * Games by genre report: this report helps MR. Walcott because he wanted to find out which games were more popular and this multi file report does just that, it contains information about how many people rented out a certain game of a certain genre. After concluding MR. Walcott can use it to help his business. * Rentals form: this form contains a foreign key from the members and games table. Mr. Walcott will be able to input data of all the transactions. However he will not be able to input transaction details of a member that does not exist. This is very useful for members and Mr. Walcott. * Mail-merged letter: Mr. Walcott required sending all of his members who are overdue a letter and this fulfills his wishes. It will get the names of the customers that are overdue from overdue rentals search query. * Overdue members contact sheet: this is a easy access sheet which will be printable, it has all the information about the clients who are overdue. * Overdue rentals-query based report: in this report it has information about the overdue customers who have not responded to emails. ...read more.


I believe I should have had time on the main menu form and this would help Mr. Walcott opened the database whenever he intended to. Also I should have carried out an investigation into why it would not automatically update and should have solved this. Overall I believe there were a few niggles with the database but I tried to solve the problem and Mr. Walcott's problem, I believed I passed the test. My user requirements and how I achieved them: After having a meeting with MR. Walcott and Ben they have set me the following user requirements, I achieved them: * The system should have a menu option. * The menu should have a rental section. * The system should have information about his games. * The system should have information about customers. * The system should have information about transactions. * The system should be able to recover information by entering the customer's name. * The system should be able to show overdue games. * The system should have a printable list of people who have an overdue game. * The system should be easy to use. * The system should be secure. * The system should not mix up any data. * We spoke over the phone about minor requirements which you will see later in the database Evaluation of above user requirements * The database has a menu system. * In the database on the menu system there is a rental section. * The database has information about the game, there is a games table. * The database has information about the customers, there is a customer table. * The database has information about the transactions, there a rentals table. * The database can search, overdue search. When query run brings up information. * The system provides you with information, regarding the customers which are overdue with a game. * There is a print button on a report * The system is clear, easy to use, helpful and does not give any problems. ...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 Software 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 Software essays

  1. To start my project I have chosen that I would do a spreadsheet for ...

    Rather than an ordinary database program people prefer spreadsheets because it's good for storing and retrieving. It can do calculations very fast and efficient. Excel also with the use of formulas is better than word processor or a database program.

  2. Designing a leaflet to advertise an electronics shop.

    Also there is a sale on so i would like you to add that along with special offer. Thank you and I look forward to receiving your attractive final designs. You're sincerely Mr. Smart P.S: a feedback box would be appreciated Test plan: Test plan Description Predicted results Actual results


    Much like "Magix Website Maker" First page is free however unlike Magix Website Maker you do have to download and install the program to your computer which does also have its advantages in the sense that if your internet goes down you can carry on doing your work without having to worry about losing it.

  2. My database is on a video rental shop.

    Describe the tables and relationships you plan to use? How many tables? I planed to create 3 tables. They will be called, table renting, table customer and table video. Table 1 - table renting Field Name Description 1 Customer ID Text, font 50, required 2 Video ID Number, integer, required 3 Date in Date/time, short date, required 4 Date

  1. Planning a spreadsheet database for a gun shop.

    I think that the spreadsheet will be better for my Sister Lisa and I am going to use it because * Spreadsheet calculates a decree of accuracy. * Spreadsheet takes up much less room than filing cabinets. * Spreadsheet can automatically calculate data.

  2. AQA GCSE ICT Specification B

    Test Plan Criterion to test Test I.D. Test objectives / justification Normal Extreme Erroneous Test data Expected outcome Test data Expected outcome Test data Expected outcome 1. 1. On opening, the main menu should appear, and the navigation panel should not. Open the system. The main menu will appear without the navigation bar.

  1. Documentation of a database for a sports centre.

    We use queries in our database to retrieve specific information from the database. It is important to calculate the data storage requirements of new databases because it is important to understand the requirements of the individual/customer. The quantity and the information that needs to be stored (in the database)

  2. Testing database. Test plan 1 I am going to check my data restriction. ...

    So I will be selecting 0 in the drop down menu which means the stock would change to No. In the screen shot below the result have changes and I have achieved my expected result which means my lookup wizard works Test plan 5 Now I would be carrying out my testing on my criteria which I have set upped.

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