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

    The current stationery is used as follows The company stores these documents on computer and on paper; it has two external hard drives to backup all the documents. It also has double copies of the paper documents so the documents are quite safe and secure.

  2. Marked by a teacher

    Evaluation of my ICT Database, Spreadsheet and Newsletter

    3 star(s)

    Also the writing size I have chosen is too small to read. The colours I have used do not over-whelm the reader, it?s very plain and easily read ? despite the size of the font. Improvements To improve my newsletter I need to do the following:- I could change the

  1. Hardware & Software Requirements for Database

    Both applications can store data on the disk. An example of an external hard disk in everyday life is a USB mass storage device which is reliable as the data inside the disk cannot get lost unless the drive is damaged.

  2. Different types of technology How I use ICT at home and at school

    Due to this, they have blocked all uses of USBs and CDs and such. This has limited our use of the computers as we have to go through longer processes to transfer coursework to and from your house and such.

  1. GCSE Database Project ICT

    The input form will be opened and the data will be entered as written on the form. The data is entered via two ways typing and mouse drop down menu select. The data is then checked on the screen via the form and re-checked with the patient and any corrections made.


    Select enter mark sheet Select A1 'mcrViewReportSummary' Go pivot table B Refresh data Select cell A1 'mcrViewparentReport' Go pivot table B Refresh data Select cell A1 'mcrReturn' Hide user form 1 Return to main menu Select A1 'mcrCencel' Hide userform1 Reture to main menu Select A1 'mcrAuto_Open' Click tool, options

  1. Explain the difference between primary and secondary sources of data, with examples.

    People can often change their mind on a topic once the interview has started and they may change their behaviour. Sometimes people ask questions back. the interviewer must not answer the questions as it can change peoples minds or opinions on a subject.

  2. Normalisation.Normalisation is a process used to come up with the best possible design for ...

    * Data can be easily updated or changed, changing all data in database. For example a booking change in a members records would change a booking in the tutors records, with only putting the data in once. I have fulfilled this requirement as I can do this.

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