• 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

    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

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

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

    to the restricted computer settings * School it too virus-amateur and thus disallow the use of USB sticks, CDs etc. Conclusion Overall, while the school computer system does all it can to stay safe, risk-free and without threat, it goes too far into limiting our actual ICT use.

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

    This could be the only method of finding out information about young children as they could not fill in questionnaires or take part in an interview. The observer may miss important information while they are note taking about other information.


    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

  2. GCSE Calculator Project

    addition, subtraction. This number will be shown in the large display box also known as Numb1. I will validate the input fields so that only number figures can be inputted into these fields. This way there is a less chance of a mistake to occur during the operations.

  1. This project is designed to help non-computerized library to easily keep track of their ...

    And there is always danger for the books to be stole. However, this system is cheap in the senses that there are no running costs. Apart from this man power is readily available. Due to the difficulty faced by the librarian a computerized system should be develop to keep all the files and documents up to date and organised.

  2. Database design.

    that is used in this database is to show each of the single databases in tabular form; Table Entity Types Description Data type Length Key Validation Input Masks Combo box Costumer_ID Unique number Number 6 Primary No Customer_First_Name Customers first name.

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