• 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
  47. 47
  48. 48
  49. 49
  50. 50
  51. 51
  52. 52
  53. 53
  • Level: GCSE
  • Subject: ICT
  • Word count: 3532

Database coursework

Extracts from this document...


19 April 2010 Database Coursework Mahamed [Pick the date] Write up Identify Background Information Bobbies Bookstore is a new bookstore based on 90 Birmingham roads. The bookstore opened few months ago. The company takes its name from Bobbie, the Greek god of Carrots. Bobbie's book store markets its products under its own brand as well as Bobbie Read Store, Bobbie Learn, Brother Bobbies Books. The company's business will be on local level.. Bobbie's book store wants to deliver high quality books and services. Bobbies Book Store opened 2009/10/12. The company's board consist of 6(key) members * Manager (Mr Bobbie) (Real user) * Vice Manager (Mr Carrot) * Chair man (Mr Wood ) * Secretary (Mrs Paper) * Vice Secretary (Mr Folder) * Treasurer (Mr Coin ) The real user is the employees and the manager (Mr Bobbie).He(manager) is the company's key person he is also the person that ordered this project The company's current problem is: * The company is new * The company has not recorded documents before * The company has constantly new books * The company have no database available The reason why these problems have arisen is because the company is new. The company has not had the opportunity to do something about the arisen problems. Statement of the current problems "The company is currently facing difficulties with accounting books, services and other data. We have no current system to support accounting or recording the companies' data/information. The company needs these problems to be solved as soon as possible, as we are ready in all other aspects to go in business. As an outcome of an not working accounting system, could lead to Money losses and unstable company as well as bankruptcy .The outcome of an not working system is a serious threat to the company's future and our chance to compete against other companies. As the companies head person I want you to create a working system to meet these needs. ...read more.


The PC will be used by the employees and managers, mainly the emploooyes to edit, retrieve and use information in the database. Software * Windows Vista(tm) Home Premium(plat form ) * Necessary drives to additional hardware (mouse,keyboard,USB sticks ) * Graphic software * Web-browser * Microsoft Access 2007 The software that will be used for the creation of this Database will be Microsoft Access. Access is an excellent database creating software, which may not be very easy to use but once made the outcome is absolutely fantastic. Data collection Every time a customer buys something their details will be entered into a database. General data flow What information do I need to gather and where will it come from? The data will be collected when customers buys/lends books from our company. When the data has been collected it will go onto the database once a day We have chosen once a day because we have seen the needs, and they are big. The collected data will consist of numbers and words, everything from book names, prices, customer age, and genre to taxes. The information we collect will be in hard copy. Information from the company like prices and book names and information about the company itself will come from the companies head office (the company) When all data is collected it will be processed by database program (Microsoft Access) The data required to assemble this database carrying information about books and customers. Much of the information will come from the company itself such as * Books available * Books reference number * Area * Book prices But some of the information will come from customers such as * Name and surname * Age * Address * E-mail * Gender Data Manipulation The tables in the system will be Books, Books Price, Customers, and Sales Books [Reference No, Book Title, Author, Supplier, Gender, Area] Books Price [Reference No, Purchase, Selling Price, Closing Stock] Customers [Customer name, First name, Surname, telephone ,Address 1, Address 2,Postcode,E-Mail, City] 9 Reports and. ...read more.


* Produce rapports This objective has successfully been achieved, the reports has been produces and the end user is satisfied. 3 reports has produced * look up data(Queries) This objective has successfully been achieved. The database contains enough data(information) to do multiple queries (different criterias). I have done 3 quires * Produce Forms This objective has successfully been achieved. The forms has been designed according to the designs and fully implemented. I have done 3 formsquires * Be user friendly The database is easy to use and works without problems. * Be printable Al of the forms can be printed .i have myself printed out some ,it fits perfectly in A4 paper. User Feedback Dear database Designer, I am very impressed with the database you have designed for My Company in Fire roads Birmingham. I am very ecstatic that you were able to get all our customer details in so easily and I'm so happy that it is so easy to use, it will be very easy to update so will bring in great revenue.. However I found that some of the information you have put into the database is quite useless so I would like to see less information that is useless and more information that tells the user what the database will help the company and how they are to use it. Also I need the database to be more friendly and easy for me to change the information if I needed to change it. Please could you fix these problems and give me the database and I hope I will be able to successfully use it. Everything else on the database is absolutely fabulous. Thank You Mr Carrot Improvements from user feedback Based on the user feedback I will have to cut out some of the useless information and add more information that is not useless .then It should be very easy to use the database, users won't need much training on how to use and update the database. ?? ?? ?? ?? 2 ...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. Marked by a teacher

    Planning- design a memo, letter and webpage for Capital FM.

    4 star(s)

    At the station we have a photocopier. All the files on the computer will be made in template form so it will photocopy itself in the computers brain. For writing letters at the moment we just type in what we want and the main point of the letter.

  2. Marked by a teacher

    Evaluation of my ICT Database, Spreadsheet and Newsletter

    3 star(s)

    Bad Points There are some bad points, or points that I think need improving about my newsletter. I could of used more auto shapes to add more depth to my newsletter, it looks plain. The pictures I added to my master page are a little too small, although they are set of in a good way.

  1. Design an advertisement or a web site for the cinema. Your advertisement or web ...

    I could have used a slow home computer or those in the library with slower processors and older software. I decided to use the computers in the ICT department as they are adequately fast enough for my needs and will run all the software I need.

  2. Hardware & Software Requirements for Database

    The faster the CPU the quicker it can see the database with the doctors and patients details recoded (With a faster CPU Whipps Cross Hospital will be able to do there work as quickly and accurately). The faster the CPU the higher ability available to hold more patients and be

  1. a level ict project

    to open the table of employee work plans: * Macro Action is to be OpenTable * The table name to be selected is Employee Work Plan * The view should be set as Datasheet * The data mode shall be set as Edit Macro design to open the table of

  2. Access Database

    To site check, is an example of verification. For example, to check that the fields work. Validate: Verification is the process of checking that input data is correct. It is normally carried out by a human who visually compares the data with the source document.

  1. The impact of ICT on a person with special/particular needs

    It functions with the use of any pointing device being used as an input. There are lots of different and alternative pointing devices with can function with the WiViK keyboard. It works how any other keyboard would work but instead, the keyboard is on the screen.

  2. Computer study project outline - library and book club database.

    Testing all the algorithms and debugging- 10 days. 9. Designing the software- 10 days. 10. Documentation and report making- around 18 days. Hardware used I am using a variety of different hardware for this project: 1. Laptop: I am using an HP Pavilion dv3 Series laptop.

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