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

  2. Database Design

    The primary key for the Product entity is the Product ID, and Supplier ID for the Supplier entity. This is because they are unique to their entities. All these tables are linked by at least one field or attribute. The entity relationship diagram shows us how the entities are linked together.

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

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

    My first sort assumes that the manager wants to sort the people in DoB descending and length of membership. 2. My second sort assumes that the manager wants to sort the people's phone number ascending. 3. My third sort assumes that the manager wants to sort the people in height descending and age ascending.

  1. An analytical report to discuss the HEG Infoway project, its implementation and the reasons ...

    When the "System Requirement Specification" was send to the client, which was having the full scope of the project, they just signed it without even reading it properly. They might have thought it's the group company and they will keep the requirement changing as and when required.

  2. Designing a booking system for an Estate Agent.

    A big disadvantage is that this doesn't prevent double booking. Several clients might book for a same time of property viewings but also with different negotiators. This will create a problem with the organisations time management as one would have to give up their time slot also creating disappointment for the other client.

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

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

    If I feel that something interesting arises from a response to one of my questions, I will pursue that line of enquiry but that is the only circumstance under which I will digress from my main list of questioning. I will take a notepad with me during the interview to record his answers to my questions.

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