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

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

  2. Selecting the best software for a theatre business.

    partner Steven through 'mail merge' (the mail merge tool in Microsoft word allows you to print a series of standard letters or documents with particular details(such as names and addresses) changed on each one. The details which are to be merged into each letter are typically read from an external file such as an Excel spreadsheet or an Access database).

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

    I will be adding a parameter value in the query managers title and then relating the result from the customer table. I expect that the result I get are correct Testing 5 In the screen shot above I have opened the managers title query and inserted my parameter value Mrs.

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    To do this, I did the following steps: 1) Added the 3 test results together by clicking in the cell I wanted the percentage to be, and clicking "AutoSum," which is represented by the oddly shaped E, in the top toolbar.

  1. Information and Communical technology

    The benefit of using a report is that you can put the result of the Query in a specific layout of your choice. In addition, you can create in database forms. Forms allow for the user to put the data into the system.

  2. bookings database

    Yes Guest number (output) Yes Desired outcomes (qualitative) 1. Easy to enter the data- the fields are spaced out and the names of the fields are joined on to the textboxes. Also, the textboxes are larger than the data being entered. This makes sure that they are apparent. The factors are effective fort the user as it easy to

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