INFO6002 INFO6002 Assignment 1 - Sample requirements specification Here are sample formats for the Requirements section for Assignment 1. This is done for a library system to give you an understanding...

Database ER Diagram, Please check the files.


INFO6002 INFO6002 Assignment 1 - Sample requirements specification Here are sample formats for the Requirements section for Assignment 1. This is done for a library system to give you an understanding of the format that your answers will be in. However ,your answers will be for the assignment scenario of Office Wizard. Note that these are only samples. Your assignment answers will be more extensive than these. Part 1: Sample Requirements 1. Data Requirements Catalogue The library maintains information about its physical and online information sources. The library has many types of physical resources that it maintains which include: books, journals, videorecording, sound recordings, microform materials and theses of the university. Collections There are many collections in each library. A collection consists of unique name – “Auchmuty – Serials”, etc. and specifies the location where the collection exists physically in the library. A physical item in the library belongs to a collection. 2. Transaction Requirements a) Data Manipulation Operations * Insert/update/delete an item in the library * Insert/update/delete a copy of item in the library * Insert/update/delete an online information source * Insert/update/delete members * Insert/update/delete member types b) Queries * Search an item based on call number, keyword, author, title, subject and journal title (keyword) * List present loans by a particular member * List frequently loaned items for each semester * Fines report containing information about fines levied and members fined * Report of items overdue and members who have overdue items * List acquisition requests for the last week * List acquisition requests that are satisfied during last month * List current hold requests by a particular member * List short loan reservations made by a particular member within a given period 3. Business Rules A book can only be borrowed by one person at a time. The loan period for a book is two weeks. A member cannot make a hold request if they have more than $20 of outstanding fines. A member can make a maximum of 5 hold requests.
May 17, 2021
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here