¬¬¬ | Grading Criteria Page Number Met Page Number Met Page Number Met P3.1 M2.7(a) D3.7 P3.2 M2.7(b) P3.3 P3.4 First Submission Feedback Tutor’s comments Action required Student’s comments School of Computing and IT BTEC L5 HND DIPLOMA IN COMPUTING AND SYSTEMS DEVELOPMENT Unit 9: Systems Analysis and Design Case Study The Jordans Library is located in a remote village called Jordans in Buckinghamshire. Currently it has about 300 members. A person, who is 18 or above can become a member. There is a membership fee of £20 for a year. There is a form to be filled in which person fills personal details. These forms are kept in store for maintaining members’ records and knowing the membership period. A member can issue a maximum of three books. He/she has three cards to issue books. Against each card a member can issue one book from library. Whenever a member wishes to issue a book and there are spare cards, then the book is issued. Otherwise that request is not entertained. Each book is to be returned on the specified due date. If a member fails to return a book on the specified date, a fine of £1 per day after the due return date is charged. If in case a card gets lost then a duplicate card is issued. Accounts are maintained for the membership fees and money collected from the fines. There are two librarians for books return and issue transaction. Approximately 100 members come to library daily to issue and return books. There are 5000 books available out of which 1000 books are for reference and cannot be issued. Records for the books in the library are maintained. These records contain details about the publisher, author, subject, language, etc. There are suppliers that supply books to the library. Library maintains records of these suppliers. Many reports are also produced. These reports are for details of the books available in the library, financial details, members’ details, and supplier’s details. Currently all functions of the library are done manually. Even the records are maintained on papers. Now day by day members are increasing due to a large development which has taken place on the outskirts of the village. Maintaining manual records is becoming difficult task. There are other problems also that the library staff is facing. For example, when issuing duplicate cards to a member, it is very difficult to check whether their problem is genuine. Sometimes the library staff member needs to know about the status of a book as to whether it is issued or not. So to perform this kind of search is very difficult in a manual system. Also management requires reports for books issued, books in the library, members, and accounts. Manually producing the reports is a cumbersome job when there are hundreds and thousands of records. Management plans to expand the library, in terms of books, number of members and finally the revenue generated. It is observed that every month there are at least 50-100 requests for membership. For the last two months the library has not entertained requests for the new membership as it was difficult to manage the existing 300 members manually. With the expansion plans, the management of the library aims to increase its members at the rate of 75 per month. It also plans to increase the membership fees from £20 to £50 for yearly and £30 for half year, in order to provide its members better services, which includes increase in number of books from 3 to 4. Due to the problems faced by the library staff and its expansion plans, the management is planning to have a system: 1. that would eradicate the needs of cards. 2. to automate the functions of record keeping and report generation. 3. which could help in executing the different searches in a faster manner. 4. to handle the financial details. You work for Buckinghamshire County Council in Aylesbury as a Systems Analyst. The Project Manager on your team has asked you to go to the library and perform full systems investigation.   Task 1 a) Read the case study carefully and establish which requirements analysis techniques you will apply to this case study and why? (BPA, BPI or BPE) b) Produce a list of questions which will enable you to gather further information from the library management and conduct an interview with your tutor. When designing questions make sure you think about functional and non-functional requirements. (M2.7a) As part of the systems investigation, you will visit a library which is already automated (Dynix Sirsi – library system). This will help you to broaden your investigation. Criteria covered : P3.1a, P3.2a, M2.7a Task 2 a) Construct level 1 data flow diagram of the current system. b) Explain the data flow diagram using structured English. Criteria covered: P3.1b, P3.3a, P3.2a c) Produce a feasibility study report using at least three predefined criteria. Criteria covered: D3.7 Task 3 a) Now that you have gathered all the relevant information from variety of sources, produce a Requirements Specification Report which includes functional and non-requirements, scope, objectives, inputs, outputs, processes and limitations. (P3.3b, P3.2a) b) Construct level 1 and level 2 data flow diagram of the proposed system. This should be accompanied by pseudo code/structured English. (M2.7b) Criteria covered : P3.3b, P3.2a, M2.7b   Contextualised Grading Note: failure to complete a pass criterion will lead to failure of the entire unit. Learning Outcome 3 Be able to perform a systems investigation M2.7 appropriate learning methods/techniques have been applied. Task 1 (b) Produce a list of questions which will enable you to gather further information from the library management and conduct an interview with your tutor. When designing questions make sure you think about functional and non functional requirements. (M2.7a) Task 3 (b) Construct level 1 and level 2 data flow diagram of the proposed system. This should be accompanied by pseudo code. (M2.7b) D3.7 effective thinking has taken place in unfamiliar contexts. Produce a feasibility study report using at least three predefined criteria. BTEC HIGHER NATIONAL IN COMPUTING Unit 9: Systems Analysis and Design Assessment guidance Outcomes To achieve a pass grade the evidence must show that the learner is able to: To achieve a merit grade the evidence must show that the learner is able to: To achieve a distinction grade the evidence must show that the learner is able to: LO3 Be able to perform a systems investigation P3.1 Undertake a systems investigation to meet a business need. M2.7 Appropriate learning methods/techniques have been applied. D3.7 Effective thinking has taken place in unfamiliar contexts. P3.2 Use appropriate systems analysis tools and techniques to carry out a systems investigation P3.3 Create documentation to support a systems investigation P3.4 Evaluate how user and systems requirements have been addressed. APPENDIX D – HARVARD REFERENCING SYSTEM What is a Bibliography? A bibliography is a list of all the books, articles and non-book materials such as CD-ROM and World Wide Web/internet that you have used in preparing for your assignment. It appears at the end of your piece of work in alphabetical order by authors’ surnames. Why you should include a Bibliography It is essential to acknowledge the sources you have used for your assignment because of the following reasons: • To avoid accusations of plagiarism • To enable readers to retrieve more information about the subject by using your bibliography • Support the basis of your research How to compile your Bibliography There are many different methods or systems for compiling bibliography. We recommend you to use the Harvard Referencing System. Why Harvard? Harvard is one of the most widely used methods internationally and has advantages of simplicity, clarity and ease of use for both author and reader. Once a method has been chosen, it is important to use it consistently. There are three styles in common use to highlight the key element of a reference; they are the use of bold text, underlining and italics. You should use only one of these techniques throughout your bibliography. The Harvard Referencing System In this system, the sources that you refer to in your text should be cited by author’s name followed by the year of publication in brackets e.g. Bell (1993). All references should then be listed alphabetically by author at the end of your work. For books, you will need the following information: • Author’s (or editor’s) first name (or initials) and surname • Year of publication • Edition (if not first) – see * over for example • Title of book • Place of publication • Publisher’s name For Articles, you will need the following information: • Author’s first name (or initials) and surname • Year of publication; any other dates • Title of article • Name of journal, magazine or paper • Volume and part numbers • Page numbers Here is an example of a book entry, showing the correct layout, typeface and punctuation: Surname first, then a comma, then first name or initials Place of publication, followed by a comma Northedge, Andrew (1990) The Good Study Guide, Milton Keynes, Open University Press. Year of publication in numbers, in brackets, then edition no. (if not first) – see* over. Title in italics (if typed) or underlined (if hand-written), followed by a comma. Name of publisher, then a full stop. Here is an example of a journal entry, with guidelines, as above: Surname, then a comma, then first name or initials. Article title in inverted commas, then a comma; capital letters only on first letter and proper name. Volume and number ( in brackets) plus a comma, then any other dates e.g. May, spring, plus a comma Peeke, G.H.(1984) ‘The teacher as researcher’, Educational Research, 26 (1) pp.24–26. Year in numbers, in brackets Name of journal in italics followed by a comma p. or pp. with page numbers separated by a dash, then a full stop Examples for using Harvard System 1. Books: Gates, B. (1996) The Road Ahead, Second edition, California, Penquin Books. Smith, J. et al (1987) Building Construction Management, London, University of London Press. (note: when there are three or more authors, add “et al” meaning “and others”) Smith. H. (ed) (1990) How to write a C.V. London, Penquin Books. (note: If this is an editor, add (ed) after the name) National Curriculum Council (1990) Curriculum guidance 3: the whole curriculum. York, National Curriculum Council. (note: If no author/editor available, organisation would be regarded as author) 2. Articles in journals/periodicals AND newspaper articles: Graham-Rowe, D (2001) “Saving the Planet”, New Scientist, Vol.170 (2296). P4. 3. Articles in books: Smith, J.R. (1983) “Coputers in the Classromm”, in Richard, J & Morris, R (ed) Computers in Education, Oxford, Pergamon. 4. Government publications: Department of the Environment. (1986) Land filling wastes, London, HMSO. 5. Videos/TV/Radio Programmes: Fragile Earth, (1985) South American wetland, Henley-on-Thames, Watchword Videos (VHS Video) Voyage to the Antarctic, (1996) BBC, London, 27 September 1996 6. CD-Roms: Lewis, J. (1994) “Elephants”. Collier’s Multimedia Encyclopedia. CD-Rom, Collier. 7. World Wide Web/Internet Documents: Holland, M (1996) Harvard System, Poole, Bournemouth University. Available: http://www.Bournemouth.ac.uk/service-depts/lis/LIS Pub/harvardsys.html (Accessed 22 August 1997) If you can’t find the personal name/organisation responsible for the document , use “Title page” and Title of site instead. “Writing a bibliography” (2000) The University of Sheffield. Available: http://www.shef.ac.uk/library/libdocs/ml-rs11.html (Accessed 4 September 2001) 8. Electronic Journal Articles: Smith, J (1996) “Time to go home”. Journal of Hyperactivity (Internet) 12 October, 6(4), p122-3. Available: http://www.Imu.ac.uk.html (Accessed 6 June 1997) 9. Interviews: Fletcher, Dorothy (1995) Interviewed by Jean Macbeth, 19 August