• 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. Designing a booking system for an Estate Agent.

    Each role involves specific tasks but as mentioned before there aren't enough employees within the branch. This is why they are trained to do several simple tasks as well as their own. Raj said that everybody is responsible for booking a client.

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

  2. ICT Solutions for people with Special Needs.

    Chronically Sick and Disabled Persons Act (CSDPA) 1970 The Chronically Sick and Disabled Persons Act imposes a duty on the County Council to find out the number of people who require services and to publish information about available services. It would give Visually impaired people the right to complain to

  1. Planning a payroll system for a martial arts school.

    Identifying the users I was asked by Winston Newton to produce a payroll system which is effective and has high data storage capacity in order to manage with high demands and linked directly to the booking system which also should be upgraded.

  2. Beanie Project.

    chosen, but due to its cell layout, it corrects terms entered into each cell. o Macros can be widely used in Excel, and it has the option of recording macros simply by a go and stop method. o Because of its ability to group together cells for mathematical operations and more, it can use cells to make graphs and charts.

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

  2. Video World Database as ICT project.

    The amount of time it takes to document a new member. With the manual system it can be very time consuming, just entering data for the new member. The form has no tick boxes and Gary has to write it all in full by hand.

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