• 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
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 42
    42
  43. 43
    43
  44. 44
    44
  45. 45
    45
  46. 46
    46
  • Level: GCSE
  • Subject: ICT
  • Word count: 4500

Database design for a games shop.

Extracts from this document...

Introduction

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.

Middle

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.

Conclusion

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. Formal Report for Task3

    I added some friendly pictures and when I came to the second slide, I typed the text in and added an illustration. I also added a voiceover. For the adult presentation, I made it look smart and formal. I formatted it with some smart features and tried to make it look eye-catching.

  2. Database analysis of 'a video lending library'.

    of cassettes in the shop only by the click of a button. The information can be easily stored in different databases so that information can be understood more accurately. There is also not much problem in using the database; there are many advantages in using the database as well.

  1. The aim of my project is to make the task of the allocation of ...

    Output via a laser printer would probably be of better quality and faster, but costs are a lot higher, a normal ink jet printer for Mr. Brown would easily suffice. The visual appearance of a model is important as it will contribute to Mr.

  2. The use of IT in producing a news letter.

    In the Right Page drop-down box, select the layout you want for the page. 4. Click OK to add two pages. To delete extra pages 1. To go to the second and third pages of the newsletter, click the page icon with the number 2 or 3, which is at the bottom of the Publisher window.

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

  1. Selecting the best software for a theatre business.

    This will be good for Bob to back up all his work. 3. The process of formatting cells was basically the same as in Excel. The menu options were substantially the same. I was able to define text cells, currency, and number of decimal places, Wrap Text and other functions with no problem.

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

    I would be if my lookup wizard works. I expect my drop menu should work when I select different values Testing 3 In this screen shot I am checking if my menu works. The menu shows two values 0 and 1, 1 being instock and 0 being not Instock.

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