• 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

Ms Matthews is the librarian for Brampton Manor School and she needs a system to get new books into circulation and read by the pupils and out of storage.

Extracts from this document...


Contents Contents 1 Coursework 2c/2d 2 Identify 2 Background Information 2 Possible solutions 2 Disadvantages 2 User requirements 2 Analyse 3 Software 3 Hardware 3 Data collection and input method 3 Data flow 3 Processes 4 Fields required in student table 4 Fields required in book table 5 Fields required in loan table 5 Reports needed 5 Database security 5 Relationships in my database 5 Main objectives for my database 5 Backup strategy 5 Security 5 Design 6 Comments on designs 6 Menu diagram 6 Form design diagrams 6 Report design diagrams 7 Menu structure diagram 8 Table design 9 Queries in my database 10 Subtasks in my database 10 Test plan 11 Implement 12 Finished design 12 Test results 12 Discussion of test results 18 Evaluate 19 Evaluation of initial objectives 19 User feedback on solution 20 Ideas for further improvement 20 Coursework 2c/2d Identify Background Information Ms Matthews is the librarian for Brampton Manor School and she needs a system to get new books into circulation and read by the pupils and out of storage. She needs some sort of system that will allow her to keep track of who has books and who doesn't, she also needs to be able to do this quickly and with ease. Possible solutions Her possible solutions are: creating a database, a spreadsheet, a manual card system, or a written list of who has what. Disadvantages Database and spreadsheet - Computer could break and information will be lost, someone could also hack into the system, also, if the system got a virus then the information ...read more.


false QryStudentLoanHistory Field username first name surname bookid title author Table tblloans tblstudent tblstudent tblloans tblbook tblbook Sort Show YES YES YES YES YES YES Criteria [username?] Subtasks in my database My database's final design needs to be split into more manageable sub-tasks. 1. Create my category table first then my three other tables, link tblbook to category with category as a lookup table, also define values, validations and input masks. 2. Create the relationships between my tables 3. Create the three forms and modify designs 4. Create sub-menu for forms and modify design 5. Create the three queries 6. Create three reports from these queries and modify the report's designs 7. Create sub-menu for the reports and modify design 8. Create the main menu linking to the two sub-menus and modify design 9. Set password for library database system Test plan A test plan needs to be made in order to make sure that my library system is working properly and is doing what it is supposed to do. Valid, invalid and extreme data will has been used in my tests. Test Purpose of test Test data Expected result 1 To see if password works correctly Enter 'school' as password Password not accepted, system does not load 2 To check if close button on main menu works correctly Click the close button on the main menu Main menu closes 3 To see if links work on main menu Click on 'Add/Edit Data' on main menu 'Add/Edit Data' sub-menu loads 4 To see if long names can be entered in frmstudent Enter new record ...read more.


Overall, I think my database was pretty good for a basic library system. User feedback on solution Ms Matthews was given the system to try out for a day, after using it she gave me the following comments on the library system I had created: "The library system is easy to use and fulfils all my needs, however, I did have trouble finding the main menu once I had entered the password on the database." "Sometimes when a book is not in the library, I need to see which student has the book to see if it has gone missing, it would be useful for me to be able to enter a book to see who is borrowing it instead of browsing through the records, I would like to see this in the form of a report." Ideas for further improvement The system could be developed further into a system with more reports, for example: design a report searching for a book based on category, a report searching for students of a particular year, a report searching for students of a particular form group. It could also be improved to open the main menu automatically after entering the password. If I were to recreate this database from scratch I would make sure there were relevant validation rules for every field in all tables if needed, I would also create more reports as mentioned above, and make the main menu appear automatically after entering the password. John Harvey Candidate No: 9125 Centre No: 13202 1 ...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. Designing a booking system for an Estate Agent.

    Regardless of the job title everyone has the duty of carrying out bookings for clients and taking the clients for property viewings. All of the employees within the company are technical users. All of them will be technical users of the proposed system as I asked in the interview the jobs that the employees are responsible of.

  2. ICT coursework: Designing and implementing a book rental system

    by setting up a new system on a computer using software package. I would use a computer because I think it will be more accurate and easy to find things. I would also say that it will be more organised for the customers rather than doing it by hand.

  1. Database Design

    This is the entity relationship diagram for all the entities: This is how my entities are related. A customer can have many orders, and each order can have more than one product then the supplier can provide more than one product.

  2. The purpose of this document is to provide a design for an electronic payment ...

    added in order to incorporate an e-Payment facility as mentioned in section 1.1 while maintaining the existing systems' loose coupling and strong cohesiveness. The Deployment diagram below is an adaptation on the Deployment diagram in Section 2 of the original SEG report (see Appendix A).

  1. I have been asked by a General Sports shop using a manual system to ...

    Destroy viruses before they infect - Get updates for latest protection - Detect hostile activity SYMANTEC Price including VAT �24.99 Features - Automatically removes viruses - Scans & cleans incoming/outgoing e-mails - Automatic internet updates - Proactive Script Blocking to stop virus - A global team of security experts Input

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

    With no specific clients, the organisation has an expanding target audience of both genders, mostly from in the local area because it is more convenient. The organisation also deals with private community groups to increase profits. Ninja Freestyle's main purpose is to coach promising athletes with ambitions to become the new British, European and even World champion.

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

    Currently task such as selected what dvds to send back isn't a reliable process as i use my own knowledge to choose dvds. I would like the system to automatically pick out the 25 least popular dvds in stock. I would also like to be able to print and display information on members, dvds and rentals.

  2. ICT Security Report

    System Crashes Also, if the main server of system of the site crashes potential information containing customer's security details can leak out and mean that it would no longer be confidential and can also mean that people could obtain it.

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