• 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

ICT coursework: Designing and implementing a book rental system

Extracts from this document...

Introduction

Habib's Book rental system Contents * Project proposal * Possible solutions * Chosen solution * System objectives * Performance Criteria * System objectives Design * Chosen software * Resource requirements * System flowchart * Table design * Entity relationship diagrams * Data entry from designs * Menu form designs * Query designs * Report designs * Test plan Implementation * Implementation plan * Implementation commentary Testing User guide Evaluation Project title is Habib's Books Rental System Aim of project My aim is to investigate and also to try and solve the information handling problems of Habib's books a small shop that rents books to membership only. The owner of shop wants me to design and set up a more efficient way of storing and handing books and membership. I would be including different ways of registering to Habib's books and also I would be making a better way that would be safer and better for the company. I would change things around that would make the company easy to use and a very flexible job for the staff. Input * Member details (member number, name, address, date of birth) * Book details (book bar code, name of book) * Loan details (book number, member detail, date book due back) Processing * Look up member details. * Look up book details. * Look up loan details * Search for videos opposite * Search for videos due in. * Look up there pin code. Output * Member details. * Book details * Opposite book names. * List of books due in * Reminder of a letter about owning a book. Problem Description In my project I will try and aim to solve the information handling problems for Habib book rental system based on children's education. ...read more.

Middle

* Make reminder letters quick and easy. * Help staff do their job quick and easy with accurateness. * Provide information when it is needed as quick as possible. Performance Criteria The following would be used to evaluate the success of the new system: * It must take less than 45 seconds to find details about a member. * It must take less than 35 seconds to edit, add, a member. * It must have security passwords for member's personal information. * It must remind staff at the end of the week to send letters to members who owe books, which is mail message. * It must take under 1 minute to search for members who overdue the books back. * It must take lees than 10 seconds to delete a member. * It must be under 40 seconds to search for a book * It must be under 1 minute to find what the member wants. * On screen data entry forms must be clearly laid out to make a data entry. * It must solve errors by itself, which might slower the computer. * Member's details should be placed in a place where you must have a password. * It should be possible to input new books, staff members, and customers in less than 30 seconds. * It should be able to provide reports in less than 30 seconds in the following areas books borrowed, which staff let member borrow book, staff currently employed, books owned by the store, and also customer details. Current Resources Mr Dawson already has a computer with the following specification: * Windows 98 * A Pentium II 200 MHz processor * 14 Mb of RAM * A 1 GB hard disk with 128 Mb of space * A floppy drive * A CDROM drive * MS office 97 standard (Microsoft word, Excel, point and outlook express) ...read more.

Conclusion

Mr Dawson would have to buy a Laser printer to print information about books and also to send letters to the members and also has quality printing. This would cost �81.89. According to this there would be round about �600.00 left for the computer. When I go to school library the PC are the same, as the one Mr Dawson would have. I would add a printer but only 1 so everyone would collect his or her prints from there. I would buy laser printer because it lasts long and also you do no keep have to changing the ink. Table Designs Design view of Tables As you can see I have created my member, who is details about each member, I have done book, which is information on the book such as name of book, and also I have done the loan, which is date of loan. Book Table This shows my table for Books as you can see I have done a key field and also when you want to look at types of books they are already there. This table has been created for books only which means that there is information only on books. Member Table This shows my table for Members. As you can see I have done a key field and also when you want to look at types of areas they are already there. This table has been created for Members only which means that there is information only on Members. Loan Table This table is done for rental system, which shows the date of book due in and etc. this is very useful to the staff and me because it shows when they would have to pay by and bring the books back. ?? ?? ?? ?? 1 BY HABIB AKKURT ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Management & Manipulation of Information 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 AS and A Level Management & Manipulation of Information essays

  1. Analysis of market, environmental forces, competitors, marketing mix and consumer implementation.

    The PSX 2 will still benefit from lower prices, as PSX 2 will be backwards compatible enabling those upgrading to still be able to play their old PSX games. The Sony PSX 2 has superior software support than the other manufactures with numerous games developers looking to produce games for the console.

  2. Standard Operating Procedures (Sop) recruitment policies and procedures.

    The names of all non-qualified applicants are also listed for documentation and statistical purposes with no rating score. The eligibility list is considered "established" upon official signature. The Eligibility List and its contents must be kept confidential to maintain the integrity of the merit system.

  1. Home Office LTD company. Database

    To protect the sheet you format the cells you want to protect and make sure it says they are locked, then by protecting the sheet. Screen shot showing the protecting sheet process Screenshot shows the final product information sheet with the four headings and nine example products In this sheet,

  2. ICT Solutions for people with Special Needs.

    * Employers are able to recognise their responsibility in showing respect to their employees and contribute positively to an environment where everyone has the same chance to develop and progress within an organisation * The equality and diversity policy should be constantly monitored to ensure that it is working effectively.

  1. Designing a booking system for an Estate Agent.

    Although specific role involves different tasks there aren't enough employees in the branch which means they are trained to do other simple tasks such as showing clients around however the main person that is responsible for this is the negotiator.

  2. Background and investigation for designing a database for a DVD rental shop.

    they then have to chase up which member rented the DVD from the rental form, which takes up a lot of time. On returning a DVD, the member hands the rented film in and the member of staff that accepts it will place the DVD back into its original case.

  1. A report on the impact of ICT

    There are also many negative effects of the internet such as viruses, security and privacy. The internet can be a very dangerous place however with new antivirus software and firewalls I have not personally been majorly affected by any of these problems.

  2. Uses of ICT in Varndean

    Also, they need to know how much money they have on their debit card, because they use it purchase all of the items that they need to get. What hardware is used? The hardware that is used in purchasing at Varndean are mice, keyboards, 17" flat panel monitors, computers with Pentium 4 processors.

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